dbTalk Databases Forums  

Sponsored Links


microsoft.public.sqlserver.datawarehouse microsoft.public.sqlserver.datawarehouse


Discuss in the microsoft.public.sqlserver.datawarehouse forum.



Post New Thread
Threads in Forum : microsoft.public.sqlserver.datawarehouse Forum Tools
  Rating Thread / Thread Starter Last Post Reverse Sort Order    Replies         Views     
How can I add multiple datasources to a single cube? In other words, how can I join data from several different SQL databases to use in a single cube?
Shawn
12-10-2008 07:11 AM
Ohjoo Kwon Go to last post
40 512
Hi, Is it possible to refresh cube partition of SQL Server Analysis Services 2005, so that the data in the partition gets overwritten? In SQL Server...
honeybee
12-03-2008 06:14 PM
honeybee Go to last post
16 210
I installed a copy of SQL server 2008 Express. I can see SQL Agent from the Server Configuration Manager, but I can't start it - get error. Any...
Yuelin
11-14-2008 02:04 PM
Russell Fields Go to last post
8 165
Hello! As I understand the "unknown member" means that the dimension key is not found in the fact table. In my case, the dimension table IS the...
David
11-10-2008 05:23 AM
David Go to last post
32 263
Hello everyone, I am using Microsoft Dynamics GP Analysis Services on SQL Server 2005. I am using Microsoft Office Excel Add-in for SQL Server...
Abu Owais
11-06-2008 09:45 AM
Ohjoo Kwon Go to last post
24 243
Hello, I have a question/scenario. I'm creating a cube in Analysis Services (which works fine) but my 3rd party control is not showing my data...
Mike
11-04-2008 05:13 PM
Ohjoo Kwon Go to last post
8 67
I realise this is a very general question, but after hours of Googling I am none the wiser. I think I want to use SSAS, because I have views and...
Charles Law
10-27-2008 06:11 PM
Charles Law Go to last post
32 413
Hi, I would like to add another measure into cube which is counting distinct employee_id instead of employee_key (surrogate key) This is the...
Lynn
10-26-2008 07:27 PM
Ohjoo Kwon Go to last post
8 73
My drive on which the olap cubes are built for deployment has ran out of space, so I need to move the mssql.2\olap... dir and all files to...
Carl Henthorn
10-22-2008 12:26 AM
Ohjoo Kwon Go to last post
8 83
Hello, Im working with MDX functions. I would like to calculate the sum from the first month in my Time dimension till current month. e.g Jan 2007...
Vishwanath
10-21-2008 05:51 AM
Ohjoo Kwon Go to last post
8 176
can anyone point me to a routine or util that populates a time_dim table? Given a date range, routine creates all rows for each day in...
Chris
10-17-2008 05:10 PM
Sandra Mueller Go to last post
16 184
This is not a question of a degenerate dimension, I have that implemented and it works fine. I have a cube with three fact tables. each fact...
Jeff Ericson
10-14-2008 11:01 AM
Marco Russo Go to last post
16 336
I am trying to establish Replication wherein my Publisher would be SQL Server 2000 SP3 and the Subscriber / Distributor is SQL Server 2008 I...
John
10-12-2008 10:47 AM
sqlmonkey Go to last post
8 78
Good morning, I have a new application I'm building, and the users want to be able to do some analysis of the data managed by the application. ...
The Man From SQL
10-06-2008 08:06 AM
The Man From SQL Go to last post
24 381
Hi all Our company is expanding into Europe and we need to get some sample databases so we can learn the input methods. We mainly need to learn how...
Holz
10-01-2008 01:04 PM
Marc Scheuner Go to last post
8 78
We have one solution that manages our DW ETL. Every table is it's own package. So we have about 18 packages. What is hard to manage is we have 5...
Joe H
09-29-2008 01:50 PM
Joe H Go to last post
24 272
Is there a way to reverse engineer a cube back into SSAS? Microsoft sent me some demo's many months back but all I had was the .ABF SSAS Cube...
Joe H
09-23-2008 10:11 AM
Joe H Go to last post
16 144
Cube usage (Multi-page thread 1 2 )
How can I determine how much our cubes are being used? Is this all in the SQL log files?
Joe H
09-22-2008 04:23 PM
Joe H Go to last post
16 285
Cognos (Multi-page thread 1 2 3 4 5 )
Anybody using Cognos and have comments on it? Our shop is using SSIS, SSAS and browsing cubes with Excel 2007. But Cognos tool looks like it may...
Joe H
09-11-2008 04:22 PM
Łukasz Go to last post
40 420
All my connections are dynamically set at run time to run against local/dev/qa/prod. The Backup Database Task doesn't seem to have a "Server"...
Joe H
09-08-2008 05:44 PM
Joe H Go to last post
16 225
Hi, I'm required to implement address standardization in my data warehouse. Daily a SQL Server 2005 SSIS package processes a excel file which...
S V Ramakrishna
09-05-2008 09:27 AM
Russell Fields Go to last post
32 255
Hi All, I have a design question . I got the requirement of 2 TB starting for enterprise dataware house in my project. I want to implement next...
S V Ramakrishna
09-04-2008 03:32 AM
S V Ramakrishna Go to last post
16 146
Hi , Is there any difference for disk configuration for OLAP systems in comparison to OLTP ,Please suggest the consideration for disk design and...
sacgar
08-19-2008 07:26 AM
Jeje Go to last post
8 80
I need to load files from different source. They may provide different granularity of dimensions. For example, there is a dimension...
nkw
08-11-2008 02:23 AM
Ricardo Junquera Go to last post
8 76
Can anyone tell me what the best practice is to reindexing a SQL-Server 2005 database that has an extensive number of deletions to it. Thank...
Al
07-25-2008 10:40 AM
Ola Hallengren Go to last post
24 195
hi before years it says that store files on the hard drive and stor only links in databse is that role true till now or new versions of sql work...
Pure Heart
07-22-2008 02:56 PM
Joe H Go to last post
8 78
Does PP actually take care of our ETL process? I always thought I would have to populate the DW then PP would take it from there. The...
Joe H
07-19-2008 09:51 PM
Jim Hummer Go to last post
16 154
Had a question about how folks are managing "change management" on their DW projects. One of the biggest problems we face on the DW, is most of...
Joe H
07-16-2008 03:43 PM
Joe H Go to last post
48 240
I need to store our ASP files into a SQL 2005 database. Average file size is about 35 KB. Could someone please explain an easy way to store text...
Nam
07-10-2008 07:33 PM
Jeje Go to last post
16 144
Is it necessary to install sqlserver cal licenses on the server machine. We have purchased sqlserver standard edition with three cal We have...
Cdude
07-10-2008 01:32 AM
Cdude Go to last post
16 365
Hello Community, I'm a new comer in MS DW/BI stream. Can anyone please suggest me some good books/links on Analysis Services 2K5? And also similar...
Bhushan
06-30-2008 05:15 AM
Bhushan Go to last post
16 284
Does anybody know why searching for a string '@' with LIKE does not work even when you use ESCAPE Very strange...... Say the field has ..... I...
Travis McGee
06-29-2008 10:02 AM
Travis McGee Go to last post
16 112
Fact Tables (Multi-page thread 1 2 3 4 )
Was looking at Kimball SSIS templates and note that when he is updating Fact tables, he first dumps the original extract into an "extract" table,...
Joe H
06-23-2008 05:59 PM
Michael Coles Go to last post
32 403
The company I work for track refinery capcities around the world and what to put this data into a data warehouse. At first glance it looks simple...
JamesCarters
06-21-2008 01:24 PM
Michael Coles Go to last post
8 101
I would highly appreciate if anyone provide me any website from where I can get the quick idea to create cubes in SQL Server and add that cube in...
Noor
06-20-2008 12:01 PM
Eric Russell Go to last post
16 255
What are folks using to manage your metadata? We were thinking of possibly coming up with something custom to manage all our 10 to 12 different...
Joe H
06-20-2008 11:49 AM
Eric Russell Go to last post
8 128
Hi, the customer wants to measure the time of some processes. E. g. you produce cars: Before the car leaves the factory their is a final control. In...
florian
06-18-2008 08:53 AM
naggy Go to last post
32 209
Hi, SSAS 2005. I am trying to view the cube data from Excel through HTTP Connection with 'Basic Authentication' ticked for Authentication method,...
John Jayaseelan
06-18-2008 05:02 AM
John Jayaseelan Go to last post
8 56
Hi, SSAS 2005. I am trying to view the cube data from Excel through Cube data with 'Basic Authentication' ticked for Authentication method, but...
John Jayaseelan
06-18-2008 04:48 AM
John Jayaseelan Go to last post
8 73
Hi guys! In my dimension I have included an attribute "CustomerName" which I only use for securing dimension data belonging to different...
David
06-13-2008 10:57 AM
Tom Dacon Go to last post
8 103
Our business is we have contracts, which one to many contractors can work on. I have a working cube for the contracts and 3 measures...
Joe H
05-31-2008 08:28 PM
Marco Russo Go to last post
8 157
USE GO /****** Object: StoredProcedure . Script Date: 05/20/2008 11:02:24 ******/ SET ANSI_NULLS OFF GO SET QUOTED_IDENTIFIER OFF GO ALTER...
Cdude
05-25-2008 08:47 PM
Nigel Rivett Go to last post
8 59
When profiling our data sources - we discover what OLTP sources have what percentages of NULL values for given columns. My rule of thumb was, if...
Joe H
05-25-2008 06:08 PM
Nigel Rivett Go to last post
8 54
This place seems pretty quiet, where else do people go for data warehouse queries?
JamesCarters
05-24-2008 06:19 AM
JamesCarters Go to last post
8 73
We have a SQL table that consists of several fields, one of which we know is an XML dump from a table. The thing is, we don't know how to extract...
James
05-23-2008 11:43 PM
Mike C# Go to last post
32 222
I have two fact tables, ContractFact and FundFact. In my DSV, I created a relationship to join them on a field that is in both, called...
Joe H
05-22-2008 02:30 AM
Marco Russo Go to last post
8 94
Hi, I am a newbie and I have been studying DW for a while and I've successfully built some cubes. There is still one thing I am not sure how to...
Ed
05-16-2008 04:45 AM
Tomasz Borawski Go to last post
48 502
help,a difficult text how to sql table code ? i have a text as follow, line with |and...
agiler
05-10-2008 12:03 PM
Knowledgy Go to last post
8 162
I have a Dell machine i have installed a C#.net application on it. When i try access sqlserver on the server over the network i am unable to connect....
Cdude
05-10-2008 12:02 PM
Knowledgy Go to last post
8 58
I have a parent table with a column I want to drive partitioning off, but the child tables, as you can guess don't have that same information in...
Benny
04-25-2008 08:54 AM
naggy Go to last post
24 161
Post New Thread

Display Options
Showing threads 51 to 100 of 1147
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.