Attribute Types

There are different types of attributes to be used in fact models and consumption models.

Attribute Types

Attribute Type

Description

Dimension Source Attribute

References an attribute from a dimension source in the consumption model.

Calculated Attribute

A calculated attribute is based on a formula which is specified as an SQL expression and must match the chosen data type. The calculation evaluates on rows - access to values in other rows (cell-reference) is not possible.

An automatic validation takes place to provide immediate feedback.

For more information on syntax and available functions, please refer to the SAP HANA SQL Functions Reference and Operators Reference.

Fact Source Attribute Mapping/Fact Source Attribute

Allows mapping of common attributes across the fact sources in the source model. Fact sources that do not provide an applicable attribute may default to NULL or to a constant value. You only have to map fact sources when your consumption model contains more than one fact source. If your consumption model contains only one fact source, the attribute type is called Fact Source Attribute.