Skip to Content

Just last week, some of us ASUG volunteers received an e-mail from our great SAP Point of Contact to ASUG, Ingo Hilgefort.  He suggested contacting our  account executive regarding some questions we had about software.  I did just as Ingo said, and that afternoon I was contacted by SAP BusinessObjects in Vancouver.  This person  called me and said, “by the way, did you know your company owns licenses to Advanced Analysis for Office?”  Really, no, I did not.

The next day I was downloading the software from Service Marketplace (  

I followed Chapter 2 of the steps in Ingo Hilgefort’s “Inside SAP BusinessObjects Advanced Analysis” book to install the software.  This is a great book that goes into details of how to set up Advanced Analysis.  

In no time at all, I was up and running on Advanced Analysis.  Being an ASUG volunteer and SAP Mentor Initiative, I had the wonderful opportunity to assist the Ingo for his excellent hands-on sessions at SAP TechED.   First up was an all-day session on Monday, October 18th, on BusinessObjects tools in a day. 


While assisting Ingo during his hands-on sessions at TechEd, attendees had questions  on Crystal (design/preview/formula), WebIntelligence (building the Universe), and XCelsius (binding back to the queries).  However, when they got to the  Advanced Analysis for Office hands-on exercises, there were no questions.    That is how easy this tool is.


He also asked “who in the room here is happy with BEx Analyzer?”  I remember only one person raising their hand.

What business problem(s) does Analysis for Office solve?  Some background:

  • SAP BusinessObjects Advanced Analysis was previously known as Pioneer.  There are 2 “flavors” of Advanced Analysis: Office and Web.  The Web version, as I  understand it, is the successor to Voyager.
  • The Office Edition is positioned as the premium alternative to BEx Analyzer.  Additionally, the Office Edition allows you to query data in MS PowerPoint.   Advanced Analysis is not a standalone product but is part of the BI portfolio.  

The tool has an Advanced Analysis Ribbon in Excel:


The Analysis Design Panel looks a great deal like the Excel Pivot table:

Analysis Design Panel

What business problem(s) will Advanced Analysis solve?  As Ingo describes in his book, it puts the power of analysis not only to the Power User (which BEx Analyzer did) but also to the Business User.  It provides full functionality to hierarchical reporting – often used in SAP Funds Management and SAP Cost Center Accounting solutions.  

Do you want more information?  I encourage you to consider buying Ingo’s great book on Inside Advanced Analysis for Office, and also check out my SCN e-learning.  This recording will walk you through the steps of how a BEx Query is a data source to BusinessObjects Advanced Analysis for Office.



To report this post you need to login first.


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

  1. Witalij Rudnicki
    Hi Tammy. Thanks for sharing! But I cannot find Advanced Analysis when I log to SWDC with my company’s credentials. Do you know what is the current rule which companies have access to it?
    1. Tammy Powlas Post author
      Great question, Vitaliy.  I think it depends on your company’s license agreement with SAP.  I found out quite accidentally.  Maybe this is something to ask your SAP account manager?

      Thank you for taking the time to read my blog 🙂

    2. Gregory Misiorek
      not me, either 😉 and i had so many phone calls from the marketing department. seems like you need a separate license for SBOP ANALYSIS MSOFFICE. kind of hard to evangalize without a demo, so will stick to BEx for the time being.
  2. Former Member
    Hi – Was also at TechED (berlin) and had hands with Analysis (Formerly Advanced Analysis).  however I was somewhat underwhlemed.  Can someone tell me what additional functionality is included in this release compared with Bex Analyzer except for the ability to publish content in Powerpoint/Word? 

    The lack of additional fucntionality is presumably why they dropped that “Advanced” from the name?


    1. Tammy Powlas Post author
      Hi Richard,
      Thank you for taking the time to read and respond.

      The differences between BEx and Analysis Office are discussed in Chapter 6 of Ingo Hilgefort’s book.

      My key takeaway was ease of use – no longer did you need to be a Power User to navigate BW data in Excel, but the Casual User could also use this tool, with the familiar Excel front end. 

      Regarding name change, SAP has discussed this but I also refer you to Jon Reed’s article on the topic at

      It explains why the “Advanced” name was dropped for future releases.


  3. Former Member
    I recently got at hold of Excel 2010 and also BO Advanced Analysis. It strikes me that if I use ODBO access in Excel pivottables then I’m able to do pretty much all the advanced analysis tasks directly on a BW cube/query natively from Excel without using BO Advanced Analysis. Has anyone made a functionality comparison between Excel 2010 Pivottables and BO Advanced Analysis?
    1. Witalij Rudnicki
      That’s a great question, Jacob. Without looking into BO Analysis I would expect that it can work with BW unique structure – hierarchies, and that PivotTable would not. I would expect as well that BEx query exceptions (or whatever it is called in Pioneer now) are not displayed in MS Excel. But indeed thoughtful comparison between two would be great topic.
    2. Tammy Powlas Post author
      Hi Jacob,
      I don’t have access to Excel 2010 (but I may soon) – would you consider posting in the forums so the product managers may respond?  Many thanks for your reply.

Leave a Reply