Skip to Content
Author's profile photo Tammy Powlas

Analysis Roadmap Updates from ASUG Webcast Part 1

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.

Analysis Office

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

Jump Start ASUG Annual Conference SAPPHIRE with a Pre-Conference Session – Back and Better than Ever

Preview of ASUG Annual Conference 2014: Focus on Analysis Office/OLAP/Predictive

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.

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Hi Tammy,

      Just to confirm. Is this "beta" version Analysis 2.x ?



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

      Figure 7 planned innovations is 2.0 beta - that is my understanding

      Author's profile photo Stephen Hobbs
      Stephen Hobbs

      Hi Tammy,

      Do you have any more information on the improved commenting mentioned as a possibility for v2.0? Is it more that the current Excel 'insert comment' facility available in 1.4?

      We would be really interested in this...

      Regards and thanks in advance,


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

      Hi Stephen - See slide 14 of the latest Analysis Office Roadmap (SMP logon)

      It says "Comments: API to connect to central commentary system "

      That is all I know; I expect we'll learn more in September when conference season starts.

      Author's profile photo Stephen Hobbs
      Stephen Hobbs

      Thanks for your ever-prompt reply 😉 . I will watch this space with interest. Any idea when v2 will be GA or will there we a ramp-up program?


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

      I don't have any specifics or details; I expect to hear more updates in September when ASUG has webcasts + conferences