Skip to Content

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

Calculation on hierarchy nodes

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

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