COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS Transformer => Topic started by: sriatcognoise on 14 Mar 2011 08:03:32 AM

Title: unbalanced hierarchy in transformer 8.3
Post by: sriatcognoise on 14 Mar 2011 08:03:32 AM

We have varying levels in our organization sales positions allignment: example:
Nation -> Region -> state -> sub-state -> DM -> S-DM-> representative
Nation -> Region -> state -> DM -> S-DM-> representative
Nation -> Region -> state -> DM -> representative
Nation -> Region -> state -> sub-state -> DM -> representative

There are multiple levels and the least/leaf is at 5th or 6th or 7th level ... it varies.

How do we model such an geography - alignment in powerplay transformer 8.3?

thanks,
Srikanth