Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

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

Former Member

‎2008 May 27 3:52 PM

0 Likes
649

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

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

Reply
4 REPLIES 4
Read only

Former Member

‎2008 May 28 4:18 PM

0 Likes
620

please run the auth trace (ST01 )

Read only

Former Member

‎2008 May 28 4:54 PM

0 Likes
620

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.

Read only

Former Member

‎2008 May 29 7:50 AM

0 Likes
620

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.

Read only

Former Member
In response to Former Member

‎2008 May 29 8:55 AM

0 Likes
620

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