Hide lowest level in a hierarchy

[A.Pete]

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

[declanr]

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