topic Re: Authorizations missing for aggregation in SAP BI Security in Application Development and Automation Discussions

Authorizations missing for aggregation in SAP BI Security

surya_appala — Wed, 07 Mar 2018 13:23:34 GMT

Hello Everyone,

I see a user getting an error saying "Authorizations missing for aggregation (:)"

User has below AA

AA - ABC123

Characteristic - C123 with value 0001

AA - XYZ123

Characteristic - C123 with values 0001, : and #

Both the AA has the same set of Info objects/Characteristics. This means Authorizations will gets union and combined into 1 at runtime check.

Trace file is highlighting AA ABC123 with Characteristic C123 in RED.

From my understanding user has access. Could someone please suggest what might be missing. Thank you.

Re: Authorizations missing for aggregation in SAP BI Security

Colleen — Mon, 26 Mar 2018 07:45:15 GMT

do both AAs have the same restricted characteristics that the multiprovider contains?

Have you run the trace via RSECVAL to see how the AAs are being evaluated for the report?

Re: Authorizations missing for aggregation in SAP BI Security

surya_appala — Thu, 19 Apr 2018 00:58:15 GMT

Hello Colleen,

Sorry for the late reply.

Both the AA are having same set of Characteristics restricted. But Info Provider is different. I think this is the issue. In order to make union of Analysis Authorizations, both should have same Infoprovider and same set of characteristics. Thank you.

Regards,

Surya

Re: Authorizations missing for aggregation in SAP BI Security

surya_appala — Thu, 19 Apr 2018 01:12:31 GMT

From my understanding RSECVAL is a table. I do not see any option to trace from it. May be I am missing something. Please guide if there is any option to trace from RSECVAL. Thank you.

Re: Authorizations missing for aggregation in SAP BI Security

Colleen — Thu, 19 Apr 2018 09:37:39 GMT

you are right and the fault is with me and a failure to multitask. I meant RSECADMIN and switch on a trace from there to evaluate the Analysis Authorisations. You can also check STAUTHTRACE for your S_RS_COMP authorisations

Re: Authorizations missing for aggregation in SAP BI Security

surya_appala — Thu, 19 Apr 2018 11:34:00 GMT

Okay Thank you Colleen. Issue is with AA and not from general authorizations. 🙂