Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
De-normalization and Analytic views in SAP HANA
Note that HANA is not for de-normalization however it stores data in columnar format so all aggregations are performed on the fly.
You can create multiple views but this will add duplicate data and an extra effort to maintain them. Number of views normally depends on business needs, because views contain data in many aspects so they can be reused. In case you have multiple measures to handle in views, you can create calculation views to get data in your reports.
Calculation Views are used to consume other Analytic, Attribute and other Calculation views and base column tables. These are used to perform complex calculations, which are not possible with other type of Views.
To know more about SAP HANA Modeling, you can refer our SAP HANA tutorial.
201 Views
