Skip to Content
Former Member
Oct 30, 2007 at 03:37 PM

Issue when selecting hierarchy in query


Hi All,

I have a small issue when i run the report selecting a hierarchy.

we have a hierarchy for profit center and it has upto sex levels of nodes(level1, level2 etc...) and under each level we have few nodes.

When i run the report in the web selecting a particuar node , it gives me correct values only for that node but

When i run the query in the web selecting a particular level(level1/level2), report gives me values for the entire hierarchy ( all levels) not for the selected level.

FYI, when i run the same report , in BEx Analyser,selecting a level it gives me the correct infomation only for that level.

I am not sure if there are any settings needs to checked to display the selected level in the web.