Passing optional multiple input parameters from CV to Table Function

[kgaurav2k14]

Hi Friends,

I want to pass optional multiple input parameters from Calculation view to Table function. I have followed the below link which has described all the steps. However, I am not able to achieve feature if user does not pass any value then 1=1 will bring all the values for that column. Has anyone tried this and able to achieve? For me, It returns zero rows if I put nothing in my selection.

This works fine if the input parameter is set to single seleciton - Optional, but it does not work in Multiple Value - Optional selection,

Passing multi-value input parameter from Calculation View to Table Function in SAP HANA – step by st...

Thanks,

Gaurav

[fedaros]

Hi kgaurav2k14,

I read the blog and your scenario description points to scenario 2, and it's seems "ready to work".

Are your parameter content really equal '' or is zero, null ? Perhaps it is not going to 1=1

In case it still doesn't fix the issue, could you please share some screen shoots of your section of code related to filter decision, apply filter and also the query you are performing?

Regards, Fernando Da Rós