Protect workbook from authorized user

[Former Member]

I have created a workbook Z_WB_TEST in BEx Analyser. I want to protect my workbook so that authorized user can't do modification in my wookbook. I want othe user can only change variable value and run that workbook and save it. Other than this he should not do any changes like delete, hide row column etc.

I want this type facility because a user will provide me report after executing workbook Z_WB_TEST.

Kindly help me.

regards

nk

[Former Member]

Best Practice is to break them down. End users/Power users get Reporting component roles that have the access to run queries. Workbook roles provide access to developers for publishing their workbook queries/reports and this would make sure that end users would not be able to change and overwrite the existing format.

Third set of roles would be the analysis auth roles which provide the actual access. A 3 way naming convention in BW always helps the security to keep it tight and simple.

~Sri

[Former Member]

The Object S_USER_AGR controls access to the workbooks and folders (roles created as folders). Once you have created your workbook, save it to a role folder (you should have the role folder assigned to your user ID in order to save the workbook to it). you should have access to S_USER_AGR where as the other users whould be assigned the role in which you have saved the workbook, BUT NO ACCESS to object S_USER_AGR.

This way, they can open up the work book change the variables on the selection screen (depending on the analysis authorizations that are assigned to them) and execute the report.

Please note that for the workbook to refresh everytime with current date you need to toggle a setting on Bex Analyzer.

Regards,

Prashant

Edited by: Prashant Pasala on May 12, 2011 9:11 PM