Skip to Content
Author's profile photo Alexander Peter

Announcing general availability of Analysis Office 2.2

Analysis Office 2.2 has just been generally available since Nov 23, 2015.

It is the latest and best release of Analysis Office, combining the power of the classic Analysis functionality and the EPM features. Here’s some short overview on the new features:

As SAP is generally recommending the Analysis plug-in on top of BPC embedded model (EPM plug-in also works on top of it, but there are no major enhancement planned), release 2.2 introduces the work status integration into Analysis plug-in. You can set the locks within the frontend according to the definition in web admin client.

One of the most innovative features is the possibility to use Excel formulas in new lines that have been created with the Table Design feature of Analysis plug-in. The Excel references are internally transformed into the semantic relations (i.e. members, measures etc.) and transformed back again into Excel formulas after any navigation. With this you can easily build highly interactive reports using custom Excel formulas.

Analysis Office 2.2 also adds new features on top of native HANA, like consuming attribute views and using top n/bottom n calculations.

In addition, the Analysis plug-in provides several smaller enhancements like searching for attributes in the member selector, restricted search for data sources, new callback (BeforeFirstPromptsDisplay) and many more. Please find detailed information in the online help.

Important note: Analysis Office 2.2 requires Microsoft Office 2010 or Office 2013 (and will soon support Office 2016). If you are still using Office 2007, you need to stay on Analysis Office 1.4 or EPM Add-In 10.0, respectively. Note that Analysis Office 1.4 will end in Q2 2016.

Assigned Tags

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

      Hey Alex,

      Thank you for this information. It would be nice if the added features you describe would be also in the What's new guide.

      Author's profile photo Former Member
      Former Member

      Hi Alexander,

      reading this posting: ... and the comment of Tammy, it looks like your praise is a little bit overstated?

      Do you mind of providing the list, I asked for in the same posting?

      I think many of the users here are getting annoyed of the current situation that you cannot rely on that upcoming versions are regression tested, and functionality which worked before is not working anymore...

      Another example:

      What is the strategy behind this? Are you in a state now where you lost the overview?

      Thanks for reading, Martin