Skip to Content
avatar image
Former Member

Deriving Input Parameter value from Another Input Parameter in a calculation View


User will get a Prompt to input Planning Account that he want to Run the Report.

Planning account is basically a Navigational attribute of CUST_SALES ,so one planning account consist multiple Cust_Sales.

We have a Projection on planning DSO where we only have the CUST_SALES not Planning account.

So i want to restrict the result sent at Projection level by passing filter for all the cust_sales belongs to the planning account which user has inputted.

I can join CUST_SALES and Planning DSO and then i can apply the filter at Planning account but i dont want to do that because we have to apply the join which is costly w.r.t run time.

Is it Possible we can derive all Cust_Sales for the specific planning account in another Input parameter and then we restrict with that IP.

I am looking forward for your valuable Inputs

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Dec 13, 2017 at 06:33 PM


    A variable (in HANA calculation view) applied directly on planning account should filter at the base table directly (as long as it is coming straight from base table i.e, it's not a calculated column). You don't need to worry about planning DSO.

    Please try this out and let me know if this doesn't work.


    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      If you want to pass input parameter from one calc view to another, yes that is possible. There is otion called input parameter mapping.

      It should filter in lower level calc view.