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.


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


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)


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


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


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


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


Figure 7: Source: SAP


Figure 7 shows BEx Support for 10.1


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




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


Figure 9: Source: SAP


Figure 9 pictorially shows the unified client.


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


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  


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 

Join us on Tuesday October 21st for the ASUG Analysis Influence Council session EA117. 



David Stocker.jpg



David Stocker is the Technical Product Manager for Analysis Office and Design Studio. He has a development background and was an Analysis Office developer for several years before moving into his product management role.


David Stocker will be providing an Analysis Overview along with an update on Analysis Office 2.0 and Analysis OLAP 4.1. 

We will also have time to answer your questions and to take your input and recommendations on SAP Analysis improvements and direction. 


Come join in on the discussion to drive product strategy via our forward looking discussions. 


learn && be heard

For more information, visit SAP TechEd 2014 Las Vegas

The usual Legal Disclaimer applies that things in the future are subject to change.  SAP presented this at yesterday’s ASUG BusinessObjects Conference.  My notes are not complete as the hotel experienced AV issues so we didn’t see any slides 25 minutes into the presentation.


Figure 1: Source: SAP


Figure 1 shows the options today with Excel and SAP data sources.


Figure 2: Source: SAP


SAP said it took time to work on table formatting


For Analysis Office, they wanted to reach the point to close the BEx gap list


With third party access to your data source, it is never completely right


SAP has decided to update Live Office


SAP cannot give a timeframe on Analysis Office connection to universes


Figure 3: Source: SAP


Figure 3 shows ongoing work/updates to Live Office.


Figure 4: Source: SAP


UNX support for Live Office will be available by end of Q2


Figure 5: Source: SAP


Figure 5 covers the unified planning model.


Figure 6: Source: SAP


Figure 6 shows the convergence time line


The speaker also mentioned the "Concept of Unified Excel client as part of Design Studio/Lumira story" and to learn more at TechEd next month.



Stay Ahead : Attend TechEd && d-code – Win Big SAP BI BusinessObjects HANA Hands-on Sessions

Join SAP at the end of October for Reporting & Analytics 2014 INTERACTIVE conference - register here

This was a webcast today with SAP's David Stocker.


The usual SAP legal disclaimer applies that things in the future are subject to change


New roadmaps are coming at Las Vegas SAP TechEd


Figure 1: Source: SAP


BW supports of all BEx queries, calculated/restricted measures, structures, all types of variables, special OLAP functions, runtime currency conversion, variable merge and unmerge, full hierarchy support, and compact axes as of Q3 2014


In Q4 SAP plans to release in November Analysis Office 2.0


Convergence with Live Office is not in immediate timeline; SAP is working on EPM client


A future direction for Analysis Office to store and run on HANA and where HANA is acting as BIP/BW


Figure 2: Source: SAP


Figure 2 covers the EPM for BPC server


There is a convergence strategy with Analysis Office & EPM the speaker said they are not there yet


There is a NetWeaver Planning model in BW 740.  The next step comes in Analysis Office 2.0 to implement a core framework with both apps installed together.


Figure 3: Source: SAP


Native means connecting to the HANA backend up until 1.4 using the ODBC connection.  Customers for security reasons can’t use ODBC.


With Analysis 2.0 you can do http or https connection to backend to be used for Cloud with the BICS on client on backend


Figure 4: Source: SAP


Figure 4 shows how to define a local connection in Analysis Office 2.0: Use context menu and insert host name, port


Figure 5: Source: SAP


Figure 5 shows HANA /Analysis Office supported features, including scaling factor support


Figure 6: Source: SAP


Level based hierarchies can’t have multiple parents; this also applies to Design Studio


SAP note 2038663 is a general BICS on Hana limitation which also applies to Design Studio


The speaker said “any limitation here also applies to Design Studio”


Figure 7: Source: SAP


BIP is the recommended platform


Figure 8: Source: SAP


SAML ticket is the same mechanism that Design Studio uses in the BI Platform to Hana scenario


Figure 9: Source: SAP


The best practices are also the same for Design Studio


Build smaller, more dedicated calc views, easier for when user comes in contact with query


Part 2 is coming, focusing on Design Studio with Question & Answer



Consider attending SAP TechEd && d-code .  Join ASUG for the ASUG SAP TechEd Pre-conference HANDS-ON: SAP BusinessObjects BI 4.1, SAP BW and SAP BW on SAP HANA – All in One Day, October 20th.  This includes exercises for Analysis Office and SAP BusinessObjects Design Studio. Register today


Also see:

Stay Ahead : Attend TechEd && d-code – Win Big SAP BI BusinessObjects HANA Hands-on Sessions


Next week David Stocker is presenting BI on Excel Update and Roadmap at the ASUG SAP Analytics BusinessObjects Conference. See Predictive Analysis and Analysis Sessions a ASUG SAP Analytics BusinessObjects Conference


Join SAP at the end of October for Reporting & Analytics 2014 INTERACTIVE conference - register here

On our “How to Guidelines” session of our “SAP BusinessObjects Analysis, edition for Microsoft Office” wiki page you can check all information to set the result size limit of your Analysis for Office. You can also check how to analyze the limit once you got a limit issue. Check it out: Analysis for Office Result Limit and Memory Consumption.


There you will find:

  • Front End Requirements and Memory Consumption
  • .NET Framework
  • Result size Configuration
  • Customizing table RSADMIN
  • Checking on RSTT trace



Diego Ferrary



Continuing the ASUG SAP TechEd && d-code meet the speaker series (Las Vegas), I am pleased to introduce speaker Joyce Butler


Joyce has been an ASUG Volunteer since 2002 and she is also anSAP Mentor


Joyce is presenting session EA 117 End Analysis Paralysis with the ASUG Analysis Influence Council


Meet Joyce (pictured left with SAP Ingo Hilgefort) :


Joyce is an SEC Alabama Crimson Tide football fanatic.  She is also the lead for the ASUG Analysis Influence Council.


She has "led over 14 full life cycle SAP BI projects within both supply chain and finance Since 1999, implementing SAP Business Intelligence decision support applications for use in financial and supply chain reporting and analysis ASUG volunteer since 2002" according to her speaker profile.  In addition to leading this ASUG Analysis Influence Council, she also leads the Design Studio Influence Council and services as the ASUG Analtyics Special Interest Group chair.


I asked SAP's David Stocker to comment on Joyce and he said the following:


Joyce’s hard work as an ASUG leader is instrumental in connecting SAP to the heartbeat of our BI user community; and the community to SAP.


Joyce helps lead the council in gathering requirements, driving towards a better solution for the customer and SAP.  You can see the Council's achievements How ASUG Members Influenced Analysis Office (and Sneak Preview)


The council helps drive product strategy for the next major release and upcoming releases.  It is one of the best benefits of ASUG.  Here is the abstract for this session:

Influence SAP at this open and interactive session for the ASUG Influence Council for SAP BusinessObjects Analysis, editions for Microsoft Office and OLAP. SAP would like your feedback and the ASUG Influence Councils are the best form of input back to SAP. Learn how this Influence Council has already influenced SAP.


I asked Joyce what else she is doing at SAP TechEd && d-code and she is attending the SAP BusinessObjects BI 4.1 and SAP BW – All in One Day Pre-conference session on October 20th (see more information here)


Here are some great blogs by Joyce:

My opinions and take-aways ASUG2014 and SapphireNow

Be Heard - Join us for ASUG:SAP BOBJ Design Studio Influence Council Update

BI Strategy - part 1 Table of Contents


Get Joyce's take on TechEd from this video from last year.  She's been attending TechEd since 2002!

"You build IT Solutions for your business users"

Joyce also wants to see SAP's Ingo Hilgefort as a raccoon You would like to see me as a racoon... here is your chance....

ASUG Pre-conference Sessions

ASUG is has opened registration for pre-conferences session at SAP TechEd && d-code on Monday, October, 20th  - see Announcing ASUG SAP TechEd d-code Pre-Conference Sessions


See Your fast track to the SAP HANA Cloud Platform at the ASUG pre-conference posted today by Rui Nogueira



Join ASUG at SAP TechEd && d-code

Venetian/Palazzo Congress Center

ASUG SAP d-code Las Vegas sessions are now published - for a complete listing please see here



Meet ASUG SAP d-code Speaker Charles Reeves - Implementing Enterprise Master Data Management

ASUG SAP d-code SAP BW 7.4 powered by SAP HANA Speaker - Introducing Pawel Mierski

ASUG SAP d-code Sessions Are Published - Featuring SAP Mentors

Journey to Mobile BI - Meet ASUG SAP d-code Speaker Peter Chen

Did you know?

Meet ASUG SAP TechEd d-code Speaker Kumar Chidambaram - Holistic BI BW on HANA Approach

Meet ASUG SAP TechEd d-code Speaker Heiko Zuerker - Solution Manager

Meet ASUG SAP TechEd d-code Speaker Sue Keohan - Customer Connection for Workflow

Effective SAP ERP on HANA Migration Strategy - ASUG SAP TechEd d-code Speaker Rajesh Gupta

Meet ASUG SAP TechEd d-code Speaker Girish Manmadkar - SAP HANA on VMWare Best Practices

Newell Rubbermaid Mobile Story to Improve Sales - ASUG SAP TechEd d-code Speaker Mohammed Siddiqui

Meet ASUG SAP TechEd d-code Speaker Sue Keohan - Customer Connection for Workflow

ASUG SAP TechEd d-code Speaker Profile - Martin Maguth - Top 10 Tools for Workflow Administrators

Comprehensive SAP Monitoring – Recognize Problems Before Your Users Do - Meet ASUG SAP TechEd d-code Speaker Jon Friesen

Meet ASUG SAP TechEd d-code Speaker Dave Beldyk of DuPont - Learn about Wood Turning

Meet ASUG SAP TechEd d-code Speaker Jolene Jonas and Learn about Intel's Master Data Program

Meet ASUG SAP TechEd d-code Speaker Kyle Wardell - Migrating Dual Stack Systems - Jump

Join ASUG in October and meet Joyce in person.

Hi Customers,


SAP just delivered Analysis for Office 1.4 SP8 that contains the following SAP corrections:


  • 2041930 Convert To Formula does not work for dimension members with spaces
  • 2041133 Analysis Office dumps when importing text files into MS Excel with drag and drop
  • 2038901 Analysis Office prevents Excel from closing
  • 2038664 Log file contains API errors for SAPGetDimensionStaticFilter
  • 2037259 Analysis Office: Error at undo operation after workbook has been closed
  • 2034227 Text: 'Insert System.Reflection.Missing' in statistic step when inserting a query of query view
  • 2032253 Precalculation fails for workbooks with named ranges including special characters
  • 2032238 Enabled NCo tracing for BiPrecalculation
  • 2032085 AO: Timeout when trying to display list of data source from BIP
  • 2032069 AO on Office 2013: Inserting a data source from the backstage menu results in a exception
  • 2031598 Launcher does not create new Excel 2013 process
  • 2031244 Launcher fails when using Excel 2003
  • 2029946 Poor performance with large filters on Analysis tab
  • 2029886 AO 1.4: Excel 2013 - Performance issues when switching the context and when working with several workbooks
  • 2029832 Filter by Measure with Measure in Filter and Structure in the rows
  • 2028809 Exception when clicking in crosstab
  • 2028695 Using an apostrophe within a sheet name leads to an exception
  • 2027858 Bad performance during grid rendering in case of huge amount of columns
  • 2027119 Analysis Office: drag and drop / expanding hierarchy nodes not working using Excel 2013
  • 2027085 Adding the flat presentation of a dimension to the background filter does not work
  • 2026682 Reset Data Source and cancelling Prompts results in exception
  • 2025501 Filter Dialog and Value Help set and activate hierarchy for characteristic
  • 2025417 Removed Attributes / Access Mode menu entries for Mass Data Filter Dialog
  • 2023668 Missing translations in case of context menu for Execute Planning Function, Planning Sequence and Add Member tooltip
  • 2023432 Analysis Office: Exception if inserting a workbook from BW server after inserting a workbook from BIP server
  • 2023003 Missing alternative location for 'sapaocache' used for temporarily saved documents locally when opening Analysis workbooks from server
  • 2022924 Performance issue when pasting members from clipboard into Filter Dialog or Value Help
  • 2021910 Default value of setting CompressMetadata changed to true
  • 2021646 Workbook Logon User is not available when opening a workbook from the BIP Launchpad
  • 2020833 Analysis Office: filter information not displayed with correct member presentation
  • 2020434 Logging of AO launcher
  • 2020351 Propagate selection in hierarchically displayed keyfigures
  • 2019598 Poor performance when clicking on the information tab
  • 2019160 Exception Invalid Program Status\: No result set available when Pause Refresh is active
  • 2018409 SAPCallMemberSelector ignores parameter Selector Type if hierarchy is assigned to characteristic
  • 2018358 Analysis Office: Saving new document to the name and path of an existing document does not display a warning popup
  • 2017718 Formulas show error #N/A when cancelling prompts dialog
  • 2017317 AO 1.4: Wrong message "Data was saved (BRAIN-242)"
  • 2017284 Open workbook from backend several times may result in exception in case of OSS connection
  • 2016959 Formulas SAPListOfEffectiveFilters and SAPListOfStaticFilters only contains dimensions in drilldown
  • 2016735 AO cannot be used with Turkish regional settings
  • 2015452 AO 1.4: Hierarchy date is wrong for 9999/12/31
  • 2015441 Mass Data Filter dialog throws Out of Memory exception when too many data is pasted from clipboard
  • 2013551 User stylesets are missing after upgrade of Analysis Office
  • 2011200 AO: Undo history always contains the same decription text when changing the member access mode
  • 2011170 Emphasized formats does not occur correctly on planning cells
  • 2011111 Empty columns get rendered with maximum width
  • 2010638 Presentation doesn't get saved back to server on save
  • 2009865 Filter Dialog : Wrong data for member access mode
  • 2009468 Possible COMException with code 0x800A03EC when opening an Analysis workbook from server
  • 2008793 When launching variable prompts screen possible long messages are not available in message window
  • 2008055 Wrong node selection after change of time dependent master data object with enabled hierarchy in prompts dialog
  • 2007114 Translation not applied after copy of cross tab in components tab
  • 2006943 ArgumentException in some cases occuring if there are multiple sheets with same name in the workbook
  • 2005454 Searching for a Analysis workbook or presentation by description on BIP not possible
  • 2005434 Filter Dialog: Single value selection isn't applied
  • 2005278 Search in Filter Dialog on characteristic with hierarchy enables paste button
  • 2004759 Save Dialog: Entering a workbook name using IME
  • 2004021 SAP Formula is not calculated correctly when entered into a blank workbook
  • 2003968 Save Analysis workbook to BIP Folders view does not work
  • 2003401 Validating a variable value in the prompt dialog
  • 2003354 AO: Excel 2013 - Taskpane is still shown after closing a workbook
  • 2003278 Analysis chart is losing swap state of rows and columns after refresh
  • 2002592 Filter Dialog : Missing Access Mode switch for calendar view
  • 2002573 Formula shows result twice
  • 2001286 Analysis Office: nodes without text in Design Panel
  • 2000392 Server Type "Group" feature for Analysis Precalculation
  • 1994876 Value help does not display correct data
  • 1983668 Analysis Office: BEx Conditions and condition states in UI
  • 1976283 Error saving workbooks to BIP with relational connection to HANA system
  • 1962934 Performance: Pause Screen Update for Hidden Crosstabs
  • 1954665 Presentation doesn't get saved back to server on close
  • 1518359 SAP BusinessObjects Analysis Office & BIP Add On Release schedule

To download the Analysis for Office Client's support package 8 please click here.

To download the Analysis for Office BIP Add on support package 8 please click here.


You can also check SAP note 1910505 - Analysis Office 1.4: Release Note for SP8.


Diego Ferrary

Support Team, NW Technology, AGS Primary Support

SAP Labs Latin America


For more Analysis for Office tool please check:

Part 1 is A First Look at SAP BusinessObjects Analysis Edition for Office - Beta 2.0 and on this blog covers table design improvements available in beta version 2.0 for Analysis Office.


Now you can insert rows and columns in the crosstab.  Some background is shown below:

Source: SAP




To do this you need to edit the registry as shown below:



Figure 1


You need to set the TableInterface to True


Figure 2


Figure 2 shows the crosstab




Figure 3


Figure 3 shows when I right click on a row I have the option to insert the row before or after.


Figure 4


Figure 4 shows the results of inserting a row "after"


Figure 5


Figure 5 shows the option of inserting a column.when selecting the "title" dimension, in this case, "Project".


Figure 6


Figure 6 shows the results of inserting a column.


More to come and learn more about Analysis Office at SAP TechEd && d-code:


EA265 Hands-on:

SAP TechEd && d-code Las Vegas | October 20–24, 2014 | Home


EA117 ASUG Analysis Influence Council:

SAP TechEd && d-code Las Vegas | October 20–24, 2014 | Home


Monday, October 20th, ASUG will host a hands-on BI session - more to come soon.

We first heard of the beta for 2.0 for Analysis Office back in March at this ASUG webcast How ASUG Members Influenced Analysis Office (and Sneak Preview)


Beta is not for productive use and is a first look.  Things are subject to change by the time the product is GA.


I applied for the program, was approved and was able to download the software last week.  First thing I noticed was that Download Microsoft .NET Framework 4.5 from Official Microsoft Download Center was prerequisite; fortunately I was able to download it from the link in the installation.


You can have Analysis Office 2.0 and Analysis Office 1.4 on the same machine - the installation doesn't overwrite what is in already installed.


First there is a third panel in the display panel - Properties:


Figure 1 Analysis Office Beta 2.0


You can see in Figure 1 on the right the panels where you control compact display in rows, zero suppression, and display of negative values.  These features are available in today in Analysis Office 1.4 but not as easily accessible as they are in the 2.0 Display Panel.


Here is how Analysis Office 1.4 looks like today:


Figure 2 Analysis Office 1.4


Figure 2 shows the display panel on the right of the current GA version Analysis Office 1.4.


Figure 3  Analysis Office 2.0


Figure 3 shows the new Analysis Settings Ribbon, About Analysis and Help ribbons.  Again these settings are available in 1.4 but a little more easily accessible in 2.0



Figure 4 Analysis 2.0


Figure 3 Settings ribbon shows the Settings pop-up.


Figure 5 Analysis Office 2.0


Figure 5 shows a new feature of the context menu, the ability to right-click row after and row before.


More to come and learn more about Analysis Office at SAP TechEd && d-code:

EA265 Hands-on:

SAP TechEd && d-code Las Vegas | October 20–24, 2014 | Home


EA117 ASUG Analysis Influence Council:

SAP TechEd && d-code Las Vegas | October 20–24, 2014 | Home


Monday, October 20th, ASUG will host a hands-on BI session - more to come soon.

We had three ASUG BI-related roadmap sessions going on at this time so I feared attendance would be low at this session.  Fortunately the ASUG Annual Conference attendees showed up at this session.  Please note the usual legal disclaimer applies that things in the future are subject to change.


Figure 1: Source: SAP


Figure 1 shows the added value of Analysis Office, including the ease of use with the Design Panel. Some gaps that still exist with Analysis Office include broadcasting and documents.


Figure 2: Source: SAP


Figure 2 shows the latest roadmap, with a beta version coming out sometime this month.

3figunifiedplanning model.gif

Figure 3: Source: SAP


Figure 3 covers support for the unified planning model.  This is a "gradual convergence".  See Unifying BPC NW and BW-IP


Figure 4: Source: SAP


Figure 4 shows a demo of the upcoming Analysis Office 2.0 with the ability to insert a column in the crosstab.


Figure 5: Source: SAP


Figure 5 shows another demo example of the new design/display panel, or an enhanced side panel with the ability to change the formatting/properties.


The following slides were NOT covered during this session but in another session:


Figure 6: Source: SAP


Figure 6 shows planned innovations (meaning subject to change, subject to legal disclaimer) for Analysis Office.



Figure 7: Source: SAP (Planned Innnovations)


A common question is when will Analysis Office support Universes?  No news here but Figure 7 shows upcoming updates for Live Office/UNX.


Lastly, one of the reasons I wrote this blog was to support Your mission, should you decide to accept it...Marilyn Prattmission to blog about the event.  I hope others will share their experiences as well.

Hello everyone,


one of the big hurdles that customers face before converting from BEx Workbooks to Analysis Workbooks is the effort needed to migrate many workbooks as the standard options only allow us to go one workbook at a time. All the repetitive tasks for each one of the converted Workbook also increases the hurdle to go for Analysis for Office. SAP Consulting has now come up with automatic tools to reduce the manual effort in migration projects.


One of the tools allows to to migrate all BEx Workbooks in specific roles to Analysis Workbooks:



You can also configure the tool to do repetitive tasks, like saving all workbooks with a specific Prefix/Suffix, saving the Workbook to the original role or to another one, or also convert the BEx Navigation Pane to Analysis formulas:




I believe with all this settings the migration is less error prone and of course it reduces the amount of manual effort involved in a migration project. Why do I say "reduce" and not "eliminate"? Well because there can be very complex workbooks with VBA Code for example that require manual intervention.

