on 2017 Jan 13 2:38 PM
Hi,
We have made changes in existing hierarchy.
Two child nodes have been added.
Hierarchy loads correctly to SAP BW but when we run the bex query it does not show new nodes , while selecting the value of hierarchy variable value.
There is no data posted for this node in the cube.
I want to ask if we have hierarchy change will it only show the values to filter on hierarchy variable , if there is value posted against it?
I have followed the below thread but no conclusion is there.
https://archive.sap.com/discussions/thread/3819981
Please suggest.
Thanks !
Hi,
If no entries exist for the hierarchy leaves then you will not be able to see them in the query result. When creating a hierarchy in query designer and restricting the char on the hierarchy, you should be able to see the whole hierarchy, if this is the case, the hierarchy is well represented on report level.
Grtz
Koen
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
71 | |
11 | |
11 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.