SAP Knowledge Base Article - Public

3203326 - How to restrict user not to overwrite existing query views in Analysis Office

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

  1. Assign authorization object S_RS_COMP or S_RS_COMP1 with activity '03 Display' and '16 Execute' to user.
  2. 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

  3. 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

540720 - FAQ: Information on S_RS_COMP and S_RS_COMP1

1727956 - Authorization for query views

Examples for Authorizations for the Query Definition

Keywords

query view, query views, overwrite, delete , KBA , BI-RA-AO-XLA , Excel Addin , BW-BEX-ET-AUT , Authorizations , Problem

Product

SAP Analysis for Microsoft Office all versions