Difference between hierarchy node and single value

[Former Member]

Hi experts,

Can anyone explain me the difference between hierarchy node and single value?

This is my problem:

I have a query that uses a characteristic (0ORGUNIT) with a hierarchy and I execute it without any problem but when I try to set a fliter on this characteristic and I try to find a single value, for example 101, it doesn't appear in the single value list, instead it appears in the hierarchy nodes list in the selection window.

I think I'm confused about both terms because I thought a hierarchy node was always the one who has one or more values as its lower levels like this:

A. 10

A1. 100

A2. 101

A3. 102

A3.1. 1021

B. 11

I this case I thought , for example, 101 was a single value but not a hierarchy node so I must find it in the single values list in the selection window, however, 102 can be both and must appear in both lists, is it true?

Thanks in advanced

[Former Member]

In BW, hierarchy node with more information compare to the single value. for example, it always carries its father node information, which it belongs to. and some time information if it is time-dependent.

So, when you using hierarchy node, it means at least 2 information: value and "position" (who is its father node)

That's the reason why you see the hierarchy tree when choosing the node.

If you want to expand the hierarchy to the certain level, you can setting in the property. Another choice is restrict in the query designer.