Last week SAP BusinessObjects Analysis, edition for Microsoft Office 2.1 was generally available.  Some key links follow:

One key item to feature from the Product Availability Matrix is the add-on to the BI platform – you need to be in BI4.1 SP5 or higher:

/wp-content/uploads/2015/08/zpam_775934.jpg

Source: SAP

Also changed is what was previously called “free-form” calculation is now called “advanced calculation” – see below:

/wp-content/uploads/2015/08/freeformcalc_775935.jpg

From here you are taken to a formula editor:

/wp-content/uploads/2015/08/freeformcalc1_775936.jpg

You can access the Formula Editor from the Context Menu, the Display panel, or the Ribbon

/wp-content/uploads/2015/08/1display_775937.png

The above shows accessing the advanced calculation / formula editor from the Display Panel

/wp-content/uploads/2015/08/ribbon_775938.png

The above shows accessing the advanced calculation / formula editor from the Ribbon.

dynamic calc3.jpg

The % Contribution Balance column shows the result of a “dynamic” calculation for percentage share of budget.  The last column shows a ratio/result of the “advanced calculation” of actuals divided by budget.

There are many more features of the advanced calculation editor; it will be interesting to see more use.

/wp-content/uploads/2015/08/features_775941.jpg

What I also noticed is the context menu shows an entry for Live Office;

/wp-content/uploads/2015/08/liveoffice_775942.jpg

One issue I experienced during ramp-up was I kept getting launcher errors when trying to launch Analysis Office inside ECC.  This was quickly fixed by upgrading to the latest SAP Gui 7.40 patch.

Somewhat related to Analysis Office, I just watched the Wayne Eckerson visualization webcast and now I will also be paying more attention to how I put together Analysis Office workbooks.  Below are some examples:

time series chart.jpg

The above shows number of tickets over time; Mr. Eckerson’s webcast mentioned following the IBCS standards and in starting to read those I should be using a column chart showing time on the horizontal axis.  I also show data labels.

Reference:

SAP Help: http://help.sap.com/boao

Product Availability Matrix: https://support.sap.com/content/dam/library/ssp/infopages/pam-essentials/TIP/AO_PAM_Add_Info.pdf

What’s New: http://help.sap.com/businessobject/product_guides/AMS21/en/21_1_aaoffice_whatsnew_en.pdf

Subhash has an overview of the key features here Whats New In Analysis Office 2.1

I wrote about an early version from ramp-up SAP BusinessObjects Analysis Office 2.1 – a First Look

Coming up at SAP TechEd Las Vegas, there are hands-on sessions for Analysis Office.  ASUG has a webcast on October 8th to re-launch the ASUG Analysis Influence Council; this is easily one of the best benefits of ASUG.

I also hope you will consider joining ASUG at TechEd on October 19th for an all-day hands-on session for Design Studio – register here.

To report this post you need to login first.

17 Comments

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

  1. Bálint Almási

    Hi Tammy,

    do you have some information on what has been changed with regard to scheduling and publishing with the BI Platform AddOn of Analysis for Office 2.1?

    Thanks and regards,

    Balint

    (0) 
  2. Alfred Lee

    Hi Tammy,

    It seems to me that AO2.1 support for BW data source is better than HANA.

    Using HANA data source, I cannot find Dynamic Calculation.

    Percentage Difference and Percentage Share of Calculation are grayed out.

    And there are less available functions in Advanced Calculation.

    However, I didn’t see relevant information in the product guide.

    Do you have more information on this?

    Thanks,

    Alfred

    (0) 
      1. Alfred Lee

        Hi Tammy,

        Thanks for the reply.

        I tried to follow guide to add a restricted measure, but did not make it work.

        Guide says:

        1. Select a measure heading or a data cell in the crosstab.

        2. Choose Calculations -> Add Restriction… .

        However, with my HANA http connection, Add Restriction is grayed out when I selected a measure heading and Calculation in Ribbon is greyed out when I selected a data cell.

        Untitled.png

        Need your advice. Thank you.

        Best,

        Alfred

        (0) 
        1. Venkata Subhash Medisetty

          Hi Alfred Lee,

          from your screenshot you have selected only one measure, select two measures then you should be able to see you calculation options

          Capture.JPG

          as Tammy suggested, Create a new thread for any issues going forward

          Regards,

          Subhash

          (0) 
  3. Johannes Bacher

    Hello Tammy,

    i have installed AO 2.1 and want to use it to open workbooks from CPM (Commercial project management) which used to work with AO 1.4. Now i get the AO error “SNC_PARTNERNAME missing”. Have you seen this before ? thanks,

    Johannes

    (0) 
      1. iiro keitaanranta

        Tammy- I tried to apply the SP2 32 bit installation: AOFFICE21SP02_0-80000953.EXE

        but the installation aborts and nothing happens.

        the 64 bit installation works fine, but unfortunately we need the 32 bit installation.

        This is the first time for me when SAP releases a version to the marketplace, that is not even possible to install……

        I have even the previous one installed:

        AOFFICE21SP01_0-80000953.EXE

        and that one works fine without any issues, as has been the case with all the previous 20 versions I have installed.

        (0) 
        1. Tammy Powlas Post author

          Iiro – it needs to match your Office version; for example my Office version is 32 bit so I need to download the 32 bit software for Analysis Office.

          (0) 
          1. iiro keitaanranta

            Yes I understand completely that it has to match my office version.

            I have several laptops where I have tested this and in none of the laptops the 32 bit installation is working (where office is 32 bit version), but the 64 bit installation works with the office 64 bit laptops.

            (0) 
  4. RAKESH KHATAI

    Hi,

    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.

    Capture.JPG

    (0) 

Leave a Reply