How to pass the dynamic filter value in Derived from Table in Input Parameter?.

[Former Member]

Experts,

            Created a mapping table with rolling 12 months fiscal period end dates for every Fiscal Year/Period for certain no of years. Would like to use the derived from table Input parameter type to fetch the rolling 12 months fiscal period end dates based on the user input time filter. The user input is captured as Input parameter in the calc view.

              Other 12 input parameters($$IP_MONTH_END_DATE_P01$$) were created to used in filter expression for 12 months.

            The document is attached. The values are not getting returned, when passing the Input parameter $$IP_FY_FP$$ in the filter condition, whereas for any hard coded value, this is working.

            So my question is, can we pass input parameter as filter condition in another input parameter definition?.. or how to get the dates for rolling 12 months for the dynamic user input?.

Appreciate your response,

Thanks in Advance,

Suresh

[Former Member]

Hi Suresh,

It is not possible to apply filter dynamically through derived from table option in input parameter,

But we have an alternate approach that is build an attribute view based on your  data base table  and filter on the required column with filter condition  value $$IP_PARAMETER$$. This attribute view is used as a value help view while creating input parameter.

NOTE: Input parameter name and filter condition value in attribute view should be same.

Thanks

[pfefferf]

That is not possible with a "Derived from Table" input parameter. But you can reach your goal using an input parameter of type "Derived from Procedure/Scalar Function" (available since SPS10) (Create Input Parameters - SAP HANA Modeling Guide - SAP Library). The procedure or scalar function can have an input parameter to which another input parameter can be mapped in the view mapping section. Within the procedure or function you can then determine the relevant value out of your table depending on the other input parameter value.

Regards,

Florian