May 12, 2003 at 12:22 am
Hello,
I have a situation like this. In the foodmart 2000 sample database, we have the sales cube and there is a dimension called "TIME".
In the Quarter level of this time dimension, I need the sums in aggregated level. For example, Q1 has the sum of months 1,2 and 3. Q2 has the Q1 value+4+5+6 and Q3 has Q2+7+8+9 and Q4 has Q3+10+11+12.
Please ask me if you need any further clarifications. Kindly let me know if you have any clue how to do it. I am sure it is possible with custom rollup formula but I don't have enough exposture to that area yet.
Thanks in advance,
Anbu
May 12, 2003 at 3:34 am
The simpler solution would be to add a column to the fact table as " YTD Sales"
May 12, 2003 at 3:34 am
The simpler solution would be to add a column to the fact table as " YTD Sales"
May 12, 2003 at 4:02 am
Create a calculated Member with
the formula
Sum( YTD(), [Measure].[unit sales])
May 12, 2003 at 4:03 am
Create a calculated Member with
the formula
Sum( YTD(), [Measure].[unit sales])
May 12, 2003 at 4:22 am
Thanks for your reply. But how can I use the same when I have the same situation like this for a customer dimension?
May 14, 2003 at 8:29 am
Anbu, I am not to sure what you want to do with the dimension. Please explain
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply