cancel
Showing results for 
Search instead for 
Did you mean: 

Calculation View Passing Value from one input parameter to Another input parameter

former_member290321
Participant
0 Kudos

I have a CalculationViewB where i have to filter a Company ID field on basis of CalculationViewA Company ID field but the client wants a descriptive field (Company Name) in drop down at the time of execution as input parameter.

CalculationViewA has two field Company ID and Company Name i.e 3048 ABB

So at the time of execution Client will get a drop down on basis of INPUT PARAMETER 1 that is CompName and at the view level it will filter on basis of INPUT PARAMETER 2 that is CompID.

i.e Client will select Input Parameter CompName: ACC and internally CalculationViewB will get filter on basis of Input Parameter 2 CompID: 1225

Filter: CompanyID =$$CompID$$


Will parameter mapping work in aforesaid scenario ?? Or

Do i have to use scripted calculation view? Or

Is there any other way ??

Accepted Solutions (0)

Answers (1)

Answers (1)

BenedictV
Active Contributor
0 Kudos

I see the CalcviewB has both company code and company name, so what is the issue in filtering company name directly based on user input? CompName = $$IP_CompName$$

OR

Include ClacviewA as a node in CalcviewB. Filter NodeA as CompName = $$IP_CompName$$. Inner join tjhis with projection in CalcviewB on CompanyCodeB = CompanyCodeA


former_member290321
Participant
0 Kudos

With above scenario you are right but if there is no country name in CalculationViewB, and view has to filter on CompID in that scenario... how can that be achived

BenedictV
Active Contributor

Did you try the second option I suggested? What was the result? I would encourage you to try out a few methods and come back to the community with what you tried and how it fails.