- Trending Categories
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
Using Analytic View in SAP HANA
You are correct. In SAP HANA, Analytic Views are used to implement Star Schema queries wherein we join one Fact table to multiple Dimension tables. Analytic views use the real power of SAP HANA to perform
complex calculations and aggregate functions by joining tables in form of star schema and by executing Star schema queries.
Following are key characteristics of SAP HANA Analytic View:
- Analytic Views are used to perform complex calculations and Aggregate functions like Sum, Count, Min, Max, Etc.
- Analytic Views are designed to run Start schema queries.
- Each Analytic View has one Fact table surrounded by multiple dimension tables. The fact table contains primary key for each Dim table and measures.
- Analytic Views are similar to Info Objects and Info sets of SAP BW.
You can check all existing Analytic view in HANA Studio by navigating to Content tab -> Package Name -> Analytic Views Folder
- Related Articles
- Consuming Attribute/Analytic view in a Calculation view in SAP HANA
- Consuming Attribute views in an Analytic view in SAP HANA
- Defining Parameters/Variables in an Analytic View in SAP HANA
- \nQuery in Analytic view creating unexpected results in SAP HANA\n
- Creating Attribute and Analytic view as persistent model in SAP HANA
- Creating Attribute and Analytic view as persistent model in SAP HANA
- Using Operators in Analytic Privilege in SAP HANA
- Using database view in SAP HANA
- Using Attribute view in SAP HANA
- Key characteristics of using Analytic Privilege in SAP HANA Modeling
- Using an Analytic Privilege for specific time in SAP HANA
- De-normalization and Analytic views in SAP HANA
- Adding multiple views in SAP HANA Analytic Privilege
- Using different Projection options in Calculation view in SAP HANA
- Using Time subtype of an attribute view in SAP HANA

Advertisements