Limitations to Smart Insights and Live SAP HANA

The following product limitations apply when working with live SAP HANA connections and Smart Insights.

Connection Types

The following live connection types aren't supported:

  • SAP Cloud Platform

  • Tunnel

  • SAP HANA Cloud

  • Path

Data Sources
The following types of SAP HANA data sources aren't supported:
  • SAP HANA in SAP Cloud Platform

  • SAP HANA HDI containers

  • SAP HANA Cloud

  • SAP BW/4HANA and S/4HANA

SAP HANA Version

Smart Insights is only supported on live SAP HANA 1.0 SPS 12 or higher and SAP HANA 2.0 SPS 1 or higher.


If your model contains more than 20 million rows of data, we may not be able to generate model metadata in all cases. This means Smart Insights won't appear for this model on your live SAP HANA connection.

Timing out error
If you see a query time out error listed beside a model in the Troubleshooting section of the Generate Model Metadata dialog, access to Smart Insights on this model in your live connection isn't possible. The timeout could be caused by one of the following:
  • using Smart Data Access in the SAP HANA modeling view

  • large hierarchies

  • large data volumes

  • calculated dimensions


Account or key figure based models aren't supported.

Calculated Dimensions

If your model contains calculated dimensions, we may not be able to generate model metadata in all cases as calculated dimensions can cause slow responses from live SAP HANA systems.

Smart Insights Features

You'll notice the following feature limitations when working with Smart Insights on live SAP HANA:

  • On live SAP HANA, Smart Insights can display insights about top contributors and how your selected data point is calculated. For now, it can't display insights about how your data point has changed over time.

  • When working on the SAP HANA 1.0 baseline version, Smart Insights average calculation does not show additional information like MIN, MAX or outliers.

  • Calculation types Difference From, Date Difference, and Dimension to Measure aren't supported on SAP HANA 1.0.

  • Cross calculations in tables don't support aggregations for Smart Insights on live SAP HANA.

  • Smart Insights on variances for live SAP HANA models aren't supported.

  • Smart Insights doesn't support currency conversion on live SAP HANA models.

  • When viewing the top contributor insights on your data point, Smart Insights doesn't display unassigned values in the top contributor summary chart, like it does when working with acquired models.

  • The grouping feature of a model with live SAP HANA connection isn't supported for Smart Insights.

  • On live SAP HANA, top contributor Smart Insights aren't supported for linked models.

For more information specifically on Smart Insights, see the chapter called Smart Insights.

Mandatory Variables and Input Parameters

If you've not set default values for your mandatory variables and input parameters in your SAP HANA modeling views, model metadata can't be generated, and Smart Insights won't work.