Showing results for 
Search instead for 
Did you mean: 

Problem with hierarchy node variable

Former Member
0 Kudos

I 'm using a hierarchy node variable in the query. This variable refers to a hierarchy which has been defined in the definition of the query. BUT All Hierarchy nodes are not displayed in value help of variable screen.

Can anyone help me out with this...



Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Dear advait Rao ..

My sap user has full authorize (0BI_ALL)

Dear Choudhary S

In Business Expolrer TAB , It 's taking Query Def.Filter Value Selection = M (Value in Master Data table) and Query Execution Filter Val. Selectn = M (Value in Master Data table) too.


After I run program RRINCLTAB_REBUILD (Follow on SAP Note 922467) , Hierarchy that has characteristic node can display in value help of variable screen BUT Hierarchy that has only text node are not displayed in value help of variable screen

Anybody know,how to set the hierarchy for display all node (include text node that don't have characteristic node as a leave node)

Thank you very much

Former Member
0 Kudos


Check the Infoobject (using for hierarchy) settings (Under Business Explorere tab).

Check from where it is taking the filter value slections (Master data or Info provider).

It can be due to non availabilty of data in infoprovider and settings done for the same.

I hope it helps.



0 Kudos


Did you check if there are analysis authorizations involved in this scenario?

I mean did you confirm if there are any Hierarchy node related authorizations involved for your id or role that you are assigned to?