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:
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?