Live SAP HANA Restrictions for Smart Insights

The following usage restrictions apply when working with live SAP HANA connections and Smart Insights.

Connection Types

The following live connection types aren't supported:

  • SAP Business Tehcnology Platform (BTP)

  • Tunnel

  • SAP HANA Cloud

  • Path

Data Sources

The following types of SAP HANA data sources aren't supported:

  • SAP HANA in SAP Business Technology Platform (BTP)

  • SAP HANA HDI containers

  • SAP HANA Cloud

  • SAP BW/4HANA, S/4HANA and SAP BW on HANA

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.

Sizing

If your model contains more than 20 million rows of data, we may not be able to generate model metadata in all cases. In this scenario, dimension usage statistics will be used as a fallback option if possible.

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 may not be 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

Smart Insights Features

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

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

  • 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 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 have not set default values for mandatory variables and input parameters in your SAP HANA modeling views, the model metadata can't be generated. In this scenario, dimension usage statistics will be used as a fallback option if possible.