Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    May 28, 2008 at 03:18 PM

    please run the auth trace (ST01 )

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 28, 2008 at 03:54 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 29, 2008 at 06:50 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • 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