Hierarchy node filtering - BEx 3.5 query

[#1]

Hi

I am having a problem with a BEx 3.5 query with a filter on customer hierarchy. The filter is a variable which allows single value selection.

When I run the query in Analyzer and get prompted for the customer hierarchy I can either type a customer number or press F4 and navigate through the hierarchy structure to find the node I want.

When I press F4 and navigate to the hierarchy nodes I always get data for all nodes I have tried, but when I type in the node number directly in the selection screen I get data for some nodes wheras for others I get "No applicable data found".

When I navigate in the hierarchy I can see that below each node there is a leaf with the same customer number (see example below), and that when I type in a customer hierarchy node number in the selection screen the query chooses the node for some numbers (and data is displayed) and for some numbers chooses the leaf (and no data is displayed).

Example:

0035 (node)

- 0035 (leaf)

- 11003 (leaf)

- 11004 (leaf)

- 11005 (leaf)

It would be preferrable if I could type in the values directly as this would save time. So I would like to know if there is a way to make sure that the node is always selected rather than the leaf, or if it is just random?

All help is much appretiated!

Edited by: christian.nilsson on Sep 28, 2011 5:40 PM

[former_member188080 · Accepted solution]

Hi,

You can try adding one more field in the master data and then in report. You can just populate node level through ABAP program and then you can create variable on that object.

Thanks and regards

Kiran

[Former Member · Accepted solution]

Thanks for your answer, I can see how that would work.

Unfortunately I do not have the time to make these changes, but it seems like there is no easy way of solving this issue.

[former_member188080]

Hi,

When we carry out any search in the hierarchy we do it based on key and text.

So when we put any value say key you have to see whether key is selected in variable or key and text.If it is key and you are putting description nothing will be found.

Once you enter value you will see arrow marked in different colour and you can trace down on that arrow below.

Thanks and regards

Kiran

[Former Member]

Hi

Thanks for the answer. I tried it but unfortunately it did not solve my problem. The issue is that for some hierarchies the leaf is found instead of the node (see my earlier post).

So if there would be a way to only search for only nodes, that could be a solution.

Kind regards