Dear experts,
Does anybody know how to change the values of nodes in hierarchies in BEx Query Designer?
I enclose an example to explain my problem:
Node A = 100 (50+50)
A.1 = 50
A.2 = 50
The behaviour of the hierarchy is to add the two values = 100.
Is it possible to make calculations in the hierarchy to represent in the query the following result in Node A ??
Node A = 250 (A.1 * 3 + A.2 * 2)
A.1 = 50
A.2 = 50
Just to give more details, the hierarchy has been done with 2 different infoobjects.
Thanks in advance,
Ivan