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

[Former Member]

Requirement:

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

[Former Member]

Hi,

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.

Anup

[Former Member]

Thanks Anup for your response,

My intention is to pass the IP at lowest granular level without join.

Is there any way we can pass the values from one IP to another?

[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.

Anup