Filtering with Parameter on remote source

[ehud]

Dear experts,

We are on PaPM, on-prem, SP 19.

We are having issues while moving from value-based filtering on remote source tables to parameter-based filtering, especially when trying to extract data from large-size tables.

It seems that when using a parameter in the complex selection box (e.g. VALDITY_MONTH=:I_MONTH), the parameter filter value is not translated to the generated SQL so the whole data is being transferred to HANA instead of being filtered in the source DB.

Are you familiar with this issue and know how it can be resolved?

Thanks,

Udi

[akki0785]

Hi Udi,

We are Using parameter selection in cloud version and it is working as expected.

are you using parameterized view to extract from source.

Regards,

Akshay

[ehud]

Hi Akshay,

We are using a join on top of a model view function.

The condition is in the complex selection box of the input tab.

VALIDITY_MONTH is the field in the source system. I_MONTH is the parameter we use in the environment.

We are trying to run the join for a certain month. When doing so for small-size tables, it works.

For large-size tables, it doesn't work as it seems that the value of the parameter is not part of the generated SQL.

Thanks,

Udi