Skip to Content

can we access classical HANA calculation views in XSA Web IDE

Hi Everyone,

We have come across a scenario where we need to access classical HANA calculation views into XSA Web IDE.

Is it possible to access calc. views into Web IDE by creating synonyms or any other way? or is it must to migrate the calc. views to XSA environment.

NOTE: We are successful in accessing tables from classical schema like user schema or BW schema by creating synonyms and hdbgrants files.

Issue: Facing "Insufficient Privilege" issue while accessing _SYS_BIC schema, where calculation views are present, through synonyms. But, we have maintained SELECT for application_user and SELECT WITH GRANT OPTION for object_owner on _SYS_BIC schema in .hdbgrants file.

Please suggest me on possibilities of achieving the same.

Your help is immensely appreciated!

Regards,

Chandra

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Jun 18, 2019 at 07:31 AM

    Hi Chandra

    That should ideally work. We may have to look at indexserver trace to get more details.

    Would it be possible for you to create a new Calculation view in Hana Studio without any privilege and try accessing the same through synonym in XSA

    Regards

    Ragahvendra

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.