Calculated and Restricted Columns
To derive new values, you can add a calculated column, counter, or restricted column, to enhance an existing SAP HANA View.
Note
Calculated columns are similar to calculated key figures. Restricted columns are similar to restricted key figures in SAP BW/4HANA.These functions are executed during reporting and are typically not part of a data storage scenario, but defined on a specific SAP HANA View node. As a prerequisite, make sure that all fields that you need in the expression, are available at this level.
Calculated and restricted columns are defined in an SAP HANA calculation view and restricted key figures and calculated key figures are defined in SAP BW/4HANA. In the table, you see how specific tasks can be done in both approaches.
Comparing SAP HANA and SAP BW/4HANA Approach
| Task | SAP HANA Calculation View | SAP BW/4HANA |
|---|---|---|
| IF... THEN... | Condition can be defined on any data type | Condition must compare key figures |
| Derive Top N | Use Rank Node:
| Use SAP BW/4HANA Condition:
|
| Filter |
|
|
| Union, Join and Calculation | Can be combined in any order | Combinations of Unions and Joins in CompositeProviders more flexible then calculation in Query |
| Functions | Leverage SAP HANA functions, for example substring, date conversion, add x days | Often only via SAP BW/4HANA variables with custom code |
Currency Conversion
SAP HANA offers modeling options for currency conversion.
To enable conversion in SAP HANA, the following tables must be available in the SAP HANA database. For example, in a dedicated schema for currencies and exchange rates.
Required Conversion Tables
| Table Name | Description |
|---|---|
TCURC | Currency codes |
TCURR | Exchange rates |
TCURV | Exchange rate types for currency translation |
TCURF | Conversion factors |
TCURN | Quotations |
TCURX | Decimal places in currencies |
These tables exist in most SAP Systems (SAP S/4HANA, SAP BW/4HANA). In the currency calculation definition, you must specify the schema for the currency conversion.
If you want to reference the SAP BW/4HANA tables, choose the SAP BW/4HANA schema. Make sure that they are regularly updated to cover all necessary Conversion Dates.
The models may be based on data replicated from another system. If so, the replication process must also include these tables so that they are always synchronized with the ones located on the source system.
By default, a measure has no Semantic Type. When a measure contains an amount and you want to enable conversion, you must set its Semantic Type to Amount with Currency Code.
Note
This is different in SAP BW/4HANA, where the relationship to a currency is already set in the definition of a Key Figure.This Amount with Currency Code type is the prerequisite for the currency conversion, but can be a valuable setting on its own, to combine values with a currency.