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 com.sap.ip.bi.pioneer.controls.opendialogs.browsingmodel.CnBoeBrowsingModel.LoadChildren(CoOpenTreeNode iTreeNode)
   at com.sap.ip.bi.pioneer.controls.opendialogs.browsingmodel.CnAbstractBrowsingModel.GetListRecursive(Dictionary`2 cTreeNodes, CoOpenTreeNode iNode)
   at com.sap.ip.bi.pioneer.controls.opendialogs.browsingmodel.CnAbstractBrowsingModel.PerformListRecursive(List`1 iTopLevelNodes, Dictionary`2 iTreeNodes)
   at com.sap.ip.bi.pioneer.controls.opendialogs.browsingmodel.CnAbstractBrowsingModel.GetList()
   at com.sap.ip.bi.pioneer.controls.opendialogs.browsingmodel.CnBoeBrowsingModel.GetList()
   at com.sap.ip.bi.pioneer.controls.opendialogs.CnOpenConnectionsControl.RefreshList(FilterState iFilterState)
   at com.sap.ip.bi.pioneer.controls.opendialogs.CnOpenConnectionsControl.<ControlLoadHandler>b__21()
   at com.sap.ip.bi.pioneer.controls.utils.UserActionProcessor.DoUserAction(UserActionDelegate iDelegate, CoUseWaitCursorEnum iWaitCursor, ISupportDialogResultSettable iSupportDialogResult)

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

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:

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.

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