hierarchy in query, how copy values from parent nodes to children nodes
imagine a 0cust_sales hierarchy with a structure like this:
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?