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.

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.

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.

Yesterday ASUG had a webcast where SAP's Alex Peter and ASUG volunteer Joyce Butler reported the results of the ASUG Analysis Influence Council.


Alex said the ASUG Analysis Influence Council was very helpful.  Please note that anything for the future is subject to change and the usual legal disclaimer applies.


The current council has 12 companies covering different companies and industries.


Figure 1: Source: ASUG Analysis Influence Council


Figure 1 shows the purpose of ASUG Influence Councils.


This webcast covered where ASUG members influenced SAP:and future roadmap.


BW Workspace

BW Workspaces, which is the technical name for mashing up local data with BW data.  You can add your own classification of items that are not already in the BW model.


BEx Workbooks

Another area where the ASUG Influence Council influenced SAP was conversion of BEx Workbooks.   At first SAP only focused on BEx 7.0 workbook conversion but the influence council clearly indicated that BEx 3.5 workbooks are needed.  Adding additional pressure was BEx 3.5 recently went out of maintenance; hence the need of offering a BEx 3.5 workbook conversion to Analysis Office



Variants was a gap with BEx Analyzer and the council asked for variants to be done as soon as possible.


Figure 2: Source: SAP


Figure 2 shows a new prompt dialog for Analysis OLAP, you can save the prompt values and create public and private variants.  You can also merge and unmerge variables.


Figure 3: Source: SAP


Figure 3 feature is only available for MSAS allowing for custom groupings, resulting from a discussion from this ASUG Influence Council.


This is not for BW yet.


Figure 4: Source: SAP


Create Analysis application from Analysis OLAP client you can take over the current datasources and directly post in Design Studio application.

Then you can change with Design Studio and change the interactivity features to filter items.


BEx Query Designer

If you are on a datasource and access Query Designer and redeploy to workbook was highly prioritized by the Influence Council


Figure 5: Source: SAP


Figure 5 shows that scheduling Analysis Office is available on the BI Platform.  SAP decided to do it on the BI Platform as it offers more than the BEx Broadcaster


There are a few things to catch up such as query prompt support; if a query has a prompt that is not supported. You can filter by exit or authorization variables.

Figure 5 covers the requirements.


Figure 6: Source: SAP


Figure 6 shows the left column today


The next release will be called “2.0” and will be a big effort


Beta will be Q2 and RTC will be end of year.


The big effort is rebuilding the platform of add-in because SAP plans to let SAP run add-ins side by side such as EPM.  Today the add-ins do not work side-by side


SAP wants to have them run side by side and clear vision for one single BI related add-in at SAP.


Analysis Office/EPM are planned to be brought together and SAP wants a smooth transition.


Configuration of workbooks is when you have several plug-ins available you would like to have a custom ribbons/context menu and combine in one single ribbon


Table formatting means you can only handle table as big block; can’t add empty lines or rows in a specific format.   The idea is to add some specific style elements in the table that continues to exist after refresh or navigation.  This also includes Excel-based formulas and expect it to “survive” any navigation. Analysis Office has to translate it into semantics to get this to work.


Complex scenarios include conditional formatting.  Hichert has some rules (planned values in light grey and actual in black and use color for positive trends) for cross tabs and charts and this could be used.


First release will start with simple inserting formatting of rows.


For BW, SAP is extending the unified BPC planning which is the evolution of BW-IP


On the BW side they are introducing the multi-select if you would like to change some specific settings, you can do that only one by one today.


In 2.0 (planned innovations) they will introduce storing workbooks in HANA.


Future directions include comments stored and work on PowerPoint .and scheduling.


Lumira integration:  the idea is to have visualizations from Lumira in Excel or PowerPoint and integrate vice-versa.  Native HANA means Analysis Office talks directly to HANA platform instead of today’s ODBC connection.


Figure 7: Source: SAP


In the future includes improved currency conversion support.


Planned innovations includes source related.


It has good interoperability with Design Studio and Analysis OLAP will stay as a good Analysis adhoc OLAP client.




Analysis Office will have sessions at BI 2014

