Q. What is an Analytical View?
Ans. When a Fact table to be connected to multiple dimensions, we use analytical view. The
Analytical views are built to perform complex Aggregations SUM, MIN, MAX, AVG, COUNT ) on measure. These views are processed by OLAP engine in SAP HANA. They are used to build so called
STAR schema. Also has capabilities to define calculated columns, restricted columns, filters, import parameters, complex conversions.
It is important that In an analytical view, we must mark attributes and measures at the end in semantic. Because an aggregation will be applied only on measure.
Share with your friends: |
