cancel
Showing results for 
Search instead for 
Did you mean: 

Not able to access data without _SYS_BI_CP_ALL Analytical privilage

Former Member
0 Kudos

Hello,

I am creating a analytic privilege for new user. The analytic privilege is on a calculation view restricting region specific data.

I have provided below authorizations:

Role: Public

SQL privileges: _SYS_BI(Execute,Select), _SYS_BIC(Execute,Select), Repository_Rest(Sys) (Execute), CVG/CV_COPA(_SYS_BIC) (Select on calculation view)

Analytic privileges: CVS.CV_COPA

System privileges: CATALOG_READ, DATA_ADMIN

Package privileges: Repo.Read

when user tries to preview data with above privileges, below error is thrown:

Error: SAP DBTech JDBC: [2048]: column store error: search table error:  [2950] user is not authorized.

if Analytic privilege is changed to _SYS_BI_CP_ALL, user is able to preview the data but as expected the entire data set.

Is there something else i should be doing?

Thanks,

Vishal

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Vishal,

The above authorizations are all that are required to perform a data preview on the view.  For the analytic privileges CVS.CV_COPA do you have any attribute or restriction filter defined?  If you do, can you remove them and save/active the AP.  Then test if you can preview data? The _SYS_BI_CP_ALL analytical privilege allows a user to read from modeled views.


Regards,

Vishal