Jump Start ASUG Annual Conference SAPPHIRE with a Pre-Conference Session - Back and Better than Ever includes hands-on Analysis Office with BW on HANA

On an ASUG webcast today SAP reviewed scenarios covered by BEx, and now covered by other products.


BEx development has been ramped down.


If look at BEx scenarios, recommend invest in two product areas to replace BEx: one is Analysis Office and OLAP and Design Studio.


Please note that future items are subject to change and any forward looking statements are subject to the disclaimer (no commitment).



Figure 1: Source: SAP


BEx came with the idea of IT providing workbooks and analytics, and not so much self-service or agile visualization.


Suggested customer recommendations for SAP BW customers is to lead with Analysis.  For others, look at Lumira and BusinessObjects Explorer


Figure 2: Source: SAP


As Figure 2 shows, Web Intelligence has some limitations for BW as it was built for relational data sources and not BW. It does not rely on underlying OLAP engine but the Web Intelligence microcube.  Do not expect more improvements for Web Intelligence on BW.


Customer recommendations:

  • SAP BW customers: Depends on use case, but Analysis Office is optimized for BW.
  • BusinessObjects customers or those with any data source: Use Web Intelligence
  • Reporting / OEM - use Crystal Reports


Figure 3: Source: SAP


Analysis OLAP and Design Studio – looking for functionality from A-OLAP into Design Studio



Figure 4: Source: SAP


BEx analyzer and the suite of SAP BEx tools are in maintenance mode


They will still be delivered with the next releases of SAP NetWeaver BW


They follow the same life cycle and release strategy as BW - for example, BEx analyzer is shipped with BW 7.3 will be supported for the next 7+2 years


BEx queries are consumed directly by BI4 front-ends


BEx Query Designer remains in place to create and maintain BEx queries (common question)


Analysis, edition for MS Office is the alternative to BEx analyzer with enhanced premium functionality


For customer-specific maintenance of Bex 3.5: See Note 1767068



Figure 5: Source: SAP


Figure 5 shows what is supported today including full support of BEx queries.  Also see what is planned in the future (subject to change)



Figure 6: Source: SAP


SAP wants Analysis Office to be more usable and be close to Excel and they wanted to focus on business user (see Figure 6).


Figure 7: Source: SAP


Figure 7 shows the Design Panel usability – like pivot tables


Figure 8: Source: SAP


Only local comments now; planning more global in the future


Figure 9: Source: SAP


Scheduling (which requires the BI platform) was recently released.



Subset of Question & Answer

We had 57 questions in total, and I will try to include most of them in the upcoming blogs.

Q:  Will Analysis have scheduling ability in the future

A:  We have added it to Analysis Office recently - and it is planned for Design Studio in a future release.

A:  Analysis Office has scheduling capability now with a service pack that was released a few weeks ago - 1.4


Q:  when does SAP support end on BW querries(Bex) 3.5 & 7.0 ?

A:  See for BEx maintenance - note that BEx 3.5 is no longer shipped with the SAP Gui any more 

A:  Eric will talk briefly about it. Bex 3.5 extended support has ended in Q2 2013, BE 7 will definitely be supported as long as BW 7.x, i.e. at least until 2020



Q:  We still need to use BEx queries to act as a semantic  layer with Web Intelligence and Crystal Reports, correct?

A:  Yes, the BEx query is the semantic layer for Web Intelligence and Crystal.


Q:  Does that include support for 3rd party OLAP?

A:  Analysis OLAP supports 3rd party OLAP sources such as SSAS, ORACLE OLAP, Essbase, Teradata ..


Q:  What SAP product will have the ability to let users enter data into a BW cube similar to capability that currently exists with BEx Planning?

A:  Analysis Office already supports BW-IP/PAK as of today, Design Studio plans to support it with the next release in Q2 2014


Q:  For the new recommended options, is Business Objects or HANA required?  What version of BW is recommended for these?

A:  BW or HANA can be used as data sources - please check the PAM for versions -

A:  Analysis Office and Design Studio can be deployed on BusinessObjects BI platform - but can also be deployed without it




Q:  Can you tell us what SAP Gui release the 3.5 tools are no longer shipped? 7.3?

A:  BEx 3.5 query / analyzer is not shipped with SAP Gui 730




Q:  What is the future of BEx Query Designer?

A:  Will stay the main tool for defining semantic models on BW




Q:  If we want to switch Bex to any BO Tools, Is there aternative solutions on using Bookmarks, RRI(report to report Interfact) and BAPI's in new BO tools ?

A:  Analysis Office/OLAP support RRI (sender only)


Q:  Does input ready queries work with Analysis for office?

A:  yes




Q:  Can you provide a link from where to download the Analysis client that comes with Scheduding features?

A:  Go to and under "A" Analysis Office - BI platform add-on




Q:  SAP PBF uses BEx queries for input in forms. Can we continue using BEx for new forms that we build or should we choose between analysis office and design studio?

A:  not sure if I got the question, but Analysis Office already supports planning (i.e. input-ready queries) and Design Studio plans to do it in Q2 2014




Q:  What is the expected release for use of current BEX reports with 64-bit Excel?

A:  Analysis Office already works in a 64-bit environment




Q:  Does the 7+2 years start in 2013? What does the +2 mean?

A:  7 years standard maintenance and 2 years extended maintenance


Q:  What is the semantic layer strategy for BW? As of today we rely on BEX as reporting interface for BOBJ tools.

A:  query designer stays strategic modeling environment on BW



Q:  Is that 7 years beginning in 2013, so until 2020 for maintenance?

A:  Please check SAP's maintenance side. Statement is that NetWeaver 7.x is supported until 2020 at least.


Q:  Can we use the Analysis Office on top of BW with stand alone ( wit out Bw) and how? we are BW 7.0

A:  You can use Analysis Office with BW without the BI Platform (does that answer your question)? It will work with BW 7.0




Q:  Is Analysis Office available to all current BEx users at no additional cost?

A:  There is a separate license connected to Analysis and Design Studio




Q:  with out BO

A:  Yes, Analysis Office works without BI platform (but then no scheduling)


Q:  Plans to add missing BEx Analyzer functionality to Analysis for Office (Excel)?


- Re-ordering of Structure elements (rows/columns) at the workbook level

- Tools – Copy Sheet

- Drill Across Sheets

- Display Scaling Factors correctly

A:  lots of plans ... please use Idea Place for voting for missing or new feature requests




Q:  Which BO tools support RRI(report to report interface) both Sender and receiver ?

A:  Design Studio does not support yet. It's planned for next releases. AOLAP and AOffice support RSBBS. For other tools in BI Clients please refer to Ingo Hilgefort's blog and book. He has a very detailed information in his blog.




Q:  I see that there is a separate license connected to Analysis and Design Studio. Is this part of the BusonessObjects licencing agreement or are they stand-alone licences (similar to Lumira)?

A:  This one you may want to ask SAP Account exec; SAP offers a suite license and a-la-carte




Q:  Analysis Office is part of BO lincence or standalone product like lumira? to use on top of BW 7.0?

A:  See previous answer to contact your SAP Account Executive - SAP has difference license offerings and some are a la carte


Part of the sharing the knowledge at SAP TechEd, we learned that the one a new feature coming soon to Analysis Office is scheduling.  Scheduling Analysis Office workbooks will come via the BI Platform, and will be available as an add-on to the BI Platform.  The planned release date is sometime in November.  SAP's Alexander Peter demonstrated this feature at the ASUG Analysis Influence Council this week. 


Analysis OLAP

Also reviewed as BI4.1 features already available in Analysis OLAP.  BI4.1 offers custom grouping features against certain data sources, except BW. 


Other features reviewed include Focused Analysis, allowing you to link a table to a chart.


Analysis OLAP offers "Pivot with" – filter with


It has Report to Report Interface as a  valid sender


Also new in BI4.1 is the ability to resize panels, waterfall charts with hierarchies


