Issue when selecting hierarchy in query

[Former Member]

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.

Regards,

Kumar

[Former Member · Accepted solution]

Kumar,

Has your hierarchy been setup with time dependant values on it?

Go into the Info Object in RSA1 - look at the Hierarchies tab and see if there are any Time Dependencies there.

Regards

Gill

[Former Member]

Hi kumar,

Make sure that you select the same hierarchy in <b>Hierarchy name</b> in Display heirarchy in properties of profit center and if you are restricting the profit center with variable, choose the same name in the window <b>From hierarchy</b> in selection for profit center.

**Assign points if helpful**

Peter R

[Former Member]

Hi Peter,

We are doing exactly what was told by you but still I am having the same old issue while runnning the report.

Regards,

Kumar