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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.