Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

hierarchy in query, how copy values from parent nodes to children nodes

Hello,

imagine a 0cust_sales hierarchy with a structure like this:

~root

__customer_group_1

____customer_11

____customer_12

__customer_group_2

____customer_21

____customer_22

the nodes are all postable. thus, able to contain values.

in a cube, i have stored key figures for the parent nodes, customer_group_1 and customer_group_2. (the key figures stored may be amount = 40, for example).

the children nodes are not contained in the cube and therefore do not have these key figures.

now in a query, the key figures for the parent nodes are filled and for the children nodes they are empty.

i would like the children nodes to have the same key figure values as they parent nodes. i do not have an influence on the modeling of the cube. thus, i want to solve this on the query level.

i was thinking about a calculated key figure, using a variable with customer exit. in the customer exit, i would check, whether the key figure is empty and copy the value from the parent node. i am not quite sure if this will work.

any thoughts or other ideas?

regards,

stefan

Former Member
Not what you were looking for? View more on this topic or Ask a question