Skip to Content

BusinessObjects Analysis Office 1.3: Does it have Report-to-Report Interface? More on BEx Workbook Conversions

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.

14 Comments
You must be Logged on to comment or reply to a post.
  • 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

  • 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

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

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