cancel
Showing results for 
Search instead for 
Did you mean: 

Display as Hierarchy

Former Member
0 Kudos

Hello,

We're trying the BEx option "Display as Hierarchy" (right click above the rows box in query designer and choose "Display as Hierarchy") -- this displays all characteristics in a hierarchy.

Anyway, after doing this to a query, the initial data screen returned looks fine, but when we drilldown on any other characteristic, we get no results ("No applicable data found").

Any ideas why this may be happening?

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

This appears to be a bug in BEx. We've logged a call for SAP support.

josko_poljak
Participant
0 Kudos

Larry,

did you find out how to solve this problem? I have recently upgrsded to BEx Analyzer 7.1 but problem remains.

Kind regards, Josko.

Former Member
0 Kudos

Hello Larry,

Your drilled charactersitics might not have a hierarchy or value. So you are getting no results ("No applicable data found").

Check the infoobject first with Tcode RSD1 that have hier. and then check the cube content.

Sarhan.

Former Member
0 Kudos

Thanks Sarhan, but let me clarify. The characteristics do not have hierarchies, but BEx allows the entire report to be displayed as a hierarchy. Following is from the help documentation:

Display as Hierarchy

In the Query Designer, you can specify for each axis that all objects on an axis (structures, characteristics with or without display hierarchies) are displayed as individual hierarchies.

In the Query Designer, use the right mouse button in the context menu for the row or column and choose Display as Hierarchy. You can also set up the Start Expand Level from the context menu, that is, to what hierarchy level you want to drilldown to in the initial view. To do this, choose Expand to…

You can use this function to display multiple drilldowns, for example, Country, Region, Town, although there is no display hierarchy.

As an additional example, you can display the cost center and the cost element hierarchy in one hierarchy.

<a href="http://help.sap.com/saphelp_sem40bw/helpdata/EN/0b/f584409db95537e10000000a1550b0/frameset.htm">http://help.sap.com/saphelp_sem40bw/helpdata/EN/0b/f584409db95537e10000000a1550b0/frameset.htm</a>