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

[TammyPowlas]

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

Figure 1

I click on Convert BEx Workbook button

Figure 2

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

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

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:

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)

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.