Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

SQL from ABAP & Calculation View retrieve different results.

Former Member

‎2018 Apr 23 3:57 PM

742

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

2 REPLIES 2
Read only

roberto_forti
Contributor

‎2018 Apr 24 10:03 PM

0 Likes
617

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,

Read only

Former Member
In response to roberto_forti

‎2018 May 02 4:32 AM

0 Likes
617

Hi Roberto,

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

Regards.