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:
- Run T-code PFCG (Role Maintenance)
- Provide Role name (Folder name), Description (Optional) and create as Single Role
Ex: Z_TEST_WB_FOLDER
Role folder to save Workbooks
- 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:
- Run T-code PFCG (Role Maintenance)
- 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
- In Authorization tab, add the below Authorization Objects and Values Manually
- 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:
- Run T-code PFCG (Role Maintenance)
- 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
- In Authorizations tab, add the below Authorization Objects and Values Manually
- 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