BusinessObjects Analysis for Office 2.5 – a First Look

Analysis Office 2.5 is in Early Adopter Care, formerly known as “ramp-up”. You can review the What’s New guide in the SAP Help too.

SAP Analytics Cloud

You can now consume native SAP Analytics Cloud models using Analysis Office 2.5, and set up system connections

Here’s the SAP Analytics Cloud model “Best run demo”

After setting up the connection to SAP Analytics Cloud, I can search for the “Best run” model and report on it using Analysis Office 2.5:

Again, these are “native” models, meaning you cannot consume BW-based SAP Analytics Cloud models (but in that case, I would just use Analysis Office 2.5 against BW anyway).  This is a nice new feature for Analysis Office

Lumira Designer

One of the features that SAP promotes with 2.0 is “interoperability” between the tools.  You can export from Lumira Designer to Analysis Office

First you create a technical component in Lumira Desiger to “export AO”

Then create a button and corresponding script to export:

After exporting the application to Analysis Office, you can launch Analysis Office:

Technical Configuration

You can change settings now within Analysis Office instead of the XML file:

You can filter the settings

Scaling Factors in Conditional Formatting

After defining conditional formatting, you change the scaling on a measure and it should apply same as before:

Before scaling change – notice how item over budget is highlighted in red, no scaling:

After scaling change:

Item is still highlighted in red.

Recent List for Data Sources

There is a tooltip providing more information about recent list for data sources – technical name and system

If you want to find out more details, please register for the June 8th ASUG webcast What’s New in Analysis Office 2.5