Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Aggregate data from Fact Table
Alan, Thanks for the reply. As of now, we have multiple fact tables, one for each level, and users have to pick the corresponding mesaure from the measure group. However, it is very confusing to the users to pick the corresponding measure for the level which he picks. We have two measure...- sagargoli
- Post #3
- Forum: Microsoft SQL Server: Analysis Services (OLAP)
-
Aggregate data from Fact Table
I have a scenario where the measure is stored at two different levels (Product and Group) in the fact tables, as the measure is non aggregatable and follows certain rules to calculate the value at group level. Here is the sample data Fact_Product Product CycleTime P1 50 P2...- sagargoli
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Analysis Services (OLAP)
-
Joining facts to multiple levels in the same dimension
I am sorry, I missed to include that information. I am using Microsoft SSAS Cube.- sagargoli
- Post #3
- Forum: Data Warehousing/Big Data
-
Joining facts to multiple levels in the same dimension
The following thread was posted in June 20008 (thread353-1479467) http://www.tek-tips.com/viewthread.cfm?qid=1479467&page=1 I have a scenario where the measure is stored at two different levels (Product and Group) in the fact tables, as the measure is a non aggregatable. Here is the sample...- sagargoli
- Thread
- Replies: 2
- Forum: Data Warehousing/Big Data
