Skip to Content

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.

To report this post you need to login first.


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

    1. Mark Cooper


      In case it is of interest – we found that SSO does not work when launching workbook directly from Launchpad (with or without Portal in front).

      Analysis Office  – OSS 1064576/2013 – Failed to Launch with specific file

      Known issue – resolutions:

      1894386 – Analysis Office launcher transactions do not work Found here

      Since this is probably not viable for us (upgrade to SP11 for BW7.3) down the bottom of the note it says there is an alternative note:

      1668882 – Note Assistant: Important notes for SAP_BASIS 730,731,740 found here

  1. Former Member

    Thank you Tammy, great post!

    I had implemented SAP BusinessObjects Analysis, Edition for Office 1.4 for Planning with IP BW 7.31. You was my inspiration ๐Ÿ˜€ .

    Thank you again,

    Diego Torres Luyo.

  2. Former Member

    Hi all,

    Is there any way to create a drill down report of analysis office from design studio using a button?like we drill down bex reports from xelsius. tried several ways, couldn’t succeed.pls help me out if anyone has implemented.

      1. Former Member

        Hi tammy,

        I was asking if there is any possibility with new features in analysis for we use document link of the file created in analysis for OLAP ,used in design studio component such as button, so as to reflect the filter values on publishing, where as the filtered values doesn’t reflect in analysis for office on following the same procedure.


Leave a Reply