Symptom
You would like to set up authorization to allow user to execute query view but restrict user not to delete and overwrite the existing query views in Anaysis Office.
Environment
SAP Analysis for Microsoft Office
Reproducing the Issue
Save query view to Netweaver platform
Resolution
- Assign authorization object S_RS_COMP or S_RS_COMP1 with activity '03 Display' and '16 Execute' to user.
-
Implement the SAP note below in transaction SNOTE in the backend system if applicable:
2570538 - BI Analysis Office: incorrect authorization check during first save of a query view -
Refer to SAP note below and use ABAP report SAP_RSADMIN_MAINTAIN to create a new parameter 'OSD_CHECK_VIEW_AUTHORIZATION' and set the value to 'X'.
1727956 - Authorization for query views is not checked
See Also
Keywords
query view, query views, overwrite, delete , KBA , BI-RA-AO-XLA , Excel Addin , BW-BEX-ET-AUT , Authorizations , Problem