Input Parameter mapping does not work in Calculation View

[Former Member]

Hi,

We have created SQL script based Calcuelation View CV_SELECT , we have dfined 2 Input Parameters say Z_PRODUCT & Z_COUNTRY.

We have simple sql

select Country, Region, Function, Product from Table_1 where country = :Z_COUNTRY and Product = :Z_PRODUCT;

We have created second calculation view CV_PROJECTION

Its simple projection where we are projecting all the fields from CV_SELECT.

In order to pass values for Product and Country we have defined input parameters in this second view, Z_PRODUCT & Z_COUNTRY (definition is exactly same as for parameters in first CV)

We have mapped these Input Parameters to the source (CV_SELECT.Z_PRODUCT To CV_PROJECTION.Z_PRODUCT  and CV_SELECT.Z_COUNTRY to CV_PROJECTION.Z_COUNTRY.

When we pass parameter values to CV_SELECTION we get few records and output, but when we pass same values as input to CV_PROJECTION is does not output anything.

Am I missing any setting?  How to fix this issue?

Regards

Sagar Shelar

[Former Member]

Hi Sagar,

Could you set filter expression in second calculation view, such as CV_SELECT.Z_PRODUCT =$$CV_PROJECTION.Z_PRODUCT$$ and CV_SELECT.Z_COUNTRY=$$CV_PROJECTION.Z_COUNTRY$$

Hope this can help you.

Regards,

Jerry

[Former Member]

Hi There,

have a similar query. Have a Scripted CV1 with input parameter. I want to use this in a CV2 - however after doing the auto assignment, am getting no result. Please can you suggest how to propoagate and map the input parametes between CV1 and CV2.

Thanks,

Sudarshan