Models Based on Live Data Connection HANA Views
You can create models by connecting to SAP HANA database views. Functionality available for models based on HANA views is slightly different in comparison to other models.
With analytics models based on HANA views, you can use your existing data with SAP Analytics Cloud. Many of the features used in planning-type models are not relevant for this type of model, including financial data types, and currencies. These are some of the main differences and features:
In HANA models, only a single Measures dimension is initially visible in the model, but all other dimensions are available on the All Dimensions tab. Because the number of dimensions may be large, and many of these dimensions won't be relevant in SAP Analytics Cloud, you can use the Hide check boxes to make dimensions unavailable in stories based on this model.
For models based on HANA views, version management functionality is also available. You can use this feature to map any of the imported dimensions to selected SAP Analytics Cloud planning categories such as Budgets, Actuals, or Forecasts.
You can define variables for all types of models, but if variables have been defined in HANA you will also be prompted to enter the required values in SAP Analytics Cloud when you open the data output.
When using calculated columns in SAP HANA live data connection models, you'll need to keep in mind the output type of any formulas and operations in use. For data correctness, it is important to ensure the following:
- Any intermediate results are correctly cast to the appropriate type.
- The final result has the appropriate type and scale set.
For example, if you use a function that returns an integer, and divide the result by another integer, the produced output will be an integer, resulting in the loss of any digits to the right of the decimal point. This loss could cause critical data correctness issues.
- Example 1: Calculated Column (Data Type:
"Age (in Years)"=DaysBetween("Birth_Date", now())/365
- The formula will return only whole integers for age, which corresponds to the Data Type specified for the calculated column, and is the expected result.
- Example 2: Calculated Column (Data Type:
"Tenure (in Years)"=DaysBetween("Hire_Date", now())/365
- The formula will return only whole integers for tenure, but the calculated column settings indicate that a floating point number is expected as the result, meaning that a significant amount of information will be lost for each tenure calculation.
- In cases like this, there are two recommendations:
- Use a conversion function on one or both integer values being divided, to convert to the floating number type with the desired precision (for example, DECFLOAT).
- Increase the Scale setting to minimize the loss of precision as values for the calculated column are aggregated.
- A corrected Calculated Column definition could be (Data
"Tenure (in Years)"=DECFLOAT(DaysBetween("Hire_Date", now()))/DECFLOAT(365)
Analytics models that are based on underlying HANA database views will inherit the security restrictions applied in HANA. These restrictions can be modified in SAP Analytics Cloud by assigning specific user role security to them.
The Data Access option that is available for other model types to restrict input to specific named cells is not available for this type of model.
Note that access to models may be secured, and you may be prompted for credentials before opening the model.
Some SAP Analytics Cloud features are enabled for models based on HANA views only if the SAP HANA system meets certain criteria:
|SAP HANA System Configuration||Features Enabled|
Live HANA baseline level 1
SAP HANA 1.0:
SAP HANA 2.0:
Live HANA baseline level 2
SAP HANA 2.0:
All of the above features that are enabled with Live HANA baseline level 1, plus the following additional features: