on 07-16-2013 11:17 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.