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