Skip to Content
Former Member
Jan 10, 2018 at 05:00 PM

Analysis for Office BW connection error

1220 Views Last edit Jan 11, 2018 at 09:55 AM 2 rev


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