Skip to Content
avatar image
Former Member

Analysis for Office BW connection error

Hello,

We try to use Analysis for Office 2.6 on Microsoft Excel 14.0 but we got several problems to work with it.

Once the addin is installed and we open the AO with the com component enabled we always got a initial error:

"The Analysis Add-In is not registered correctly".

After that, when we need to add a Data Source, and we select one of the BW systems from SAPUILandscape.xml, we got the error:

"An exception has occurred that was not caught."

We create a new OLAP connection from BO and try to access from AO with same error.

Reg edit configuration for addin component are review as:

* Behaviour

* SAPUILandscape.xml

We have a couple of questions related to installation:

Is BI ADD-ON pack needed to be installed on BI server fro AO functionality?

Will we have any problem if we have Analyzer installed too?

Thank you

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 10 at 05:21 PM

    I'm not familiar with Excel 14; the Product Availability Matrix says it supports Excel 2013/2016 - see https://support.sap.com/content/dam/launchpad/en_us/pam/pam-essentials/SAP_Analysis_MS_26.pdf

    Add comment
    10|10000 characters needed characters exceeded