BW Analysis authorization issue... need help urgently....

[Former Member]

We have one BW query which is pulling data from Contract Division info-object. Now this report does not variable selection object so it is pulling data from all values of Contract Division. Values of Contract Division are CNC, CNS, CNE and CNL.

Now we have created an analysis auth. object called z_es_3 and added Contract division info-object. Now we have added that z_es_3 into role and given value to CNS. now when we are running report, we are getting No Authorization error. When we are giving * value in z_es_3, it is running fine.

Now we have to restrict report to contract division. please help.

Thanks in advance

[Former Member]

please run the auth trace (ST01 )

[Former Member]

Are you running unrestricted search on Contract division in your queries? You should restrict it to value which is maintained in the authorization for the InfoObject.

Also please run the analysis authorization trace from RSECADMIN. That will give you a clearer picture of what is wrong.

[Former Member]

Authorisations in BW behave in another way as in R/3. When you allow a user to see value CNC and in your query you don't have a selection screen or filter restricting the selection, a user will get the message 'no authorisation'. To have authorisation a user needs authorisation for the whole selection.

[Former Member]

Solution is to create an authorisation variable for ths field in the query, users will automatically be resticted to the vaules given in the roles.

Also when you get a message like no authorisation for..... double click on it an the next pop-up will show you the technical error