topic Re: Aggregation authorization within analysis authorizations in Application Development and Automation Discussions

Aggregation authorization within analysis authorizations

Former Member — Wed, 04 Oct 2006 21:08:32 GMT

Hello,

The BW developers have created several queries that use aggregated data. When testing the queries with the end user ID (assigned to an end user role and analysis authorization), it is failing due to missing authorizations, particularly b/c of the following:

Supplementation of Selection for Aggregated

Characteristics

Check Added for Aggregation Authorization: 0COMP_CODE

Check Added for Aggregation Authorization: 0PLANT

All Authorizations Tested

Message EYE007: You Do Not Have Sufficient Authorization

No Sufficient Authorization for This Subselection (SUBNR)

Following CHANMIDs Are Affected:

142 ( 0COMP_CODE )

189 ( 0PLANT )

192 ( 0SALESORG )

In the BI documentation, it specifies that : (colon): allows only aggregated access to data (e.g. allows information on all sales areas only on aggregated level –not on particular countries). Is this ( specified as a value within the particular characteristics? I also tried to select the "aggregation authorization" icon within txn code RSECADMIN and this did not help.

Any help would be GREATLY appreciated.

Re: Aggregation authorization within analysis authorizations

Former Member — Thu, 05 Oct 2006 16:08:41 GMT

Updated: For the analysis authorization, for these characteristics, in addition to the specific values, there is an entry for ":" and this did not resolve the issue.

Authorization Check

Detail Check for InfoProvider ZBL_13IT

Preprocessing:

Selection Checked for Consistency, Preprocessed and Supplemented As Needed

Subselection (Technical SUBNR) 1

Check Node Definitions and Value Authorizations...

Node- and Value Authorizations Are OK

End of Preprocessing

Main Check:

Subselection (Technical SUBNR) 1

Supplementation of Selection for Aggregated Characteristics

Check Added for Aggregation Authorization: 0COMP_CODE

Check Added for Aggregation Authorization: 0PLANT

Following Set Is Checked Comparison with Following Authorized Set Result Restmenge

Characteristic Contents

0PLANT

0SALESORG

0TCAACTVT

0COMP_CODE

SQL Format:

COMP_CODE = ':'

AND PLANT = ':'

AND SALES

ORG = '0403'

AND TCAACTVT = '03'

Characteristic Contents

0PLANT I EQ IC01

I EQ IC02

I EQ IC03

I EQ IE02

I EQ IE04

I EQ IZ01

I EQ MC01

I EQ ME01

I EQ :

0SALESORG I EQ 0301

I EQ 0341

I EQ :

0TCAACTVT I EQ 03

I EQ :

0COMP_CODE I EQ 0327

I EQ 0341

I EQ :

Not Authorized

All Authorizations Tested

Message EYE007: You Do Not Have Sufficient Authorization

No Sufficient Authorization for This Subselection (SUBNR)

Following CHANMIDs Are Affected:

142 ( 0COMP_CODE )

189 ( 0PLANT )

192 ( 0SALESORG )

Authorization Check Complete

Re: Aggregation authorization within analysis authorizations

Former Member — Thu, 15 Feb 2007 20:50:38 GMT

Hi Julie,

Not sure if you're still interested, but I think your check is having a problem on Sales Org.

In the query statement, it reads:

SALES

ORG = '0403'

In the auth check, it reads:

0SALESORG I EQ 0301

I EQ 0341

I EQ :

That might have been a type-O on your part, but if not, that's the answer.

Cheers,

rob