06-04-2010 6:27 PM
Hello Experts,
We are facing an issue in BW 3.1 system. There is a query is to retrive data for the profit centers. The query is common for all the divisions. The users should give their respective division in the selection screen. The users are given authorizations for their respective divisions and object were maintained with appropriate profit center values. But when they execute the query, the data is being retrieved for all profit centers. In the transaction RSSMQ, we executed the query on behalf of the user and found that profit centers being selected is showing as star (*). The users were able to execute the query till last month. The query has not been changed at all and no roles have been modified.
I would like to know what could be the reason behind the problem as the issue is coming eventhough no changes were made.
If updating any OSS notes or patches will create this problem? Also, how to find whether any recent change made to the system? Kindly help me in resolving this issue.
Thanks in advance,
Ram Prasad.
06-04-2010 6:58 PM
Hi Ram,
Kindly check the authorization variable put up in the query for divisions . I think if the authorizations in the roles have not been changed, then it has to do with the authorization restrictions in query.
Regards,
Manisha
Edited by: Manisha Nadir on Jun 5, 2010 12:07 AM
06-04-2010 6:58 PM
Hi Ram,
Kindly check the authorization variable put up in the query for divisions . I think if the authorizations in the roles have not been changed, then it has to do with the authorization restrictions in query.
Regards,
Manisha
Edited by: Manisha Nadir on Jun 5, 2010 12:07 AM
06-08-2010 6:04 AM
Hi ram,
While restricting on profit centre what values did u maintained? If profit centre has * then obvoously u will get full data.
Thanks,
Sri
06-08-2010 11:39 AM
Hi Sri,
Thanks for your response.
Here in our case, we have global and local profit center concept. The global is formed from the first 4 characters of the profit center and local is nothing but individual profit centers. In the role, we are restricting on global profit centers like P11* and P12* and for local we have given full authorization. But the RSSMQ report if we check, it is failing for local profit center object even though it is given full authorization. We are not able to figure out whether it is Authorization problem or query problem.
Regards,
Ram Prasad.