topic Re: BI Authorization problem in Application Development and Automation Discussions

BI Authorization problem

Former Member — Fri, 20 Aug 2010 03:38:29 GMT

Dear Gurus,

Please help me.

I am getting below error:

Subselection (Technical SUBNR) 1

Supplementation of Selection for Aggregated Characteristics

Check Added for Aggregation Authorization: PRIMAP02__PRITEM

Authorizations missing for aggregation (":")

Char. 1

PRIMAP02__PRITEM Empt

I have given aggregation authorization for the characteristic PRIMAP02__PRITEM in one of the analysis auth obj. and when I run I still get the same error. Could you please help me in resolving this.

I appreciate it.

Thanks,

Raj

Re: BI Authorization problem

Former Member — Fri, 20 Aug 2010 04:54:40 GMT

HI,

Have you given the authorization for the required aggregation in RSECADMIN analysis authorizations???

If the issue is not resolved try to find out what is missing by performing analysis using RSECADMIN and Execute as the user xxxxxx with log and Start the transaction. If you see the log you will get some clue.

Regards,

Rama

Re: BI Authorization problem

Former Member — Fri, 20 Aug 2010 11:09:31 GMT

Hi Raj

If any auth relevant characterisitc such as "PRIMAP02__PRITEM " is present in the cube .Even though it is not part of the query

for which you are facing the "No authorization Error".Program checks for the aggregation access so inorder to provide access you need to have anlysis authorization in place which provied access to your characterstic PRIMAP02__PRITEM with aggregation authorization and add it in th user's role.That should solve the problem

Please get back for further help

Regards

Santosh Varada

Re: BI Authorization problem

Former Member — Fri, 20 Aug 2010 12:52:11 GMT

Please trace it

Re: BI Authorization problem

Former Member — Fri, 20 Aug 2010 18:00:25 GMT

Trace will not work for BI anaylusis authorization results .

we will have to go through transaction RSECADMIN.

Re: BI Authorization problem

Former Member — Mon, 23 Aug 2010 10:05:21 GMT

Hi,

When I have an authorization problem I try if 0BI_ALL works. If it does I take the analyses object and give it a * , then you are sure it is an authorization problem if those things work. Working with BI 7.0 and higher go to the error log in rsecadmin it gives a yellow line if it is realy an authorization error, look in the details of the selections on the log, there should be your answer.

have fun

Bye

Jan van Roest

Re: BI Authorization problem

Former Member — Mon, 23 Aug 2010 11:32:06 GMT

Thank you guys, for your replies.

The issue has been resolved. Actually the log says : is missing. After some digging into the issue found that wrong infoprovider has been given in an analysis auth obj.

Thanks for your support. I appreciate it.

Raj

Re: BI Authorization problem

Former Member — Mon, 23 Aug 2010 11:32:11 GMT

Thank you guys, for your replies.

The issue has been resolved. Actually the log says : is missing. After some digging into the issue found that wrong infoprovider has been given in an analysis auth obj.

Thanks for your support. I appreciate it.

Raj