Skip to Content
0

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

Dec 11, 2017 at 02:14 PM

44

avatar image
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

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

1 Answer

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

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

Show 2 Share
10 |10000 characters needed characters left characters exceeded
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?

0
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

0