Analysis Office Role Folder in SAP NetWeaver platform

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

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

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

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

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

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