Skip to Content
Author's profile photo Former Member

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.

aut_obj_aoffice.PNG

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

/wp-content/uploads/2013/01/analysis_bw1_176369.png

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

/wp-content/uploads/2013/01/analysis_bw2_176377.png

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:

/wp-content/uploads/2013/01/analysis_bw3_176379.png

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

Assigned tags

      9 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Gill Leo
      Gill Leo

      Hi Andrea,

      Can you share the configurtion needed to enable the Save As to Netweaver?

      Thanks

      Gill

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Hi ,

      if you install the latest version of Analysis for Office, this option is available.

      Then you need that SAP BW is at least an 7.3 ( see the note mentioned)

      Regards.

      Andrea

      Author's profile photo Gill Leo
      Gill Leo

      Hi Andrea,

      We have the latest version of Analysis installed but surely there is some config needed to backup the option to Save to Netwevaer?

      When I hit it I get this:

      This function is not supported on the selected system (XXXXXX SSO). A specific SP level is required for the back end.

      Contact your administrator (ID-113002)

      With thanks
      GIl

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Hi Gill,

      yes, is necessary to have an SP level on Netweaver to use this functionality.

      Which is the version of BW that are you using with Analysis?

      Andrea

      Author's profile photo Patrik Maag
      Patrik Maag

      Hi Gill,

      Please take a look at following note to find out which SP & notes are required.

      1739153 - SAP BW Backend requirements for Analysis Office 1.3 or higher

      Best regards,

      Patrik

      Author's profile photo Former Member
      Former Member

      Hi All! Can I share AO workbook from pfcg t-code (like BEX workbook )  ?Has anything changed in AO 2.0?

      Best regards, Alexander

      Author's profile photo Charlie Lin
      Charlie Lin

      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?

      Charlie

      Author's profile photo Former Member
      Former Member

      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.

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      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

      Andrea