cancel
Showing results for 
Search instead for 
Did you mean: 

How to lock BW 3.x Browser layout

Former Member
0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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.

Former Member
0 Kudos

I reviewed each of those tables and I could not find any information to help me, unfortunately.

Former Member
0 Kudos

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.

Former Member
0 Kudos

Ahh but this is the crux of the problem my friend. We are a small shop (just two of us BW people) and I handle development and the security and I can't figure out what role or profile needs to be tweaked in order to lock this.

Former Member
0 Kudos

you can check the WB and the roles in PFCG and your basis team and the business can help you out on the same in taging the right people into the right role. you need not have to do the same.

Former Member
0 Kudos

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.

brian_keenan
Contributor
0 Kudos

Run an atuthorization trace in ST01 to see what objects are being called.

Answers (1)

Answers (1)

Former Member
0 Kudos

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.

Former Member
0 Kudos

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.