Skip to Content

Allow XS Classic Calculation Views to Consume HDI Container Tables

I have a scenario where calculation views built in XS classic need to source data from tables in an HDI container.

In order to do this, _SYS_REPO must have SELECT privileges on the objects WITH GRANT OPTION.

The issue I am encountering is:

  • Roles created in the HDI container WITHOUT grant option can be granted to _SYS_REPO.
  • Roles created in the HDI container WITH GRANT OPTION cannot be granted to _SYS_REPO. Roles with grant option must be '#' roles, which can only be granted to HDI container object owners.

What is the proper mechanism to grant _SYS_REPO privileges on objects in an HDI container with grant option, so that these object can be used in XS classic calculation views?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on 2 days ago

    The check that '#' roles can only be assigned to #OO is done in the HDI API GRANT_CONTAINER_SCHEMA_ROLES.
    Instead, use a classical GRANT statement with a user having ROLE ADMIN privilege. This way, you will be able to assign '#' roles to any user like _SYS_REPO.
    In addition, if your classical calculation view is a graphical one, you will have to create a synonym on top of your hdi calculation view in _SYS_BIC schema. This is required by the calculation graphical editor in HANA Studio. For this, use an .hdbsysbicsynonym artifact (see https://help.sap.com/viewer/3823b0f33420468ba5f1cf7f59bd6bd9/2.0.04/en-US/0bf88516d12b40ee9605b9f75fae568e.html )

    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.