I have a cube that contains a Product Age Dimension with the following values:
00-1W = Products in 1st Week of Sales
01-NR = Products in Weeks 2 - 4 of Sales
02-RR = Products in Weeks 5 – 8 of Release
I wish to combine these elements into another group in Report Studio.
In my query, I create a calculated member called First 8 Weeks of Sales which is defined as [00-1W] + [01-NR] + [02-RR]
This works excellently for any elements that total, but percentage values seem to sum too!!
Also, in my cube, I have a dimension called Year that contains TY, LY, and LLY.
The Year dimension also contains calculated categories TY% and LY% which calculate the percentage variance for TY over LY and LY over LLY respectively.
The TY% and LY% for the First 8 Weeks of Sales group are also totalling!
You can review in the attached TEST Report Output (look to the far right under First 8 Weeks of Sales).
Hi Adam,
It might be worth trying to create a calculated member in the cube dimension which represents the 3 categories added together (i.e. first 8 weeks), rather than doing the sum in your RS query. This should ensure things aggregate correctly in your report.
Cheers,
Jon