Skip to Content

SAP BusinessObjects Analysis Workbook and SAP BW

Hello Everyone!

In this blog i would demostrate that with SAP BusinessObjects Analysis edition for MS Office release 1.3 is possible, finally, to save workbook on SAP BW.

The previous realease of this frontend tool allowed to save workbook only on the BI platform.

The file format that you can store are: xls,xlsx, ppt and pptx and is necessary on SAP BW have an role that contain the authorization object R_RS_AO.


To save an workbook on SAP BW is very simple : after the workbbok is developed , selecting the Office Button , is available the function “Save Workbook” and “Save to SAP NetWeaver”.


Then a window appear that permit to choice where save the workbook: in a Role or in the folder “My documents”.


In SAP NetWeaver Business Warehouse, Analysis objects are stored with object type AAOE (for workbooks) and AAOP (for presentations).

When the user, access to SAP BW by SAP GUI, the workbook will be visible on the menu:


To launch the analysis workbook from SAP menu is necessary SAP Netweaver BW 730 SP8 (see SAP Notes 1724842).

You must be Logged on to comment or reply to a post.
  • I can save the workbook, but when i opened it again, i can save the data. Even if i changed the data, but the save data button is still greyed out.

    The query itself can be used to save the data.

    Can you let me know if there is anyting i missed when i saved the report?


  • Hi Andrea,

    After saving ┬áthe analysis office workbook to the role. how to move the MS document in the role from DEV to QA? . I am moving the role to QA but when i try to launch in QA it says , ” MS document doesn’t exist”. please advice.

  • Hi,
    Can you try to find your workbook going in :

    1. RSA1
    2. Transport Connection
    3. Select as Object type : Workbook
    4. Include it in an trasport