Skip to Content
avatar image
Former Member

How to dynamically calculate a virtual key figure depending on the navigation step on the query


I want to calculate a virtual key figure dynamically according to the displayed dimensions by the user in the report.

Example :

So if the user chooses to display Plant and Material in the report , the result of the virtual key figure will be calculated as shown in the first table

But if the user removes the Material axis, the stock will be aggregated to 30 (normal) but the virtual key figure should be recalculated again and not just aggregated, so I should get 42 instead of 47.

To do a such logic, I need to know which dimension is displayed by the user in the report at every step navigation.

Could someone please tell how to catch the displayed dimension in the BAdI RSROA_OLAP_BADI ?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers