PowerExchange for HANA User Guide for PowerCenter

PowerExchange for HANA User Guide for PowerCenter

HANA Data Modelling Views

HANA Data Modelling Views

When you use PowerExchange for HANA, you can read from the following HANA data modelling views:
Attribute views
Attribute views are built on top of dimension tables. You can use attribute views to define joins between tables and to select a subset of columns and rows from a table.
Analytic views
Analytic views are optimized for aggregating mass data. You can use analytical views if you need aggregated data from the underlying table.
Calculation views
Calculation views are layered on top of one or more analytic or attribute views and allow you to perform calculations after grouping at the attribute level and after aggregation at the analytic level.

0 COMMENTS

We’d like to hear from you!