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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.