An interesting exercise is the abilit to go from Analysis OLAP to Design Studio with a single click.  You skip step of starting Design Studio


Some Question & Answer regarding Analysis OLAP


Q: Is planning supported?

A: No; Analysis Office supports planning but has no custom grouping, no focus panel


Q: Does A-OLAP have a scheduling capability?

A: Not yet; not sure if will develop; may do in Design Studio


Special thanks to Joyce Butler, Ian McAlpine, and Alexander Peter for running this session and sharing the news with us.  ASUG Influence Council sessions are not to be missed at events, as this is where you learn what is coming with the products.

Over two and half years ago the ASUG Analysis Influence Council kicked off with Alexander Peter, Ian McAlpine and Joyce Butler


What are ASUG Influence Councils? 


"Influence Councils are interactive forums where members can communicate ideas and concerns about product plans and SAP services directly to SAP development and product managers."

Source: ASUG


The council continues today and continues to provide feedback to SAP on the products.  This blog covers where ASUG influenced the latest BusinessObjects Analysis, edition for Office 1.4 release.



The council first ranked and prioritized features.  At the top of the list was "Capability to Create/Edit Bex Query within Analysis Office.  From Bex analyzer you don't have to leave the tool to add a field.  With Office you have to leave the tool, go to query designer, add the field and then get back into Office. "



This is now available in the current 1.4 release.  See the steps below:


Under Settings, select Advanced Settings, and select the checkbox Show "Call Query Designer"...




The Query Designer button/ribbon is then shown:



Select the Launch Query Designer and the Query Designer is then launched.



You can make changes to your query and then return to your Analysis Office application.  In my example above I've added WBS to the rows of the Query.


Then when returning to Analysis Office cross tab you reset the data source and the cross tab is then updated.


For questions or more information feel free to e-mail ASUG influence at


Consider joining the team and meet face to face at SAP TechEd Las Vegas.


ASUG also has a pre-conference SAP TechEd session that includes Analysis Office in the BI4.1 on October 21st:

ALL DAY | HANDS-ON: SAP BusinessObjects BI 4.1 with SAP BW and SAP ERP – Everything You Need in One Day




Related Links:

See how ASUG Members Influence SAP – Featuring BusinessObjects Analysis Influence Council

ASUG Annual Conference - ASUG Influence and BEx Quo Vadis

Can ASUG Members influence SAP? ASUG Influence Council Success Story, SAP Best Practices for Business Warehouse with BusinessObjects

Interested in Influencing SAP?  Join ASUG for the SAP BusinessObjects Analysis Influence Council Kick-off Webcast

We're listening! Please give product feedback by Ina Felsheim


For more information about Influence Councils see Karin Tillotson's Why I believe in the power of ASUG Influence Councils Part 1 and Why I believe in the power of ASUG Influence Councils Part 2 - The ASUG UI Influence Council


For more information about ASUG see Ingo Hilgefort's Whats the value of a ASUG membership for you as customer ?

Part 1 covered installation and some features.  Part 2 discussed more features including Waterfall Charts, Read Access Mode, and Reset Data Source.


Launch BEx Query Designer

First I want to cover some troubleshooting.  Some comments in the discussion forum indicate that individuals are unable to launch the BEx query designer - it is greyed out.  Note you must be on a later SP for the BEx Query Designer.  Check your version by going to Help > About in the BEx Query Designer:




If you are not on this version then go to Service Marketplace and download the BI Add on:




Then you should be able to click this option in the User Settings.


Adjusting the Member Selector

You can limit the number of members in the "member selector" by going to User > Settings:


You can change the Maximum Number of Entries in Recent List - the default is 1000.  This may help improve performance when working with large amounts of data.


Filter Hierarchy in Display Panel


In the display panel, you have the option to filter based on hierarchy only - if you select this, your hierarchy turns into a flat presentation.



When it is clicked on, the hierarchy in the cross tab is turned into a "flat presentation"






But then you can filter by the hierarchy or the leaves of the hierarchy:




Hands On Experience

