Symptom
Is HANA Cloud supported in Analysis Office?
Environment
SAP Analysis for Microsoft Office
Resolution
- Via local connection to HANA
Analysis Office supports HANA Cloud via the HANA Analytics Adapter (HAA) version 2.x or lower which defines the endpoint. This endpoint must be used in AO in the normal HANA connection dialog (see chapter "To create a local SAP HANA connection").
The support of HANA Cloud is also mentioned in PAM of AO 2.8 (check the document available in section "Essential Information").
The following prerequisite must be met:
The URL of the HANA Cloud system configured in Analysis Office must be working when checked directly in browser. - Via OLAP connection configured in BI Platform
Currently Analysis Office does not support the connection to HANA Cloud via OLAP connection configured in BI Platform.
Keywords
hana cloud, haa, analytics adapter , KBA , BI-RA-AO-XLA , Excel Addin , How To
Product
SAP Analysis for Microsoft Office all versions