Skip to Content

This was an update from BI on Excel Roadmap – ASUG BusinessObjects Conference Update but contains more details.

Please note the usual legal disclaimer applies that things in the future are subject to change.

/wp-content/uploads/2014/11/1fig_577179.png

Figure 1: Source: SAP

Three SAP products + a partnership with Microsoft

Analysis Office is one the best integrated tools in to BW and HANA

EPM add in is for the BPC based

Live Office for the old Universes (UNV)

SAP has partnership with PowerBI for UNX

/wp-content/uploads/2014/11/2fig_577180.png

Figure 2: Source: SAP

The plan is for a single unified Office client crossing HANA, BPC, BW

Plan to extend Live Office to new universes (UNX) next year (Q2)

/wp-content/uploads/2014/11/3fig_577190.png

Figure 3: Source: SAP

EPM comes from Finance business user

Figure 3 shows the background for EPM

Shared access, apply dynamic formatting

It is integrated in Excel, PPT & Word

It has an offline mode

/wp-content/uploads/2014/11/4fig_577191.png

Figure 4: Source: SAP

Analysis Office comes from pivot table approach

Easy drag and drop onto the crosstab

Ad hoc for BI professional

It also has PowerPoint (no Word)

It supports BW IP and new embedded model

It has a rich API to build powerful Excel Workbooks; can use that to guide functionality

This is today’s positioning

/wp-content/uploads/2014/11/5fig_577192.png

Figure 5: Source: SAP

Investments are protected

If not on BW 740, recommend Analysis Office

If come from BPC classic, continue EPM add-on

At the end will have a unified Excel client

/wp-content/uploads/2014/11/6fig_577196.png

Figure 6: Source: SAP

Figure 6 shows the strengths of Analysis Office, including its ad-hoc features

SAP said it handles Big Data

It offers multi-platform support

/wp-content/uploads/2014/11/7fig_577197.png

Figure 7: Source: SAP

Figure 7 shows BEx Support for 10.1

Important to know what does not work yet (the limitations)

Roadmap

/wp-content/uploads/2014/11/10fig_577198.png

Figure 8: Source: SAP

Regarding Figure 8, the plan is to use without migration effort

Step-wise convergence through a common layer in Excel that synchronizes and governs Excel events

/wp-content/uploads/2014/11/11fig_577199.png

Figure 9: Source: SAP

Figure 9 pictorially shows the unified client.

/wp-content/uploads/2014/11/12fig_577200.png

Figure 10: Source: SAP

Figure 10 is the convergence for the Roadmap

Plans include a single installer, documentation

It contains UX harmonization – open and save dialogs

/wp-content/uploads/2014/11/13fig_577201.png

Figure 11: Source: SAP

Figure 11 has been discussed before

Question & Answer

Q:  Scheduling?  Scheduling without prompts support…  Not very productive.  When will prompts be available in scheduling?

A: It is being planned (planned innovations)

________________________________________________________________

Q:  with the unification of EPM and AO, which broadcasting utility will it use — EPM’s or Business Objects?  I would prefer not Business Objects.

Q:  I would prefer the scheduling like BEx.  I don’t want to have to have this in the Business Objects framework.

A:  BI platform supports, will extend to HANA.  Priority is the BI Platform for scheduling.  Looking at extending to Netweaver but not a concret time to deliver.  More customers requiring can move the priority 

________________________________________________________________

Q:  Will the future unified excel client support BPC 10.0 or you will need to be on version 10.1?

A:  yes it will support 10 

________________________________________________________________

Q:  sorry, maybe I missed, but he started by mentioning three current Excel interfaces, EPM/BPC, Analysis for Excel (OLAP), and Live Office — but this last seems to have been dropped from discussion now, what is future plan for LO (or is that still coming)?

A:  He said Live Office would support new universe in Q2 2015 (planned) – it is being worked 

________________________________________________________________

Q:  so Live Office will continue separate as is, ie. not part of convergence currently being discussed? thanks

A:  Mid term yes

________________________________________________________________

Q:  Scheduling with prompts looks like it is coming!  Great!  Any work being done on publications with A4O?

A:  on the backlog with low priority for now.   

________________________________________________________________

Q:  Can current versions of EPM and AO addins work without any conflicts now?  If not, when will this happen?

A:  side by side next year 

________________________________________________________________

Q:  A-Office view events are not created in Audit database now. Is there any plan to have those events as part of Audit DB with the unified client ?

A:  specific to BW, HANA – look at BW for stats 

________________________________________________________________

Q:  Will we need to install Excel on the BI4.1 server to schedule Analysis workbooks?

A:  You need to install the Analysis add-on to BIP – available at support.sap.com/swdc  

________________________________________________________________

Q:  Are there any possible Fiori integration in the horizon?  

A:  nothing planned for designed principles.  AO designs for what is typical for use.  To be reviewed in the future 

________________________________________________________________

Q:  It will be good to analyse in one Excel document data  that stored in the cubes (BW/HANA) and relational database (Universe), any plans to ad Universe support for unified Excel client ?

A:  Should happen in the future – complete framework that supports Live Office – no concrete plan  

________________________________________________________________

Q:  It sounds like SAP is integrating BPC/outlook features to IP. ?

A:  yes 

________________________________________________________________

Q:  with BPC there are folders where EPM files can be stored in,  will this be available to AO as well?

A:  Still have to find out 

________________________________________________________________

Q:  how about SAP Portal km for storage.  🙂

A:  Not sure – could use BI Platform, BW, HANA – first time KM repository for BI – open to discuss but have enough with 3 repositories 

To report this post you need to login first.

13 Comments

You must be Logged on to comment or reply to a post.

  1. Miguel Alonso Bernard

    Dear Tammy,

    I’m a SAP partner, working for a prospect, who uses SAP BW and is interested in Analysis for Office.

    The prospect looks for a fonctionnality equivalent to “member recognition” of EPM Add-in from SAP BPC.

    My questions are:

    Do you know if the roadmap for Analysis for Office will have an equivalent funcionality? The current version 2.0 doesn’t.

    When the unified excel tool will be delivered? 

    This new excel tool will have this member recognition funcionality?

    Thank you in advance,

    Miguel

    (0) 
    1. Tammy Powlas Post author

      Miguel – I believe the unified client is planned for Analysis Office 2.1 – I’ll have to check my notes from last week regarding member recognition functionality

      (0) 
      1. Miguel Alonso Bernard

        Thank you for your reply, and thank you for checking about member recognition functionality.

        Meanwhile, Do you know when Analysis for Office 2.1 will be available?

        Regards,

        Miguel

        (0) 
    2. Tammy Powlas Post author

      Unified tool is planned for 2.1 – with no planned loss in functionality on either side – which means it will will have the EPM member recognition

      (0) 
      1. Venkata Subhash Medisetty

        Hi Miguel Alonso Bernard & Others,

        my apologies, i talked with with colleagues and still not available in ramp up

        expected to be available soon(couple of days)

        i will update you once it is available in ramp up

        Regards,

        Subhash

        (0) 

Leave a Reply