Skip to Content

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

To report this post you need to login first.

9 Comments

You must be Logged on to comment or reply to a post.

    1. ANDREA MARAVIGLIA 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

      (0) 
      1. 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

        (0) 
        1. ANDREA MARAVIGLIA 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

          (0) 
  1. 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

    (0) 
  2. Murthy Doddamalur Sathyana Satish

    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.

    (0) 
  3. ANDREA MARAVIGLIA 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

    (0) 

Leave a Reply