Skip to Content

WAD: Select restricted/calculated key figure by dropdown

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Dec 09, 2011 at 02:37 PM
    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.