Using Transformer Cube - Calculated Member Percentages?

[adam_mc]

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).

[jonathan.webb@raytheon.co]

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