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
I click on Convert BEx Workbook button
I locate the BEx 3.5 workbook and open as shown in Figure 2
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 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 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 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.