Skip to Content
0

SAP BW Hierarchy changes not reflecting in Bex

Jan 13, 2017 at 02:38 PM

62

avatar image

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 !

10 |10000 characters needed characters left characters exceeded

Hi,

did you execute Hierarchy/Attribute change for reporting?

Regards,

Aanand

0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Koen Hesters Jan 26, 2017 at 08:02 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded