Restrictions for SAP HANA connections

Table 1: Restrictions for the Connect to SAP HANA data source

Restriction

Description

Only one level is available for geographical hierarchies.

Only one attribute at a time can be used when creating a geographical hierarchy.

Measures with numeric or string dimensions cannot be created.

Measures are detected from the SAP HANA analytic view. They must be created in the SAP HANA view before the application can automatically acquire them.

Datasets cannot be published to SAP HANA.

Some functions are not supported.

The following SAP HANA functions are not supported:
  • AddMonthToDate
  • AddYearToDate
  • LastDayOfMonth
  • DayOfYear
  • Week
  • LastWord
  • ExceptLastWord

Some features are not available for analytic views that use a calculation view.

When an analytic view uses a calculation view (for example, when an attribute view within the analytic view has a calculated measure or one or more calculated columns):
  • The grid view is not available in the Prepare room.
  • When a measure is selected in the Prepare room, facets show no values.
  • Sorting on a measure is not possible in the Visualize room.

Other data sources cannot be used along with a Connect to SAP HANA data source.

When a Connect to SAP HANA data source is used in an SAP Lumira document, it is not possible to acquire data from other data sources.