Tree Structure is not shown when the Hierarchy object is pulled into the WebI report layout

[Former Member]

Hi,

Created BEx Hierarchy node Variable for the info object Profit Centre and activated the hierarchy for the same.

In WebI prompt selection Profit Centre Hierarchy Variable is displayed as tree structure without any issues and when I pull in the Hierarchy object into the result panel I could see the Member Selector dropdown and by default all the members are selected as this object is available in the prompt.

Reference URL - http://scn.sap.com/thread/3340706

http://scn.sap.com/docs/DOC-58910

I selected all the values in the Hierarchy Prompt and When I bring in the Hierarchy object in the report layout only the parent node is visible with no tree structure. Wherein for the same prompt selection I could see data (as tree struct in Analyzer & RSRT).

Am I missing any settings in BEx or in BO side? Kindly provide your inputs.

Thanks,

Jyothi

[Former Member]

Hi, try to change Hirarchy parameter (Expand to Level) in BEx Query.

[Former Member]

Already Expand to Level has been set to max limit and I believe usage of Expand to level settings determine to which level the Hierarchy object to be drilled down at initial view. It wont have an impact on WebI.