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 

To report this post you need to login first.

9 Comments

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

  1. Tammy Powlas Post author

    Not in the 2.5 release.  You can review the official roadmap at https://support.sap.com/content/dam/website/roadmaps/en_us/analytics/SAP%20BusinessObjects%20Analysis,%20edition%20for%20Microsoft%20Office%20Road%20Map.pdf (S-user required)

    (0) 
  2. Alexander Pröm

    The official roadmap doesn’t mention LiveOffice integration at all. Also the roadmap for LiveOffice doesn’t say anything about it. Is this plan still active?

    (0) 
    1. Tammy Powlas Post author

      I don’t work for SAP – so you may want to ask this question at answers.sap.com – but in terms of the investment, the Analytics Roadmap should indicate which products SAP is investing in:  https://support.sap.com/content/dam/website/roadmaps/en_us/analytics/Road%20Map%20for%20Analytic%20Solutions%20from%20SAP.pdf

      (0) 
  3. Ramachandran SampathKumar

    How is the compatibility for SAP HANA and AFO 2.5. Are all functions from SAP HANA supported? Also is AFO 2.5 powered by HANAXS engine

    Do we have any document from SAP which will detail the compatibility difference AFO 1.4, 2.4 and 2.5 when connected to HANA

     

    (0) 
  4. Jay Gandhi

    Is there a particular setting to enable the “mass copy/paste” of new planning lines work?

     

    I’ve been playing around with this today and every time I copy values into the rows below the Analysis area (beyond the default 5) and refresh they’re blown away.

    (0) 
    1. Tammy Powlas Post author

      Hi Jay – I am not using planning, I’m sorry

      I recommend submitting this as a question at answers.sap.com so the community can assist

      Tammy

      (1) 
  5. Nathan Crawford

    Hi. I’m trying to add my own custom columns that have some “what-if” analysis type calculations.  I think any version past 2.2 will allow for the addition of custom calculations right?

    I just want to make sure I don’t over step the tools capabilities.

    Thanks for any input.

    Nate.

    (0) 

Leave a Reply