I have a new laptop. That's the good news. It's a most up-to-date machine, using Windows 7 and Excel 2010 (64bit). As you all know the maintenance for SAP GUI 7.10 ends in April 2011. So I downloaded the latest SAP GUI 7.20 version for Windows 7 (64bit) and the BI AddOns for Software distribution center on Service marketplace. But my question and doubt was, is Office 2010 (64bit) supported for BEx? I searched OSS notes and found note 1425805. This states clearly Office 2010 (64bit) is not yet supported, only 32bit versions are. I searched for further notes to find out when Office 2010 (64bit) will be supported. As result to this search I found note 1442028. It states: "SAP plans to create a 64bit version of SAP GUI for Windows that will be compatible with Office 2010 64bit. However since the effort required to create such a version is very high the expectation is that this version might be available in 2013."

Well, it seems to me, that I have to stay without BEx for the next 2 years or that I have to install a 32bit version of Office 2010. My company is a front-runner! Hey, sounds good, but what do I do in the meantime! 2 years are a very long time... 

I know from the latest BI congresses that SAP BEx will emerge into SAP BO Analysis. SAP BO Analysis is positioned as Premium Alternative to BEx. I searched for OSS notes for supported Office versions for BO Analysis. I found note 1466118. This note states "Note that the 64 bit MS Office version requires a different installer for Analysis than what is used for the 32 bit MS Office version. This 64 bit Analysis version is only supported and available as of SBOP Analysis, edition for MS Office, release 1.1.". Well, next question: When will version 1.1 of Analysis be in Global Availability?

If you search PAM at service.sap.com you will find a statement for 1.0: Mainstream Maintenance End: 31.05.2011.

Hey, that is next month.  So I looked for active Ramp-ups. But unfortunately I couldn't find it, only BI 4.0 which is still in ramp-up. Thanks to Michael Devine, I found a note for the release plan of BO Analysis in note 1518359. You can also look in BO Analysis, support package overview.

Now I was interested in the release plans for SAP GUI 7.20 and BI Frontend- patches. Note 147519 will give you a release plan for SAP GUI 7.20 and note 1085218 a release plan for BI Add-ons for GUI 7.20. Note 147519 states " 7.20: Up to April 9th, 2013. On April 9th, 2013 the used development environment Microsoft Visual Studio 2008 will transit to Microsoft's "Extended Maintenance" mode. This means that Microsoft will not create any corrections for components which belong to this development environment anymore (unless the issue is security relevant).
Therefore no extension beyond this date is possible.". Well, it looks like I will get a brand-new  GUI 7.30 with support of Office 2010 (64bit) in 2013!


Ok, leave these hints and let's try to install. Maybe it will work in an unsupported mode. I installed the latest GUI 7.20 patches and the latest BI add-ons. Installation went fine, no hint or warning that I use a not supported Office 2010 version. So I started Excel 2010 and BEx appears under AddIns. All buttons are visible, but if you click on any, nothing happens. It seems that macros have not been loaded into memory and are not executed. 


What to do now?  For me as single user and developer by heart there two options:


  1. Wait for BO Analysis 1.1 for the next months, pay a license or rental fee and use it as preferred tool to display BW reports in Excel.
  2. I will install a Visual Studio 2010 Professional edition on my laptop and start developing a 64bit version of "BEx" using BICS API for access to my SAP BW system. By the way, I didn't find any API documentation for BICS. Did you?   

But what do you do as an end customer?

  • You have to stay on Office 2010 (32bit), SAP GUI 7.20 and Windows 7 until 2013 or later. You will get a new GUI 7.30 with support of Office 2010 (64bit) with all errors and problems a new release has.


  • The other option: If you have migration plans to Windows 7 and Office 2010 (64bit), get rid of BEx and use Analyzer 1.x on Office 2010 (64-bit) .

 What is your choice?


Since mid of June, 2010, Advanced Analytics, Microsoft Office Edition is in Ramp-up.

I installed it on my client PC with a German Excel 2007 version. I have also BEx 3.5 and BEx 7.0 installed on this machine. Installation was very easy and simple. Parallel installation of Advanced Analysis is no problem.

After installation you will find in your Start menu a new program group “SAP Business Objects”. In this program group you find 2 entries:

0.1. Advanced Analysis for Microsoft Excel

0.2. Advanced Analysis for Microsoft Powerpoint

