Calculation View not accessible

[former_member292670]

Experts,

we are using hana drivers and successfully connecting to Hana database and able to fetch data from HANA Table using sql from an external application. But we are not able to do the same thing on a calculation view.

Query on Table works.

select * from "SAPDAT"."LOCATION"

Query of calculation view does not work.

select * from "_SYS_BIC"."Inquire.Sales/TESTTABLE"

Any thoughts?

[kr_pavankumar]

Hi Ram,

Can you able to execute the below query in SQL console

Query of calculation view does not work.
select * from "_SYS_BIC"."Inquire.Sales/TESTTABLE"

In the above 'String sql': 'Underscore' is missing before SYS_BIC and this statement has to follow the syntax as mentioned in the first query ie., schema & view name should be enclosed with double quotes. Please try this and let us know.

--

KRPK