Last week SAP provided an ASUG webcast on Analysis Office 1.3 which is now in ramp-up. Below I am focusing only on converting BEx Workbooks to Analysis Office and I am also including the webcast’s question & answer to share with everyone.
Figure 1: Source: SAP
In this webcast, SAP said the workbook conversion is not a tool for mass migration
It takes into account the filter and navigation state of data sources
It is not an item-centric approach; some components not converted such as navigation pane/block as Analysis has the Design panel
There is a detailed log created if you enable it – what is converted/not
Figure 2: Source: SAP
Figure 2 shows what is a convertible object and what is not convertible.
Buttons are not converted due to Ribbon concept in Analysis Office.
Figure 3: Source: SAP
Figure 3 shows the conversion options and possible settings
Recommendation is to show the log in an invisible sheet so you get an idea what is happening.
Figure 4
Figure 4 shows an actual conversion of a BEx Workbook to Analysis Office. You can see on the bottom of Figure 4 that the navigation pane is not convertible.
Related posts:
BusinessObjects Analysis Office 1.3 Your First Steps and New Features
BusinessObjects Analysis Office 1.3 – Does it have Report to Report Interface
Below is the Q&A from last week’s webcast.
Question & Answer from ASUG Webcast on Analysis Office 1.3
Q: Is there a size limit on the file that can be uploaded (reference to BW workspaces)
A: Have not specified a size limit; validate with customer scenarios
________________________________________________________________
Q: Are there any performance/functionality differences between accessing HANA via JDBC and ODBC
A: There is detail information on the connections at http://help.sap.com/businessobject/product_guides/boexir4/en/xi4_data_acs_en.pdf
________________________________________________________________
Q: I want to schedule the analysis workbook
A: it is planned ... most probably in a 2013 release
________________________________________________________________
Q: any updates on Dynamic Parameter from Web Intelligence or Crystal to Analysis workbook
A: Have RRI support as sender. The next release should also cover the receiver side.
________________________________________________________________
Q: Is there a variable to choose which hierarchy to be used?
A: sure, you can use hierarchy variables.
________________________________________________________________
Q: Is it possible to apply a OSS note and get this functionality of Saving workbooks on SAP Netweaver system instead of upgrading the whole system to SP11....?
A: unfortunately not
________________________________________________________________
Q: Can we refresh individual worksheets instead of the complete workbook?
A: sure, you can refresh individual data sources. Context menu -> Refresh
________________________________________________________________
Q: Can BEx workbook be converted to Analysis for Office document if BEx workbook have multiple queries on multiple tabs?
A: yes, conversion also works with several data sources
________________________________________________________________
Q: Have you seen these workspace upload features used to deploy a planning/budgeting solution, where users upload updates to their budget numbers periodically?
A: no, planning is typically more than just entering new values … it is about planning functions etc. … we’re currently discussing extending that functionality to planning some time, but that is not yet confirmed yet …
________________________________________________________________
Q: Is it possible to refresh the workbook which is transported to another system
A: Yes
________________________________________________________________
Q: Can we use "Calculation" functionality for Analysis for Office on top of HANA?
A: yes, some calculations are supported ...
________________________________________________________________
Q: Will BEx conversion to Analysis for Office document support BEx structures?
A: Sure, they are part of the query/data source, not of the workbook
________________________________________________________________
Q: Any body know if there is a way of integrating an analysis in MS Word. Is it possible to embed a presentation containing an analysis? Is Live office the only alternative? ( but seems there are some limitations currently if report is using BICS connection)
A: no Word integration at this point in time … planned, but currently not with highest priority.
My thanks to SAP's alexander.peter and tobias.kaufmann for this webcast.
- SAP Managed Tags:
11 Comments
