​SAP HANA change/assign value of/to input parameter within graphical calculation view (CV)

[dineshmahadev]

SAP HANA change/assign value of/to input parameter within graphical calculation view:

I have calculation view CV_A that calls calculation view CV_B. CV_A has two input parameters, IP1 and IP2. IP1 is passed by caller but IP2 needs to be calculated based on IP1 within CV_A before calling CV_B. That is, IP2 should be mapped to IP of CV_B, whose value needs to be passed from CV_A. For Input Parameter, there is option to use scalar function/stored procedure, but the limitation is to pass on constant value, cannot pass on Calculated value. How is this possible when CV_A is graphical CV (very easy to implement in case of script based calculation view). Note: CV is calculation view and IP is input parameter.

[Abhishek_Hazra]

Hi Dinesh,

I did not understand the problem with using Proceure/Scalar function? Why do you say it's not possible to use?

Abhi

[dineshmahadev]

Abhishek, Added screenshot for more clarity. My requirement is pass IP1 to scalar function/stored procedure while assigning value to IP2. Only constants can be assigned, not other IP or Calculated value.

[Abhishek_Hazra · Accepted solution]

Hello again Dinesh,

if you are planning to derive the IP2 using IP1's value using procedure/scalar function, why do you need to click the input enabled option for IP2? I have explained a similar scenario in my article, pleaes check the Approach#2 in mentioned article, it is possible to have :
1. IP1 as input enabled.

2. Derive IP2 using a procedure/scalar function based on input value of IP1.

3. Pass both IP1 & IP2 into input parameters with similar attributes of another calculation view consumed within the caller calculation view using datasource assignment of input parameters.

Best Regards,
Abhi

[dineshmahadev · Accepted solution]

Thank you. Your inputs and article has helped. Not checking "Input Enabled" has helped (Manage Mapping within Input Mapping screen can be used). The solution is perfect, technically working.

Regards,
Dinesh