For now let’s have a look on  Advanced Analysis for Microsoft Excel

If you start it, Microsoft Excel will be started and you will find a new menu entry “Advanced Analysis”. Additionally in the main menu of Excel you will find two new entries “Save Workbook” and “Open Workbook”. With these buttons you can save your workbook to your BO Enterprise Server and open it from there. Of course you can save your workbook on your local file system also. For that purpose use the Save button from Excel.

If you open  “Advanced Analysis” menu you will find new buttons in a ribbon bar.



If you have a blank excel sheet, only the buttons “Einfügen” (Insert), “Anzeigen” (Display), “Aktualisierung unterbrechen” (stop refresh), "Einstellungen" (Settings), “Formatvorlagen” (style sheets) and “Hilfe” (help) are active.


So you will start inserting a query or cube data into your sheet. You press the button “Einfügen” and you will be asked for login. First you will be asked to logon to your BO Enterprise server. There you enter your credentials plus a URL of Web Service. The URL should look like that: http://<your BO Server>:8080/dswsbobje/services/Session


You can  step over it, if you want to connect to your SAP BW system directly. For this purpose press button “Überspringen” (step over)

To connect to your BO Server and choose from existing datasources, e.g. queries or cubes, you have to define BW connections on the BO enterprise server. On my Enterprise server is now BW connection defined so I step over and connect to BW system.



Here you see the infoareas on your system and you can walk through to the query or cube that you want to use. After choosing and executing the query, you will se the results in a table like in the picture below.



On the right side you can see the navigation panel. Here you can slice and dice, filter, drill-drown, select, all what you need to analse your data. To drilldown you double click on the characteristics. To filter expand the characteristics and choose the value you want to keep as filter forexample.

A short function overview of the buttons:

"Alle aktualisieren" (refresh all) refreshes all queries embedded in this workbook. Drilldowns and filters are kept.

“Rückgängig” (Undo) undo the last actions. That’s comparable to step back to previous navigation step in BEx Analyserf. But: There is no button go back to start. That’s a big difference to Business Explorer Analyzer!

“Eingabeaufforderungen” (input values) change the variable values from your query.

“Filtern” (Filter) forces to suppress zeros in columns and / or rows.

“Sortieren” (sort) you first choose the characteristic and then sort the values ascending or descending.

“Hierarchie” (Hierarchy) expands your hierarchy to a defined level or expand hierarchy in rows or in columns.

“Berechnungen” (calculations) adds dynamic calculations, like accumulated sums, averages, Olympic ranks and others to your workbook.

“Achsen vertauschen” (swap axes) allows to swap axes

“Bedingte Formatierung” (conditioned formatting) allows to define exceptions as you know it from BEx Analyser. Now you can also display arrows or trend symbols, not just different colours. It's pretty the same function as from standard Excel functionality.  It’s no longer necessary to define exceptions in your query. You will define it in the frontend, in these workbooks only where you need it.

“Elementanziege” (element display) you define whether you weant to display key, text, key and text for the characteristics.

“Kennzahlenanzeige” (key figure display) you define display of key figures, like formats, scale factors or currency calculations.

“Ergebnisse”  (result lines) you can define position of the result lines and for which characteristics you want to display result lines at all. Result lines defiened in the query will be used as default.

“Diagramm “ (chart) allows to display the query as chart. You can choose from all standard excel chart types and embed them in your workbook.

“Info-Feld” (information field) allows you to add information fields, like query name, variables or date of last update.

“Filter” (filter) allows to add a filter line to your workbook for the characteristics in your query. So you can dynamically filter your data.

“Anzeigen” (display) forces to update the workbook with every change you made.

“”Aktualisierung unterbrechen” (stop refresh) stop refresh of query. You can make changes to your filters, drill-down, exceptions, data will not be updated. It will be updated if you switch to display

"Einstellungen" (Settings) allows to define user-settings and support settings. In user settings you define how many history entries will be kept. In support settings you define the trace level and folder for log files.

“Formatvorlagen” (style sheets) allows you to save, import, export style sheets. E.g. you can display the data in your company colours if you define an appropriate style sheet and import it to Advanced Analysis.

“Hilfe” (help) gives you help documentation, version information but also statistics information about the runtime of your query. A very cool feature! The run time information looks like that:




Filter Blog

By author: By date:
By tag: