SAP Knowledge Base Article - Public

2599328 - Pre-defined HANA data source in OLAP connection is not executed in Analysis for Office


An OLAP connection with pre-defined HANA data source is created in BI CMC like in the example below:

OLAP connection.png

When selecting this OLAP connection in Analysis for Office, the pre-defined HANA data source is not executed automatically.


SAP BusinessObjects Analysis, edition for Microsoft Office

Reproducing the Issue

  1. Start Analysis Office;
  2. Connect to BI platform;
  3. Select OLAP connection to HANA system, which has a pre-defined HANA data source selected;
  4. Confirm that the HANA data source will not be executed automatically. Instead, the search dialog will appear where the user can search for a HANA data source.


This is a limitation in Analysis for Office.


This is a limitation in Analysis for Office. Pre-defined HANA data source is not supported. Currently, only pre-defined BW data sources is supported.


hana, view, data source, datasource, query, infoprovider, olap connection, calculation, predefined , KBA , BI-RA-AO-BIP , AO Precalculation, Scheduling and AO InfoOb... , BI-RA-AO-XLA , Excel Addin , Problem


SAP Analysis for Microsoft Office all versions