on 09-02-2010 8:28 PM
Our query developers use 3.x bw browser to organize their endusers queries within the various roles. Recently for one particular sales role, somebody has rearranged the reports in a different order. I'm trying to determine if there is a profile or role that is allowing some users to make changes to the layout within bw browser? It seems some people are able to manipulate this and others can not but I'm having trouble determining what role or profile is responsible.
Thank you in advance for any insight you may have.
you can try looking at the back end tables that store the information about the workbook. the link is below.
http://wiki.sdn.sap.com/wiki/display/BI/TablesinSAPBWwhichgiveinformationrelatedtoQueries,WorkBooksandWebTemplates
hope this helps.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
in this case, i would suggest to take a preventive measure for the things not to happen again and assign proper role to the appropriate people. Please ask your basis team to assign only the roles to the required no of people and not to all and divide your reports accordingly into roles.
hope this would help your not to happen the things again.
My problem is not with understanding which users are allowed to have access. My problem is understanding which authorization object is responsible for allowing the user to move workbooks from left to right, up and down etc within browser. If I have a user named John Doe I need to know which authorization object is allowing him to move a workbook around within the BW browser layout.
while finding and opening the work book in the analyzer, on the top you can find the property of the WB and from there you can find the Last changed by or LAST modified by USER. i think you can find the culprit from there.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you for your response. I experimented with your suggestion in mind and unfortunately I found that moving the workbook around in the browser, even moving it to an entirely different role had no affect on the LastChanged date or person responsible. It's almost as though the locations of these workbooks within BW browser are stored external from the actual workbook: ie: much like a LINKED reference to a file.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.