Dynamically setting default opening level in hierarchy in cognos

[chitresh]

Hi,

We have an Orgs hierarchy in Finance, and we wish to grant access to users only to levels (including respective child levels) which they belong. For example, User A may see all levels, but User B should only see Level 2 and underneath etc.

I am able to achieve this, but the only remaining issue is to directly allow the hierarchy to start at Level 2 instead of drilling down from All Levels - Level 1 - Level 2. The user should directly see their respective level. Can we set this up dynamically?

Thanks
CS

[CognosPaul]

This can be done on the cube level. Once you set this up you'll need to pass user information directly to the cube. What type of cube are you using? The procedures for doing this differ drastically depending on the technology.

[chitresh]

Hi Paul,

Unfortunately, we do not use cubes. This is a DMR package created using Framework Manager.

Thanks,
CS

[CognosPaul]

Unfortunately I'm not as familiar with DMR as I probably should be. I prefer to build a fully relational model for detail reports, and a real cube for all other needed reports and adhoc queries.

I don't think you can set object security on hierarchies in DMR. You can easily set up data security to limit users to only their organizations.  You can also set up reports to default on the topmost level the user should see. Unfortunately that won't help with adhoc querying like QS and AS.


Maybe what you could do is base your hierarchy on levels that change where they're pointing based on the user logging in. The level name will still be static, but at least the data will be correct.