I am new in DW and开发者_运维知识库 I have a simple question. Imagine that I want to create a DW to analytical CRM.
I have date time field in a fact table in the format MM/开发者_运维问答DD/YY HH:MM:SS (e.g 2/24/2009 11:18:47 AM) and I have seperate date and time dimension
I know generally its not good idea to have a DateTime column as your PK, however for my situation I believe it makes more sense than having a surrogate key in the Fact Table.
Is there a standard via which one should start an analysis services project? Out situation is that we work locally on our machines, and the relational DB is out of our domain - and the server that ana
We have 8 million row table and we need to add a sequential id column to it. It is used for data warehousing.
.What is the difference between reporting and analysis in datawarehousing? Both are giving output with drill down(hierar开发者_Go百科chy) and i am feeling similar in the case of outputs.They are disti
Creating a location dimension table for the DW; I am familar with date/time but for location I am using these columns: Continent, Country, Region, City, Postal. Now the question is what if a record do
I have these tables: DimDate (PK: DateKey, other attributes) FactActivationCodes (PK: ActivationCode, IssuedDateKey (FK to DimDate)
What is the best way of MDX querying for each drill down of BI dash board c开发者_开发问答hart? as a example if you have four drill level every drill down we should execute four MDX query or execute o
Is it pos开发者_运维百科sible to have a attribute hierarchy where the parent doesn\'t always have children? If so, how is this achieved in SQL server Analysis Services?Never mind - found the solution:
加载中,请稍侯......