SAP Knowledge Base Article - Public

2494922 - OLAP connections not visible in Analysis Office


After connecting to BI platform (4.2), Analysis Office (2.x) is not showing list of OLAP connections available in CMC.

The entries below can be found in Analysis Office trace:

General .NET Exception:
Object reference not set to an instance of an object.
   at iTreeNode)
   at`2 cTreeNodes, CoOpenTreeNode iNode)
   at`1 iTopLevelNodes, Dictionary`2 iTreeNodes)
   at iFilterState)
   at iDelegate, CoUseWaitCursorEnum iWaitCursor, ISupportDialogResultSettable iSupportDialogResult)


SAP BusinessObjects Analysis, edition for Microsoft Office
SAP BusinessObjects Business Intelligence Platform

Reproducing the Issue

  1. Start Analysis Office;
  2. Connect to BI platform;
  3. No OLAP connection shows up, the list is empty.


There is at least one OLAP connection to HANA, which is not HTTP-based or there is a corrupt OLAP connection which cannot be edited.


Analysis for Office 2.x version only supports OLAP connection to HANA if the provider is "SAP HANA http" as shown below:

HANA http based.png

Check if there is an OLAP connection to HANA via ODBC or a connection which cannot be edited anymore in CMC. Deleting or changing the connection to "SAP HANA http" or deleting the corrupt OLAP connection solves the issue.

See Also

2433263 - OLAP connection to HANA is not showing up in Analysis for Office


olap connection, hana http, native, odbc, jdbc, visible, empty, unable, unavailable, cmc, bip, list , KBA , BI-RA-AO-XLA , Excel Addin , BI-RA-AO-BIP , AO Precalculation, Scheduling and AO InfoOb... , Problem


SAP Analysis for Microsoft Office all versions