Hello Experts,
in my BEx Query I have 10 restricted key figures base on amount (actuals curr. year, actuals prev. year, budget, plan, commitments...) and 5 calculated key figures - differences (actual - budget, acual cur. year - actual prev. year, ...). In my WAD report I always want to see all the restricted values + one calculated key figure (difference) selectable by a dropdown item.
I have come to following solution:
a) create five query views with one difference calculated key figure each - the dropdown selects appropriate query view. The drawback is that I want to use another drop down to select different characteristics in rows (5 in total)- this way I end up in defining 25 views to maintain.
b) by SET_SELECTION_STATE command set the filter for each possible difference that would show the 10 restricted columns + 1 calculated.
The drawback is that this means selecting 5x11 = 55 values for the filters. Furthermore the technical keys for the key figures are artificial codes like 4NWX09JWNJG6UC1STWFQ64ZJG that are hard to maintain.
Is there a more elegant way to solve this?
Regards
Jiri