Q. What is the difference between Row Storage and Column Storage? Row Store



Download 156.8 Kb.
View original pdf
Page22/48
Date07.04.2021
Size156.8 Kb.
1   ...   18   19   20   21   22   23   24   25   ...   48
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.

Download 156.8 Kb.

Share with your friends:
1   ...   18   19   20   21   22   23   24   25   ...   48




The database is protected by copyright ©ininet.org 2020
send message

    Main page