Skip to Content

Yesterday I showed how to convert a simple BEx 7.0 Analyzer Workbook.  Today I am trying to convert a BEx 3.5 Workbook into Analysis Office

Converting BEx Workbooks

/wp-content/uploads/2012/07/1fig_118949.png

Figure 1

I click on Convert BEx Workbook button

/wp-content/uploads/2012/07/2fi_118950.png

Figure 2

I locate the BEx 3.5 workbook and open as shown in Figure 2

/wp-content/uploads/2012/07/3fig_118954.png

Figure 3

Figure 3 shows the opened 3.5 BEx workbook in Analysis Office

Report to Report Interface

The Report to Report Interface, sometimes called by SAP as “Insight to Action”, was available before in BEx Workbooks and now it is available in Analysis Office.  The typical scenario is to have a summary report and drill into the detail using the report to report interface.

First you have to set this up on the backend of BW using transaction RSBBS (there are plenty of SCN community contributions that already cover the RSBBS steps).

/wp-content/uploads/2012/07/4fig_118951.png

Figure 4

Figure 4 shows the sender receiver set up in RSBBS.

In this example, I will start with a summary report in Analysis Office and drill into the ticket detail:

/wp-content/uploads/2012/07/5fig_118952.png

Figure 5

Figure 5 is a summary report of open incidents.  I select right click (context menu) on FI-GL tickets, then Go to Message List (receiver report in Figure 4)

/wp-content/uploads/2012/07/6fig_118953.png

Figure 6

Figure 6 shows the report I jumped to, showing the detail of the FI-GL incident tickets.

Figures 5 and 6 show how the “RRI” interface works in Analysis Office.

There are more features in Analysis Office 1.3 which is in ramp-up covered here.  It will now support HANA hierarchies, prompts and BW 730 workspaces.

To report this post you need to login first.

14 Comments

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

  1. Nikhil Chowdhary

    Hi Tammy,

    Great overview.

    I had a question on BEx Analyzer workbook conversion – does it require a specific SP level for the backend? I seem to get this error message when I try converting:

    “This function is not supported on the selected system <system name>. A specific SP level is required for the back end”

    Thanks in advance,

    Nikhil

    (0) 
    1. Tammy Powlas Post author

      Nikhil Chowdhary

      Thank you for commenting and reading.

      Yes it does require a specific SP – please see below

      SAP NetWeaver BW 7.01 SP 11 or higher

      SAP NetWeaver BW 7.02 SP 10 or higher

      SAP NetWeaver BW 7.30 SP 5 or higher

      SAP NetWeaver BW 7.31 SP 1 or higher

      Tammy

      (0) 
      1. Stephen Hobbs

        Hi Tammy, I’ve just tried the same and found your message above! 🙁

        Will there be an OSS note to allow us to convert or is it all dependant on us upgrading to the above?

        Thanks,

        Stephen

        (0) 
  2. Tobias Sanchez Bergmann

    Hi Tammy,

    thanks for the overview!

    One question regarding the RSBBS feature in Analysis 1.3:

    I am trying to use a sender / receiver assignment which was used with BEx Analyzer 7 in the past. Receiver object is an ABAP Report.

    While BEx Analyzer 7 always opens up the SAP GUI when jumping into the RSBBS destination Analysis 1.3 tries to open the SAP Web GUI. Where can I configure the target environment (SAP GUI vs. SAP Web GUI)?

    Thanks in advance,

    Tobias

    (0) 
        1. Tammy Powlas Post author

          Hi – I have not seen this error.  I know Analysis Office honors the MS Excel version/settings

          Did you search OSS?

          Regards,

          Tammy

          (0) 
  3. Mikhail Budilov

    Hi Tammy.

    Thanks for blogs about A-Office.

    About RRI in A-Office:

    When you go to target, target report opened they prompt for parameters in background window. (users can’t see them).

    It isn’t user friendly.

    In Bex RRI target opened without additional windows (prompt) – parameters filled automatically.


    P.S.> Also we identified some of interesting bugs and miss-functionalities. Open OSS messages about that.

    (0) 
  4. zhiwen xie

    Hi Tammy.

    I had a question on Save Analysis to sap netweaver it message:

    It message that : This function is not supported on the selected system (SX_BWP). A specific SP level is required for the back end.

    Contact your administrator (ID-113002)

    we sap support pack SAP NetWeaver BW 7.02 SP  7

    if it need upgrade SAP NetWeaver BW 7.02 SP 10 or higher? plz help me.

    thanks a lot.


    (0) 
      1. zhiwen xie

        hi tammy:

             Thanks for you reply,i had upgrad SAP NetWeaver BW 7.02 SP 12 but unfortunately i had not SAVE the Analysis to sap netweaver server ,it message that”Unknown Error – Document could not be saved !!”plz,help me thank a lot! 😥

        (0) 

Leave a Reply