cancel
Showing results for 
Search instead for 
Did you mean: 

Display by default an specific Hierarchy Level

Former Member
0 Kudos

Hi all!

I've got in one of my queries 0ORGUNIT which has hierarchies.  Customer asked me to display this char by default with the level 2 of the hierarchy, is it possible?

I know there's an option in Query Designer "Expand to Level", but I'm not sure what is this for, if this is the maximum levels report can display, or the default level I need.

Can you advise please?

Cheers!

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

best way is to try it out :-), but that displays up to levels not tat the level means it will display 2 levels.. if you want it to display that particular level FLAT only ,i dont think bw queries have the option yet to do that , you wil have to do some type of coding in cmod.. there is a way around i found on Report it self.

right click on the item that has the hierarchy

go to its property

go to its hierarchy tab, click expansion level 1,  as that will give you the .1 level or if u need 2 position the lower node ABOVE and check bos condesntion of lower level nodes. that will SHOW you the top node in the report while hiding the other nodes underneath it..

try that  and good luck