Skip to Content
Author's profile photo Tammy Powlas

SAP BusinessObjects Analysis Office 2.1 – a First Look

SAP’s Alex Peter shared some new features in 2.1 here Visual Design in Analysis Office 2.1 (e.g. Hichert)

Note this product is in ramp-up.

Because Analysis shares a common installer with the EPM connector, you will see a new sheet type


The above sheet type is an “Analysis” sheet type on the shown on the Components tab of the Display panel.


What is really exciting too is a new free-form calculation now available.  It is a new formula editor to go beyond the quick calculations to define your own calculations.  Above the free-form calculation is available in the Context Menu


It is also available in the Ribbon as shown above


It is also available in the Display panel as shown above.


The above shows a simple example of how the Formula looks.


Although not specifically mentioned in the documentation, the Save View is now available in the Ribbon and not just the Context Menu.


Although not new in 2.1 I did notice you can do multi-selects in formatting; the above I select multiple dimensions and format them as Text and key


I also noticed the steps to format row height are more streamlined now.


Source: SAP

Above lists the new 2.1 features according to the SAP Help.

Separately, ASUG is relauncing the ASUG SAP Analysis Influence Council ReLaunch Webcast


Upcoming ASUG Business Intelligence Community W… | ASUG

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member


      I installed the AA 2.1 SP02. As per the user guide the the Worksheet Type option is no longer in Sheet Options but in the EPM Pane. But I do not see the Sheet Options in the EPM Pane.


      Author's profile photo Former Member
      Former Member

      Calculation on fly - it's amazing.

      Author's profile photo Former Member
      Former Member

      I am not able to see the Add calcuation when i right click on excel cell and my Analysis pane looks different, can you please help?



      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author

      Hi - you need to select the column you want to calculate on

      Author's profile photo Former Member
      Former Member

      Thanks but I couldn't use 2.1 because we have BPC 7.5 already and it might conflict with EPM pane.