This is the most common issue which we come across for WBP system. Below are some of the steps which should be followed to Debug BW authorization issues.
If you see the below error saying “User does not have authorization for query BW_QRY_MVCOPA01_0001
Login to WBP system and execute transaction RSECADMIN. Select Analysis Tab as shown below.
Give the user name and make sure to select check box “with log” and shown below and now click on Start transaction.
Now copy paste the Query in query field and select HTMLin Query display. Now click enter.
Once you click on Enter we can see the Info Provide name will added before to Query name by differentiating with Symbol “/”.
Now, take the info provider name and go to transaction SE16 and open table RSECVAL.
Select 0TCAIPROV again Info object field and give Info provider name in place of Internal Char.Value.
Now excute.
You can see the records to which you Analysis authorization to which this query belongs to.
Here we can see this query belongs to PP (Production Planning) application
Now please check the standard document “BW Catalog for roles” and make sure whether user has all the required roles related to PP application if not please follow the approval process to assign.
Sometimes you may not see any entries in table RSECVAL when you give Info provider as shown below.
It’s because in analysis authorization Hierarchy authorizations are maintained in place of Value authorizations.
In such cases take the Info provider and go to transaction RSA1.
Click on search as shown below.
Give the info provider name and click on search.
Now we can see that this query belongs to Controlling (CO) application. So please check the document BW catalog for roles and make sure user has all the related CO application roles.
