Skip to Content
0
Former Member
Jul 08, 2020 at 04:03 PM

How to Build Query with Analysis Authorizations to Work for Intersection of Members

48 Views

Cost center is an authorization relevant IOBJ in our BW.

We have the following cost centers for travel expenses: 4710, 4711, 4712, 5710, 5711, 5712.

We built a BEx query especially for travel expenses with a global filter on the cost centers 4710, 4711, 4712, 5710, 5711, 5712 .

The users in our system are assigned analysis authorizations (in RSECADMIN) on cost centers like this:

User1: 2710, 3710, 4710, 5710

User2: 2711, 3711, 4711, 5711

User3: 2712, 3712, 4712, 5712

When User1 executes the query he/she is supposed to see the values for 4710 and 5710.

For User2 it is supposed to be 4711 and 5711 etc.

Hence, the expected result is the equivalent of an SQL 'inner join' between the travel expense cost centers and those cost centers which the respective user is authorized.

The problem is that we receive the message 'no authorization'.

Question: is this behaviour to be expected or is it a bug?