HANA Data Modeling, HANA Studio.Can any one tell me the solution to this error?

[Former Member]

some one could tell me whats the issue behind this error and kindly resolve this.
Thanks in Advance.

[former_member437692 · Accepted solution]

Hi Sohaib,

Run the following statement on schema from which you are using tables to create calculation view.

GRANT SELECT,EXECUTE ON SCHEMA <schema_name> TO _SYS_REPO WITH GRANT OPTION

Once the above statement is executed successfully try to active your calculation view.

Regards,

Venkat

[Former Member]

Hi Sohaib,

In the System View, go to Users under SecurityFolder. Then select _SYS_REPO user and grant SELECT privilege on the schema you are using to select the data from the tables. Hopefully, that will help and resolve the issue.

Thanks

Deepank Aggarwal

[former_member182302]

Either the user is not authorized to use the tables in the calculation view or the user is not authorized to activate the view.
Click on the error message and it would show some more details.

Regards,
Krishna Tangudu

[Sharadha1]

Hi,

The user is not authorised to access the catalog tables used by the calc view.

[Former Member]

But i am the owner of the system , and using the systemDB . Could you tell me what should i do to resolve this problem.