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
- Doesn't work with Sap Hana - Row tables
- You cannot add column views to the Data Foundation
- 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.
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.