Attribute views

About

Attribute views are used to model an entity based on the relationships between attribute data contained in multiple source tables.

You can add to the attribute view:

  • more columns
  • and also hierarchies

Analytic views can contain two types of columns: attributes and measures.

You can create hierarchies to arrange the attributes hierarchically. You can create Level hierarchies and Parent Child hierarchies by specifying the attributes that correspond to different levels, and parent child nodes respectively

Prerequisites

Type

  • Standard: A standard attribute view with table attributes.
  • Time: An attribute view with time characteristics that use the time tables. See HANA - Generate Time Data
  • Derived: Create an attribute view that is derived from an existing attribute view. Derived attribute views are read-only.

Usage

Star Schema - Dimension

One application of attribute views is to join multiple tables together when using star schemas, to create a single dimension view. The resultant dimension attribute view can then be joined to a fact table via an analytic view to provide meaning to its data. In the star schema of the analytic view, the attribute view is shown as a single dimension table (although it might join multiple tables), that can be joined to a fact table.

For example, attribute views can be used to join employees to organizational units which can then be joined to a sales transaction via an analytic view.


Powered by ComboStrap