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.