Authorization - Bex Query Analyser Results

[Former Member]

HI,

We have given authorization to a user for a Company and Sold to Party fields. E.g. Company = 1 and Sold to Party = 101. Now Company 1 has got lots of Sold to Parties such 102, 103, 104 to which the given user has no acccess.

In Bex Analyzer in the Input Parameter selection screen the user has being provided a field to enter Company and not Sold to Party. When we execute this query we get the error 'You do not have sufficient authorization' may be because Company 1 has got lots of Sold to Party for which user has no access.

Logically we should be able to get the results for Sold to Party = 1 for this user.

Can you please help in resolving this issue?

Thanks & Regards

Raj

[Former Member]

Hi,

create an authorization variable for Sold to Party.

Additional go through this Notes:

Note [1244127|https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/oss_notes/sdn_oss_bw_bex/~form/handler%7b5f4150503d3030323030363832353030303030303031393732265f4556454e543d444953504c4159265f4e4e554d3d31323434313237%7d] - "No authorization" when a user has several authorizations

Note [1234567|https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/oss_notes/sdn_oss_bw_bex/~form/handler%7b5f4150503d3030323030363832353030303030303031393732265f4556454e543d444953504c4159265f4e4e554d3d31323334353637%7d] - The authorization log RSECADMIN

Note [1000004|https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/oss_notes/sdn_oss_bw_bex/~form/handler%7b5f4150503d3030323030363832353030303030303031393732265f4556454e543d444953504c4159265f4e4e554d3d31303030303034%7d] - Merging and optimizing analysis authorizations

Regards

Andreas

[Former Member]

Hi,

Can you please let us know by applying these notes what are the chances of resolving the issue?

[Former Member]

Hi

Please specify the details of:

1. Authorization Object used for the purpose you mentioned.

2. Roles in which the Authorization Object is used

Let's hope that we need to re-organize these

Yaniv

[Former Member]

Hi,

First of all thanks for your response. I will not be able to answer the queries put forward by you to resolve my problem. I am not a technical person and will get back after speaking to the developers.

Thanks & Regards

Raj