Next week at BI 2013 in Amsterdam, SAP Mentor Ingo Hilgefort will be providing hands-on sessions for the Analysis Suite, including Analysis Office.  I attended this myself at BI2013 in Las Vegas in March and these sessions were quite popular with great feedback.  I recommend attending these sessions if you are attending.

In my blog last Friday, I discussed installation steps and briefly just some of the new features.  In this blog, I will review some of the other new features that came with this release, which was GA last Friday.


We have seen many questions regarding Analysis Office 1.4 - please review the Product Availability Matrix. Analysis Office 1.4 32 bit and 64 bit supports MS Office 2013.


Waterfall Charts

In the past, Analysis Office supported charts in Excel.  Now it is offering two types of Waterfall Charts:



The first type of Waterfall Chart shows up as follows:



Here is an example of a pivoted Waterfall Chart:



Reset Data Source

In the previous blog, you saw you can launch the BEx Query Designer.


If you make some changes to the crosstab using the Display Panel, you can use Reset Data Source to set the query back to the initial state of the BEx query.


This is a right-click from the context menu, and select Reset Data Source



Selecting Reset Data Source will reset it back to the initial navigation state of the BEx Query.


Note you can also make this setting to reset on opening from the Display panel:



Read Access Mode


Select a characteristic ("aka Member") and select Members > Access Mode




You can select only those values with posted data as shown above.


If you show values in Master Data you will see everything, even those without any transactions posted against them.


Note in the User Settings the "Allow Access Mode to be Changed" option must be turned on:




More to come.

Last month SAP covered what is new with Analysis Office here.  Today is it generally available, according to the PAM.   This morning I was able to install it on my machine.


The install file is only 79.2 MB and installation is fairly easy.



When you get to this screen you need to click the Enable 1.4 Features checkbox.




Once you install you see the success.


Go to the Settings Tab to enable some new features:



I can enable the launch query designer button and Create Web Application (launch Design Studio)


Note to BEx launch query designer you need to install the latest SAP Gui patch for 730; otherwise it is greyed out.




After clicking "Launch Query Designer" you can then launch the BEx Query Designer:



More to come in future  - read access mode, reset data source, etc.  Watch the BusinessObjects Analysis Office space.

We had an ASUG Analysis Influence Council at ASUG Annual Conference where attendees learned how the ASUG Analysis Influence Council influenced SAP:


Features influenced by the ASUG Analysis Influence Council

Analysis Office

1) Converting BEx 3.5 workbooks

2) Variants

3) Launch BEx Query Designer (coming in 1.4 release)



Picture of SAP's Alexander Peter by Joyce Butler


Analysis OLAP - features where ASUG Analysis Influence Council provided input

1) new prompt dialog

2) custom grouping

3) mobility for Analysis OLAP



We also learned that the broadcasting feature will come to Analysis Office through a BI4.1 feature pack later this year.  The planned release for Analysis Office 1.4 is early June.


Ian McAlpine said that the ASUG Analysis Influence Council "feedback is highly prized and valued to SAP."


BEx Quo Vadis Community Lounge

Right after this session there was an ASUG Community Lounge session titled "BEx Quo Vadis" or "BEx where are you going".  We had a similar community lounge at last year's conference but no one showed up.  I was quite skeptical about doing it again, but Lee Lewis insisted and fortunately Joyce Butler and SAP's Eric Schemer agreed to do it.



We had a great turnout this year, and special thanks goes to Lee, Joyce and Amy Finke of ASUG Headquarters.  Amy redesigned the lounge areas, which were called "theatres", which was a huge improvement.


Photo by Danny Pancratz


Oftentimes people hear that "BEx is going away" - this is not the case for the BEx Query Designer.


An attendee asked "what are the gaps between Analysis Office and BEx Workbooks?"  Alex said he felt document integration and broadcasting were still two missing features.


SAP also said that "BEx query designer remains core modeling tool for BW".  "We are not replacing BEx Query Designer" says SAP in BEx Quo Vadis session. 


Here is a link to a vine video where Alex discusses Analysis Office.  Also Jie Deng answered questions about placing Design Studio applications on the Enterprise Portal (minimum version required is 7.3) - here is the link to the vine video.


Thanks to all who attended and thanks to SAP's Alex Peter, Jie Deng and Ian McAlpine for their support of ASUG.

Alexander Peter, Product Owner for Analysis Office, provided this webcast to ASUG yesterday.


Since the discussion covers future versions, this is subject to change.




Figure 1: Source: SAP


Figure 1 shows that BEx tools are in maintenance mode.  There is not an immediate need to go off BEx clients but no new innovation.

Innovation comes with the Analysis clients.


Content with BEx Analyzer – conversion support exists today in Analysis Office.



Figure 2: Source: SAP


Analysis 1.4 release is smaller than 1.3 as SAP focused on improving performance.  SAP launched a performance project to review performance challenges from end to end. 


Alex said there are two collective notes to help you identify things on backend to streamline communication between server and client.


Main feature was broadcasting on BI Platform, another gap for BEx Analyzer– for legal reasons can’t release GA .  SAP chose the BI platform to use the scheduling features.  Broadcasting is planned for Q3.


GA for 1.4 is planned for May.


SAP has enchanced interoperability with Design Studio – in 1.3 you could copy a data source and insert it in Design Studio.  Now it is extended to be an automatic transformation to Design Studio – crosstab, chart, and components into an iPad application.  The scenario is to have a prototyping tool in Analysis Office and can use it to prototype a dashboard.


Strengthen BI platform support – if you store it in Launchpad ad start it from the Launchpad – before only Excel opens.  It didn’t know about Analysis Office workbook.  SSO wasn’t honored.  Now solved in with Analysis Office 1.4 and BI4.1 platform


Waterfall charts not available in native Excel so they have added them to the toolbar in Analysis Office 1.4.


With the ASUG Influence Council, SAP prioritized features.  After broadcasting query designer was a the top. 


You can open the Query Designer from Analysis Office 1.4 .  You can reset data source to query designer


With the read mode feature you can change from reading from the cube or the master data.


Time-dependent hierarchy at the given key date is now available in 1.4.


Data refresh – before 1.4, when press refresh, render cross tabs but not show the latest data – re-rendered data – had to leave Excel and open it again.  With 1.4 have a real data refresh.


They have added a member selector for mass data




Figure 3: Source: SAP


Figure 3 was not covered during the webcast, but it gives you an overall direction.  Today is version 1.3, planned innovation is Analysis Office 1.4.



Subset of Q&A:


Q: Will AA 1.4 allow us to create or design Queries in BW?

A: The Query Designer remains the tool to create queries in BW.‑


Q: Will AA 1.4 finally have LogOn / LogOff button?

A: No plan for a logoff button... but I am aware that AA can hold onto connections for an extended period so this issue is being investigated.‑


Q: is it possible to connect to Essbase cubes directly?

A: Not from Analysis Office‑

A: ... but Yes with Analysis OLAP‑

Q: is AA 1.4 compatible with BOBJ 4 SP5?

A: It is platform independent‑



Q: What is the comparability of AA 1.4? We are on BI 7.0 and BOBJ XI3.1 sp 3.

A: It is platform independent - there are some features dependent on BW version but overall it is platform independent.‑




ASUG Annual Conference

Alex is presenting at ASUG Annual Conference regarding the ASUG Influence Council.  Below is a list of other ASUG Analysis-related sessions for the conference:


Session IDTitle
301Deep-dive into Analysis for OLAP, the next generation tool for web-based multidimensional analysis.
305What’s new with Analysis Office & OLAP?
308Customize the Look and Feel of BW Reports in SAP BusinessObjects Analysis (Office) by Using API Calls
4210Influence SAP - ASUG SAP BusinessObjects Analysis Office/OLAP Influence Council
      CL32BEx Quo Vadis - "Where is BEx Going"
312Moving Beyond BEx: Strategies for Unlocking the Value in Your BW Data with BI 4


Filter Blog

By author: By date:
By tag: