If you are unable to create a new account, please email support@bspsoftware.com

 

allocating 2 measures to different categories and presenting as one measure

Started by damzI, 02 Jul 2016 09:59:21 PM

Previous topic - Next topic

damzI

Hello Cognos Geeks,
I have a queer requirement for my cognos cube.

I am designing a model in Cognos transformer. The modeling challenge is as follows....

I have a Dimension LMN - with 2 Categories X and Y

the Measures - profit A, profit B (from 2 different columns)

Profit A is allocated to Category X (no child categories) and Profit B is allocated to Category Y (and its child categories)

There are a few more dimensions, which have normal allocations for both measures - Profit A and Profit B.
BTW there are 5 measures in all - the remaining 3 have normal allocations.

Now I need to combine both measures as one Profit(A&B) - so when I use Dimension LMN in the rows the Profits A and B appear in one column "Profits(A&B).

Looking forward to your creative ideas...

Thanks, damzi