Skip to Content
Author's profile photo Tammy Powlas

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.

Assigned Tags

      14 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Nikhil Chowdhary
      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

      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog 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

      Author's profile photo Stephen Hobbs
      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

      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author

      Hi Stephen,

      Please see the Q&A from this blog:

      http://scn.sap.com/community/businessobjects-analysis-ms-office/blog/2012/07/22/sap-businessobjects-analysis-office-13-bex-workbook-conversion-details-qa

      So it is dependent on going up a support pack / upgrade; there will not be any downporting.

      Thanks for reading

      Tammy

      Author's profile photo Former Member
      Former Member

      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

      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author

      Hello Tobias Sanchez Bergmann

      I am not an expert at RSBBS

      Would you please post this question in the discussion forum so the community can respond?

      Many thanks,

      Tammy

      Author's profile photo Former Member
      Former Member

      Tammy,

      Thanks for your inputs on these emerging technologies.

      I posted this question couple of days ago, and I was wondering if you came across this issue and have any kind of resolution that you can share. Please let me know if you have any suggestions.

      Size Limit of Result Set Exceeded in SAP Business Objects Advanced Analysis for Office 1.2

      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog 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

      Author's profile photo Former Member
      Former Member

      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.

      Author's profile photo Former Member
      Former Member

      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.


      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author

      Hello - in the future I recommend posting these types of questions in the discussion area

      Please see this discussion where this has already been asked and answered:

      http://scn.sap.com/thread/3272923

      Thank you for reading the blog.

      Tammy

      Author's profile photo Former Member
      Former Member

      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! 😥

      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author

      zhiwen xie

      I recommend submitting a support note and searching OSS - my guess is there are other notes that you may have to apply to get this working

      Regards,

      Tammy

      Author's profile photo Former Member
      Former Member

      Hi,

      Check out these SAP Notes - 1757050 and 1677627 Would be applicable in your case.

       

      Regards,

      Sri