Skip to Content
0

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

Apr 12, 2017 at 02:17 PM

52

avatar image

Hello,

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 ?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers