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:

Hi All,


There is some situations where you have to manually activate the Analysis for Office Add-In.


Situation #1:


You cannot find the Analysis Add-In tab in your MS Excel or MS Powerpoint.


Situation #2:


You try to launch Analysis for Office and you are getting some errors like the messages below:

  • "Unable to launch Analysis Add-in"
  • "The launcher was not able to connect Analysis Add-In. Make sure that Analysis Add-In is not disabled by Office Application"


In these cases, Analysis Add-In may have been disabled by the Microsoft application after some crash. So you have to re-enable the Analysis Add-In in MS Excel or MS PowerPoint. This is very simple to solve and this post will show you how to do it.



1 – Open Excel Options.


picture 1.png


2 – Click on “Add-Ins” tab and select “Disabled Items” in Manage box. Then click “Go”.


picture 2.png


3 – If the Analysis Office Add-In is listed here select it and click on Enable.


picture 3.png


4 – If Analysis Add-In is not listed, like in the screenshot above, go back to Step #2 and select “COM AddIn” in the Manage box. Then click “Go”.


picture 4.png


5 – Make sure to have the Analysis Add-In checked and click “Ok”


picture 5.png


You can also check the SAP note 1672606 and the AO Admin Guide (Chapter 9 - Troubleshooting).




Filipe Zeuch
SAP Active Global Support
Also check Analysis for Office’s blog:


For more Analysis for Office tool please check:

Hi AO users,

We received some incidents related with installations where Analysis for Office got a message error when finishes the installation. We received also some incidents where Analysis for Office finishes the installation and do not appears at the excel tab.

Here I will describe some information about installation and troubleshooting.


== Requisites

When you are installing an Analysis for Office you have some requisites and to check those you will need to check the SAP note:

  • 1466118 Analysis Office hardware & software requirments

You also may need to check the PAM (Product Availability Matrix) for Analysis for Office so you will need to follow the below link:

You can also check the Admin Guide of Analysis for Office located on the Analysis for Office official page:


== Installation

Analysis for Office is easy and friendly to install.

SAP always suggests to install the latest delivered version as it contains delivered new features.

I already described the path to find the latest support package but for those that needed I will describe below:

  2. Download
  3. Support Packages & Patches
  4. Browse Our Download Catalog
  5. Analytics Solutions
  8. Comprised Software Component Versions


Win32 (for 32 bit Office) or Windows 64bit (for 64 bit Office)


You will execute the file and you will easily install with few next buttons.

At the first installation screen you will receive a message if you didn’t fulfill the requirements otherwise you will just click next.



At the second installation screen you will select the features to be installed.


At the end of the installation, if your installation has some issue, you will receive a message error and an inconsistent report that you can check by the installation screen clicking on Error Report.



== Installation Check

If you receive a message error you can check the installation log file by the installation check as described below:

  1. Press Start - Run
  2. Enter nwcheckworkstation
  3. Continue the appearing wizard
  4. Before clicking Finish make sure Checkbox "Collect diagnostic
  5. information for SAP Support" is checked
  6. Press Finish


On this file you have much information and to find the specific one you will check at the error folder. On the folder you will be able to see the below error:



== Settings

After the installation you have a specific setting that I would like to highlight. At the Admin guide you can see the setting “LoadBehavior” that you can define as 1,2 and 3.

  1. (value 1)The Add-In is enabled. This temporary activation means that the Add-In is disabled again when Microsoft Excel is closed.
  2. (value 2)The Add-In is disabled. Users can enable it in the COM Add-In dialog box. This sets the value to 3.
  3. (value 3)The Add-In is enabled. If required, users can disable it in the COM Add-In dialog box. This sets the value to 2.



== Common issues

We had received some incidents related with installation and the solution is simple. Sometimes we received some screenshots of “control panel/ install remove programs” with more than one version of Excel / Power Point and office packages. The same situation with the .net installation.

The Analysis for Office will work only with the Office package and not stand alone so the situation got solved removing all related installation and reinstalling from the entire Office package.

You cannot have a mixed office version installation.


== Silent Installation

For silent install you can proceed with the steps described at the KBA below:

  • 1929396 - Silent Install Analysis Office


If you have some suggestion about a specific topic, please describe on the comments that I will write a post about it.



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:

There are scenarios where there's a need to trigger a process chain from an Analysis for Office. For example, you might need to allow a user to click a button in your Analysis for Office workbook which triggers a disaggregation of gross margin in the background based on percentages that a user have just entered. To enable this functionality, simply follow these steps:


1. Create a InfoObject of type Characteristic. Name the characteristic ZPCCHAIN and configure it to be of type CHAR with length 25 (the maximum length of process chain technical IDs).




2. Create a real-time InfoCube named YCX_R01 that contains characteristic ZPCCHAIN and a key figure of your choice. The key figure is not really used to store any real values. We simply need it to be there in order to be able to build a MultiProvider on top of our cube (a MultiProvider needs at least one key figure). For this how-to blog, I've chosen to use 0AMOUNT. I've set the description of 0AMOUNT in my InfoCube to be "Dummy/unused Key Figure" to imply that it does not serve any function but to enable as to build a MultiProvider on top of it.


InfoCube YCX_R01.png



3. Create a MultiProvider named YCX_M01 on top of your InfoCube and map InfoObject ZPCCHAIN and your chosem key figure. Note that the MultiProvider is not mandatory (i.e. you can build an aggregation level directly on top of InfoCube YCX_C01) but I recommend creating one to follow best practice.





4. Create an aggregation level named YCX_A01 on top of MultiProvider YCX_M01 (or directly on top of InfoCube YCX_C01 if you've chosen to skip step #3). Ensure that you use InfoObject ZPCCHAIN and your chosen key figure to be part of your aggregation level.




5. Enable function model RSPC_API_CHAIN_START to be called in a FOX formula by creating an entry in table RSPLF_DIR.


Table RSPLF_FDIR.png


6.  Create a BeX query variable named ZCUP_PCCHAIN_001 with the following configuration:


Variable 1.png

Variable 2.png


7.  Create a BeX query filter named YCX_A01_FI001 with the following configuration:




8. Create a planning function named YCX_A01_PF01 of type FOX formula with following characteristics configuration and FOX code:


YCX_A01_PF001 1.png

YCX_A01_PF001 Formula.png


9.  Create a planning sequence named YCX_A01_PS001 that makes use of planning function YCX_A01_PF001 and filter YCX_A01_FI001.




10. In InfoCube YCX_C01, add an entry for the process chain that needs to be triggered. You do can this using transaction RSINPUT or through a data load. Ensure that your dummy key figure is non-zero.




11. In an Analysis for Excel workbook that already contains an input ready query, insert planning sequence YCX_A01_PS001 in the components tab. In this example, we will leave the alias to PS_1.


12. In your workbook, specify parameters for planning sequence YCX_A01_PS001. You need to either hardcode a value for variable ZCUP_PCCHAIN_001 or specify the value using a cell reference. Ensure that the value your specify as the parameter is contained in InfoCube YCX_R01 (see step 10)


13. Execute the planning sequence when a button is pressed by linking the button into a VBA subroutine with the following code. Note that if you change the name of your planning sequence to other than PS_1, you should use that name instead.


Dim lResult As Long

lResult= Application.Run("SAPExecutePlanningSequence","PS_1")


That't all to it! When you click the button, your planning sequence should now execute and the relevant process chain should be triggered.


Filter Blog

By author:
By date:
By tag: