Skip to Content

If we need to save an analysis workbook to the BW backend, we need to create a Role folder. The saved workbooks can be opened using the T-code RAAOE.

All the available versions of SAP Analysis office and BW NetWeaver supports for it.

Prerequisites

  • The BW systems have to be defined in the saplogon.ini file in the Windows directory on your local machine.
  • The User should have access to the System with at least basic authorizations.
  • The Analysis office should be installed on your local machine and the Plug-in should be enabled in Microsoft Excel.

 

Step-by-Step procedure

Step 1: Create a Folder Role, which is used to store the Workbooks

Procedure:

  1. Run T-code PFCG (Role Maintenance)
  2. Provide Role name (Folder name), Description (Optional) and create as Single Role

Ex:    Z_TEST_WB_FOLDER

Role folder to save Workbooks

 

 

  1. In User tab, add the users who needs access to this folder.

 

 

Note: No authorizations required in Authorizations tab.

 

 

Step 2: Create Authorization Role for accessing (complete access) the created Role folder in previous step

 

Procedure:

  1. Run T-code PFCG (Role Maintenance)
  2. Provide Role name, Description(Optional) and create as Single Role

Ex:    Z_TEST_WB_FOLDER_FULL

Authorization Role to access(complete)

the Folder Role Z_TEST_WB_FOLDER

 

  1. In Authorization tab, add the below Authorization Objects and Values Manually

 

Authorization Object

Field Name

Field Value

S_USER_AGR ACTVT *
ACT_GROUP Z_TEST_WB_FOLDER
S_USER_TCD TCD RAAOE
S_RS_AO ACTVT *
RSAO_OBJID *
RSAO_OBJTY *
RSZOWNER *

 

 

 

  1. In User tab, assign the users who needs complete access to the Workbooks

 

 

Step 3: Create Authorization Role for accessing (Display access) the created Role folder in first step

 

Procedure:

  1. Run T-code PFCG (Role Maintenance)
  2. Provide Role name, Description(Optional) and create as Single Role

Ex:    Z_TEST_WB_FOLDER_DISP

Test role to access Z_TEST_WB_FLD  |Display access

 

  1. In Authorizations tab, add the below Authorization Objects and Values Manually

 

Authorization Object Field Name Field Value
S_USER_AGR ACTVT *
ACT_GROUP Z_TEST_WB_FOLDER
S_RS_AO ACTVT 03 (Display)
RSAO_OBJID *
RSAO_OBJTY *
RSZOWNER *

 

 

  1. In User tab, assign the Users who needs display access to the Workbooks

 

 

 

Result

The Users are able to view and access the Workbooks in the folder and perform the actions based on the authorizations.

 

 

 

 

 

Troubleshooting Note:

If any authorization errors, check in SU53 (Missing Authorizations) and assign them to Users.

 

Thanks,
Santhosh Kumar R G

To report this post you need to login first.

3 Comments

You must be Logged on to comment or reply to a post.

Leave a Reply