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