|
Hi gurus
I'm using a TI-process to fill an hierarchy. Since I'm getting data from a star schema the ID column is the lowest level but this is not something I want to show the users drilling the dimension.
Let's look at the account hierarchy for instance.
Level 1 - 4
Level 2 - 41
Level 3 - 411
Level 4 - 4111. ( this is will be the lowest visible level for the user )
Level 5 - x ( this is an arbitrary number that will change but it should not be shown if the user drills on 4111 but the data is loaded to this level)
Is there a way of doing this using a TI?
I'm using cognos 10 BI ontop of this so I won't be able to use subsets.
Br
Peter |
|