ReportStudio Hierarchy vs Framework Manager

[magicksol13]

Hi there, can we create a Hierarchy in ReportStudio instead of doing it in Framework Manager? Thank you all.

Ex:
President
__ViCePresident
____Director
_____Employee

[BZboy]

Hello

Have you tried creating a cascading prompt in Report Studio? Using a cascading prompt in Report Studio will allow a user to select:
"President", then "Vice President", then "Director", etc etc.

Make each prompt dependent on the previous prompts values and that will show the hierachy

[magicksol13]

Hi BZboy,

More precisely i already have a LIST object displaying information for "only" VicePresident:
__VicePresident

i also already have a list object displaying information for "only" Directors:
____Directors


i NOW need to :
create a LIST object in my report to display employee information "all the way down from" VicePresident for example:
__VicePresident
____Directors
_____Employees


Then,i also need to create a LIST object in my report to display employee imformation "all the way down from" Director for example:
____Directors
_____Employee

etc...

Does your suggestion till valuable for what i'm trying to acheive ?

[BZboy]

Hello. It all depends. Need to know more info.

Are these fields in the database already setup to the level of hierarchy that you want?

When you add these columns to the list report (as separate list objects) as you mentioned below, and then run the report, does the hierarchy show correct?

[magicksol13]

Hi BZboy,

Are these fields in the database already setup to the level of hierarchy that you want?
Answer: There is 1 data item column called 【SuperiorID】 that allows us to navigate from 1 level to another one. There is no hierarcy created in the model. So does it still means that yes the items are in a hierarchy in the db?

I have 1 list object that displays only VicePresident information
I have 1 list object that displays only Directors information.

The problem is i now need to create a list that shows Information for Directors and Employees which are both in different professioanl hierarchies.

[magicksol13]

Anyone esle willing to help? Thanks.

[BZboy]

First off, my suggestion is to have the hierarchy created at the database level. Are you saying that the different Columns: President, Vice president, Director etc etc are all coming from different tables in the database? If that's the case then they need to be related somehow via join, and then go from there. If you don't have access to do this, you would probably need to have the dba handle this. Typically the hierarchy is created in the database first, prior to building reports in Cognos. It makes things much easier