Other areas of mass migration include the BEx Query Migration, which contains an application log and makes backups of your 3.5 queries, which is very handy in order to recognize problematic queries:



And the BEx Workbook (from 3.5 to 7.X) migration, which also has a nice a detailed log of what was done:



This tools are very interesting for customers that are still on BEx 3.5 because starting with SAP NetWeaver BW 7.4, the BEx 3.5 tools will not be supported any more.

Thanks for reading.


This is part 2 of ASUG Analysis Office Roadmap Webcast.


Part 1 is Analysis Roadmap Updates from ASUG Webcast Part 1


Everything in the future is subject to change and the usual legal disclaimer applies.


Beta Preview - these slides are a preview of Beta upcoming version, subject to change


Figure 1: Source: SAP


Figure 1 shows new table design, adding an Excel formula for complete row


Figure 2: Source: SAP


Figure 2 shows the planned sidepanel.  The multi select feature planned for after beta


Figure 2 shows how it extends the side panel


It is similar to the Query Designer


Figure 3: Source: SAP


Figure 3 covers new HANA access with the InA access, and the unified model.


Figure 4: Source: SAP


Figure 4 shows the ability to load ribbon without loading the complete add-in


Beta is planned for end of June


Question and Answer

(note there were several questions, can't vouch for 100% accuracy in answers (typing)


Q: When can we expect to see scheduling "query prompt support" in Analysis for Office?

A: cannot confirm 100%, but we're currently looking for resources to deliver it by end of the year.



Q: When will SSO to HANA data sources with Analysis for Office be added? Right now, we have to input the password manually or configure  BOBJ to handle the HANA credentials.

A: Coming in planned innovations



Q: Is Analysis edition for Microsoft Office being deprictated like LiveOffice is due to the new Microsoft product and partnership?

A: No - Analysis Office is still for BW/BEx Data Query sources and SAP is planning to provide .UNX support for Live Office -

A: see Q&A for roadmap here SAP BI Roadmap Future Direction - ASUG Webcast Part 3


Q: When will the support for universes be available on Analysis for MS Office?

A: Not listed on this roadmap; .UNX support is planned for Live Office - see Q&A SAP BI Roadmap Future Direction - ASUG Webcast Part 3


Q: When are planned innovations (slide 14) being looked at for having the deployment completed?

A: Standard SAP answer for roadmaps is 6-18 months for planned innovations



Q: What about Excel 2013 support ? Are there any plans to provide integration between PowerQuery/PowerPivot and BW Queries as datasource ?

A: Excel 2013 is supported now per the PAM at

No plans to provide integration for PowerQuery/PowerPivot


Q: One of slides says that you can transform Analysis Office Apps to iPad Apps using Design Studio (DS). We can export to Design Studio but it does not seem to use the iPad template in DS but just a normal web template in DS. Am I missing something?

A: No, you are not - have you tried Smart Copy Paste to Design Studio to see if it can use the template?


Q: Will Analysis Office have the same functionality that BPC has today for planning?

A: AO does not take the place of BPC.  The EPM Excel client that can now be used to visualize BPC data and AO will start merging functionality



Q: If you add the empty row / columns will they stay there if you save the workbook and refresh later?

A: Yes the Beta version functionality enhancing the table crosstab structure that allows the empty row/columns to be used for formula and save the formulas with the workbook



Q: Is the scheduling feature available in the Analysis, edition for OLAP as well?

A: No, and it is not planned.  Look to Design Studio for the future



Q: Are there any SAP "Best Practice" documents for hosting BW-based Analysis for Office content within the SAP BO-BI 4.1 Launchpad interface..? (eg. Add-On Server/Services, User Rights & Preferences, Desktop settings & config).

A: Direct this to the SAP BI Platform team...



Q: is there any documention on security using Analysis Office against HANA Calculation views

A: Nothing specific for Analysis Office - security for HANA - similar to BW  - leverage BW security infrastructure



Q: Did you say that there is a required BI 4.1 add-on install in order to use the new scheduling feature within Advanced Analysis 1.4?

A: yes


Q: Follow-up to my question: Install on the server or client machine?

A: On the server


Q: Does Analysis Edition for OLAP get additional formatting options, Similar to Webi 4.0?

A: Only limited developments going on for A-OLAP - with AO enhancements - if clients could allow - could expose features and - not working yet



Q: Does Analysis for Office support HANA unbalanced hierarchies?

A: Yes




Q: Can you clarify the filtering limitation on the new scheduling feature?

A: It doesn't support prompts




Q: Any plans to restore 'missing' BEx workbook functionality? (e.g. Back to Start, Drill Across Sheets)

A: In some ways already there - reset data source ; Undo button several; if others - use idea place at



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.

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.


  • BEx Analyzer widely used as the MS Office integration tool to analyse multidimensional data from SAP BW.
  • SAP have clearly positioned Analysis, edition for Office (AfO) as the "premium alternative" and eventual replacement to BEx Analyzer.


  • Understand if there are any gaps in functionality.
  • Understand what benefits could be gained by adopting now.




Note: At point of comparison, the following versions of the tools were evaluated.

  • Analysis, edition for Office 1.4 SP6 (14.6.2960)
  • BEx Analyzer 7.30 SP3 Revision 1906



Intuitive UI (larger buttons, contextual information, visual cues).

Current feature set is comprehensive and provides good coverage for typical BEx Analyzer users.

There are some features from BEx that are still lacking from Analysis. Those identified are planned for future releases (e.g. variable personalisation, variable history).

In addition to the improved UI, there are many features that are only available in Analysis that could enable faster and smarter ways of working.



Comparison: Select a Data Source

Recently used queries are immediately visible.

Ability to leverage OLAP connections defined in SAP BO (e.g. HANA)

Interoperability across BI platform via Analysis Views.

Support for multiple data sources.


Comparison: Prompts

Toggle display of all optional prompts at once via [Display] button.

Toggle display of specific optional prompts via pins.

Variable Personalization.

Variable History.


Comparison: BEx Text Elements (Information)

Not constrained where/how information displayed.

Drag and drop dynamic text elements directly into worksheet.

Info Field can be used for quick access to common elements.


Comparison: Filters

Improved UI enables users to identify filters at a glance.


Comparison: Navigational State

Improved UI facilitates faster workflows (no need to right click and access "query properties").

Quick access to attributes by expanding [+] sign.

Analysis pane visible by default and can be toggled via a single click.

Intuitive Columns, Rows & Background consistent with Analysis, edition for OLAP.


Comparison: Undo/Redo

Multi-step undo/redo.

No longer need to undo one navigation step at a time, able to jump to a particular state.


Other Benefits

Toggle automatic refresh.


Schedule (broadcast) via BI platform.


PowerPoint publishing.


Conditional Formatting.


Save workbooks to BI platform.



Unified "Design Mode" - no need to switch between consumption and design.

Support for multiple data source (e.g. multiple BEx queries in a single worksheet, combination of BW & HANA, etc)

Interoperability with Design Studio (e.g. prototype a web application).



  • Existing users who are familiar with BEx Analyzer will find the transition to Analysis relatively smooth. With a familiar MS Office UI, comprehensive feature set and overall improved design, unlocking value out of your enterprise DWH should be made even easier.


  • Analysis specific features such as interoperability with Analysis Views, interactions with the BI platform and access to more data sources will further support our ability to leverage existing investments (BW, HANA, BO) and promote cross collaboration across the wider BI community.


  • The intuitive design will attract new users who may have required BEx in the past but were intimidated by the non friendly UI, ultimately driving broader adoption.


  • Analysis is inline with SAP’s strategic focus and will be the target for future innovations. The tool appears to be sufficiently mature (1.4 SP6) to start being used today as the replacement for BEx Analyzer.

Hi All,


I just received an interesting question about Analysis for Office settings tab and I will share with you the tip to make it appears.


Situation: You upgraded the Analysis for Office from version 1.2.x or 1.3.x to Analysis version 1.4.x and on the settings screen you remains with 2 tabs (User Settings | Support Settings) as the screenshot below:

setting 0.png


As we know on the after version 1.4.x Analysis comes with more 2 settings tab (User Settings |  Advanced Settings | Plataform Settings | Support Settings) as below:


setting 1.png


On this particular case you will need to uninstall the entire Analysis for Office 1.2x or 1.3x and install the Analysis version 1.4.x that will contain the entire package of new features that will enclose the 2 new tabs.



Diego Ferrary

Support Team, NW Technology, AGS Primary Support

SAP Labs Latin America


Also check Analysis for Office’s blog:

For more Analysis for Office tool please check:


Filter Blog

By author:
By date:
By tag: