Skip to Content
avatar image
Former Member

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

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

1.png (70.3 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    May 15, 2017 at 04:25 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 16, 2017 at 12:41 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • May 23, 2017 at 06:05 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • May 10, 2017 at 09:30 AM

    Hi,

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

    Add comment
    10|10000 characters needed characters exceeded

    • 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.