Model View HANA Table : Unable to filter in SAP PaPM

[former_member831270]

I am using a Model View HANA table to get the data from S/4 HANA to PaPM Cloud. The data displays fine on doing a 'Show' in the environment. But upon applying a filter (from the filter section to the right) on one of the fields (which has the same value for all the records), it gives the following error : Unexpected error. internal error: Error opening the cursor for the remote database Failed to execute query.

Upon giving the same connection to Model Table HANA function type, the filter works fine. Could you please let us know as to why there is this behavior for Model View HANA table.

Thank you,

Soundarya C Adiga

[mandy3]

I'm facing an issue from PaPM end as I have created variable's in HANA View and used same view in the PaPM environment. But data is not filtering in the PaPM environment even though data is filtering in HANA View. Could you please suggest on the issue.

Thanks & Regards

Mandy

[muralikrishna22]

Hi Soundarya,

Model View Function will help to filter data based on Input Parameters created in PaPM and linked to Input Parameters of HANA Calculation Views mostly. Hence, Model View Function with HANA table is not recommended when we have capability of consuming HANA Table inside Model Table Function.

We won't be able to apply filters directly in Model View / Model Table Functions and see the output using Analyze option with filtered data as we won't have option to run and see the output.

It is always recommended to use View / Join Function on top of Model Table Function (after consuming HANA table inside Model Table Function) to filter the data based on hard-coded filter selection value by running the View / Join Function with / without package selection.

It is always recommended to use View / Join Function on top of Model View Function (after consuming HANA Calculation View inside Model View Function with Input Parameters) to filter the data based on package parameters by running the View / Join Function with / without package parameters and package selections.

Regards,

Muralikrishna Puvvala