ASUG had a webcast on the Analysis clients today, mostly about BusinessObjects Analysis, MS Edition for Office.
Please note the usual legal disclaimer applies that anything in the future and discussed here is subject to change.
Figure 1: Source: SAP
Figure 1 shows the Analysis “Family”
Analysis Office is integrated with MS office family – Excel & PowerPoint
Design Studio is the web application for dashboards.
Analysis OLAP Web Client, Edition for OLAP > the development is mostly complete
Figure 2: Source: SAP
Design Studio can consume universes as shown in Figure 2.
Figure 3: Source: SAP
Figure 3 shows a Power User – a controller to create his own calculations
You can use Analysis Office as a design environment for creating interactive workbooks to share with a business user – create buttons, etc.
You can also use it to provide guided navigation for a business user
You can use it for creating PPT presentations. It also supports BW Integrated Planning.
Figure 4: Source: SAP
Figure 4 shows there are no changes to the BEx queries.
Conversion from BEx Web is planned for Design Studio.
BEx tools are in maintenance mode per Figure 4.
Been on the market for a few years
Figure 5: Source: SAP
Latest release of Analysis Office 1.4 was released last year
It included a minor release for LCM and SSO
It added interoperability with Design Studio
Figure 6: Source: SAP
Figure 6 shows scheduling. It does not support prompts – when will this occur – SAP is trying to get resources to do this in the short term.
Figure 7: Source: SAP
Figure 7 shows it is very complex project now – on the right side
They are changing access to HANA. Today use ODBC approach via SQL to HANA and this has limitations
They decided to directly access HANA engine
This new approach will have SSO to HANA
It includes catching up with BW – regarding unified planning model
Table design – add empty rows, columns, change styles for specific cells
Comments API are coming in future direction
Lumira work – for Lumira Server – store Analysis workbooks on Lumira Server
Figure 8: Source: SAP
Figure 8 shows the combined planning model
Unified Excel Client is superset of Analysis & EPM Excel client, with move to single Excel w/ 2 ribbons to feel like the same client
To be continued..
SAP BusinessObjects BI 4.1, SAP BW, and SAP BW on HANA – All in One Day Hands on Full Day- see
ASUG at SAP d-code:
If you have an Analysis story to share, ASUG invites you to submit an abstract for SAP dcode for Las Vegas (aka SAP TechEd) – call for sessions is open now through May 25th – follow this link to create a speaker account where you can formally submit your proposal, review important deadlines, and other general information about SAP d-code.