Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Showing results for 
Search instead for 
Did you mean: 
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
9 Comments
Labels in this area