Hide lowest level in a hierarchy

ole2002ole

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

chenbaolei

Do you need the data to be loaded at the lowest level? ie is there someone else who does view it at that level?

If not:-

Load directly to the higher level by having a "reference dimension", this either exists outside of any cube and contains elements for all of the "level 5" element and an attribute stating what level 4 they belong to. You could also add it into a 2-dim cube with the other dim containing 1 string element and hold the "level 4" group in there instead.

When the TI does the loading have it reference what level 4 it should go to and accumulate them into that level in your main cube. Obviously with this method your main cubes dimension doesn't have a level 5 and level 4 is its lowest level.


If you do need it in TM1 at level 5:-

A/ Use security to let certain users only have read access to level 4 - level 1, and no access to level 5.

or

B/ Create an extra cube with all the same dims except the one in question which is replaced with a dim that only has Level 4 - Level 1.
Rule drive the elements from your "full" input cube to this summarised one and only give users access to the summary cube.

HTH