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?

[former_member203890 · Accepted solution]

Try using,

string sql = "SELECT * FROM \"_SYS_BIC\".\"Inquire.Sales/TESTTABLE\" ";

[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

[ashok_oleti]

Also check if the executing user has analytic privilege "_SYS_BI_CP_ALL" assigned?

Cheers,

Ashok O.

[Former Member]

Hi,

First please check whether the calculation view is activated successfully and it is available in _SYS_BIC schema as column view.

Second please share the screenshot of the error message which you are receiving after running the above query.

Thanks

Bishant

[jitendra_kumar01]

please share the screenshot. It would be easy to detect the issue.

Thanks

Jitendra

[former_member292670]

Yes, calculation view is available in _SYS_BIC schema as column view. It is activated and I could query by sql within hana studio.

Attached in the screen print from visual studio 2015 where I am able to fetch data from table but not a calculation view.

[anindya_bose]

Can you check if the user id you are using to connect has "SELECT" and "EXECUTE" access to "_SYS_BIC" ?

Regards

ANindya

[former_member208449]

Hello Ram

Also please check if you are able to do the data preview in SAP HANA Studio itself.