topic Re: SQL from ABAP & Calculation View retrieve different results. in Application Development and Automation Discussions

SQL from ABAP & Calculation View retrieve different results.

Former Member — Mon, 23 Apr 2018 14:57:15 GMT

Hi,

I have made a query using CL_SQL_CONNECTION class which fetches data from a Calculation View from the HANA DB. The number of results returned are less than the data preview of same calculation view.

I tried to configure the authorization trace according to note 1809199, but no luck. Nothing is captured in the trace file as well. I am not sure what privileges are missing.

Could any one please guide me on how should I proceed further to check what authorization/privilege is missing from the user?

Regards,

Gaurav

Re: SQL from ABAP & Calculation View retrieve different results.

roberto_forti — Tue, 24 Apr 2018 21:03:39 GMT

Hi Gaurav,

Has SAP HANA performed Union node?

In this case, going to the Properties of the corresponding data source and in the Mapping tab you can see "Empty Union Behavior" field value which was configured.

Regards,

Re: SQL from ABAP & Calculation View retrieve different results.

Former Member — Wed, 02 May 2018 03:32:57 GMT

Hi Roberto,

No there is no union performed. Calculation View is simple SQL Calc view fetching data from just 1 table.

Regards.