Dear Gurus,
Need your help with Calculation view authorization issue in SAP Hana
I have created simple calculation view with joining 2 schema tables and it activated successfully and i have created analytical privilege for the same and it also activated successfully.
I made sure _SYS_REPO is given with required access for these 2 schema tables.
I have created a role with the analytical privilege and assigned to the testuser USERX but when the user executed the calculation view, below authorization issue is prompted.calculaton-view-join.jpgcalculaton-view.png
User USERX is missing valid privilege SELECT for VIEW _SYS_BI.BIMC_ALL_AUTHORIZED_CUBES
User USERX tried to execute 'SELECT * FROM _SYS_BI.BIMC_ALL_AUTHORIZED_CUBES WHERE CUBE_NAME = 'NEWCV' AND CATALOG_NAME = 'pack_CV''
I am really clueless abut this BIMC view, please help, i am really struck at last step to test this.
User trying to test the vew with in Hana studio itself, i made sure required authorizations are given. Please advise if i need to give any access for these schema tables to any standard user id's
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.