How to pass input parameter from Graphical calculation view to Script based CV

[Former Member]

Hi Team,

I have a calculation view which joins data from another two calculation view.

Please see the image below.

Highlighted SQL Script based CV needs a input parameter "DATE" in order to give the correct output.

How do I pass parameter to the underlying CV?

I have already tried manage mapping option but it does not work.

FYI, below is the screen shot of the code where I am using the input parameter.

Thanks & Regards,

Anup

[former_member182114 · Accepted solution]

Hi Anup,

Take a look on these two old posts:

Passing parameters from graphical Calculation v... | SCN

Best regards, Fernando Da Rós

[Former Member · Accepted solution]

Hi Fernando,

Thanks for sharing the links.

It works now I just had to change the "Parameter Case Sensitive"  to True.

Thanks & Regards,

Anup

[former_member182337]

Create input parameter and manage it with place holder.

[Former Member]

Hi Prem,

Could you please elaborate a little more on it?

Should I create input parameter in both calculation view or only in the main CV?

Also, can you help with the placeholder syntax??

Appreciate your help here.

Thanks & Regards,

Anup

[former_member182337]

Create an input parameter in the main CV and pass the same to this as well.

The placeholder query is :

select field1,field2 from "your view name"(PLACEHOLDER."$$Input parameter$$ =>:Run time parameter );