SapHanaTutorial.Com HOME     Learning-Materials Interview-Q&A Certifications Quiz Online-Courses Forum Jobs Trendz FAQs  
     Explore The World of Hana With Us     
About Us
Contact Us
 Apps
X
HANA App
>>>
Hadoop App
>>>
Tutorial App on SAP HANA
This app is an All-In-One package to provide everything to HANA Lovers.

It contains
1. Courses on SAP HANA - Basics, Modeling and Administration
2. Multiple Quizzes on Overview, Modelling, Architeture, and Administration
3. Most popular articles on SAP HANA
4. Series of Interview questions to brushup your HANA skills
Tutorial App on Hadoop
This app is an All-In-One package to provide everything to Hadoop Lovers.

It contains
1. Courses on Hadoop - Basics and Advanced
2. Multiple Quizzes on Basics, MapReduce and HDFS
3. Most popular articles on Hadoop
4. Series of Interview questions to brushup your skills
Apps
HANA App
Hadoop App
';
Search
Stay Connected
Search Topics
Course Index
Close
X
SAP HANA Basics
Course Overview
1. Introduction to SAP HANA
2. SAP HANA Architecture
3. SAP HANA Studio
4. SAP HANA Modeling
5. Reporting on SAP HANA
6. What is Next?
<< Previous
Next >>

4.7 Analytic View Overview

Analytic views are fact tables surrounded by dimensions (attribute views) and hence it resembles star schema.

    • In the language of SAP BW analytical views can be roughly compared with Info Cubes or Info Sets.
    • Analytic views are typically defined on at least one fact table that contains transactional data along with number of tables or attribute views.
    • Analytic views leverage the computing power of SAP HANA to calculate aggregate data, e. g., the number of bikes sold per country, or the maximum power consumed per month.
    • It is specifically designed to execute star schema queries.

HANA Analytical Views are highly optimized for aggregating mass data.

Capabilities of Analytic Views:

    • Defining Calculated & Restricted Measures
        • Aggregation (sum, max, min)
        • Expressions / Operators / Functions
    • Currency and Unit Conversion
    • Variables and Input Parameters
        • Variables and Parameters are usually entered manually by the users to filter data
Analytical View – Structural Overview:

/

Data Foundation of Fact Data

    • Create a fact table by adding and joining the tables

Logical Join with Attribute View

    • Join attribute views to these tables in the Logical Join node.

Semantics Information

    • Classify the Columns and Calculated Columns as attributes and measures.
    • You can also create variables/input parameters, and assign variables to the columns in the Semantics node.

Click here to go to Next Chapter.

Connect to The SAP HANA Forum to ask any question, provide feedback or share information.

 © 2017 : saphanatutorial.com, All rights reserved.  Privacy Policy