Symptom
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)
Environment
SAP BusinessObjects Analysis, edition for Microsoft Office
SAP BusinessObjects Business Intelligence Platform
Reproducing the Issue
- Start Analysis Office;
- Connect to BI platform;
- No OLAP connection shows up, the list is empty.
Cause
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.
Resolution
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.
See Also
Keywords
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