In the second part (see the first part here) of this blog series about Live Office, we will take a look how you can use SAP BusinessObjects Live Office in combination with SAP BusinessObjects Explorer.
As our first step we are using Live Office in Microsoft Excel and open an existing Crystal Reports from our SAP BusinessObjects Enterprise system.
In our example we are most interested in the data, not so much in report parts like a chart and therefore we are using the fields from the Crystal Reports objects.
Live Office will then insert the data into the Microsoft Excel spreadsheet…..
…. and we can use the menu option Sheet or Selection (shown above in the ribbon) and export the data to SAP BusinessObjects Explorer. The Information Space is created automatically based on the data type.
In our first example we used Live Office in combination with data from Crystal Reports, but the same scenario is also possible in combination with SAP BusinessObjects Analysis, edition for Microsoft Office.
Lets assume we have a Analysis workbook as shown above, showing several keyfigures broken down by Product and Year. Before we now use Live Office to share the data with SAP BusinessObjects Explorer we need to “tweak” the spreadsheet a little bit.
As you can see in the image above the value for the year is not repeated, which is the default behavior. This would lead to a “misunderstanding” of the data in SAP BusinessObjects Explorer and therefore we enable the option to repeat members in the workbook. This can be configured as part of the tab Components in the navigation panel when selecting the spreadsheet.
In addition by default your workbook will show the currency and the scaling factor for the keyfigures, which you can configure in SAP BusinessObjects Analysis by using the menu Measures from the ribbon. In our example we disable this, so that our header line becomes a single row in the spreadsheet – as shown below.
And now we can for example select a portion of our data….
…. use the Live Office menu Selection and share the data coming from SAP BW via SAP BusinessObjects Analysis with SAP BusinessObjects Explorer.