Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
Showing results for 
Search instead for 
Did you mean: 
Active Contributor
0 Kudos
Today I finished Analysis Office - the Comprehensive Guide 3rd Edition by Tobias Meyer .  It is an incredible book, 272 pages, with so many tips and steps of great information, I don't know where to start.

Source: Analysis Office - The Comprehensive Guide 3rd edition


It covers up to release 2.6, the latest release.  The book covers authorizations, different launch options (something I did not know), and covers connections to BW/4HANA.

Some tips covered in the book:

Right-click on the on Components tab of the Design panel shows a context menu:

Source: Tobias Meyer

A tip I learned in the book is that not all functions on the Design/Display panel are available when Pause Refresh is active (and Pause Refresh is one of the best features - single trip to the server for multiple navigations)


Source: Analysis Office - The Comprehensive Guide 3rd edition


The above is a nice feature I didn't know for totals; you can show the median, standard deviation, etc.

So I tried the totals feature "median" and it displays the median on the totals (middle value)

Source: Analysis Office - The Comprehensive Guide 3rd edition


Above was a tip I didn't know.  So of course I had to try it myself:

I hadn't heard of "FI/CO" view; above shows "consulting view".


Source: Analysis Office - The Comprehensive Guide 3rd edition

Another pause refresh tip

Another interesting tidbit:
Charts "When you insert a chart be aware that the whole Crosstab will be displayed in the chart" Source: Analysis Office - The Comprehensive Guide 3rd edition

Breaking hierarchies - a feature I hadn't paid attention to before.
In the default setting, data is sorted in the hierarchy levels of the crosstab. Parent members are sorted in order, and child members are sorted below each parent member in their own order. If you want to sort data across the entire hierarchy, select the Break Hierarchies option.  (Source: SAP)

Before break hierarchies (using the SAP NetWeaver Demo model):

After break hierarchies setting:


The book goes into to depth on the parameter settings, such as "DoSelectorHierarchyExplicitSelection" - default is off, but for certain use cases you may want it defaulted on.


VBA/API - since the new iteration of the SAP Community, we don't see many questions on this, and this is not my area of expertise, but I could follow the book and try some of the book examples as shown below:

Executing the macro:


So take it from me, if you are new to Analysis Office or experienced, you will learn something from this book.

I highly recommend this book.  It is available on Amazon (Germany), or you can buy it directly here.  I bought mine using PayPal, a convenient payment option.  Check out the table of contents here.


Upcoming Analysis Office Webcasts

For those who attend the above webcasts LIVE, you will be eligible for a random drawing to win the book.

The webcast below will offer a drawing for the book as well:

May 16 Deep Dive Preview of ASUG BI/Analytics/BusinessObjects Sessions at ASUG Annual Conference


If you are attending ASUG Annual Conference, consider adding the session below to your agenda:

Labels in this area