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.8 Build Your First Analytic View

This article describes how to build a simple analytic view using data stored on SAP HANA.

Prerequisite:

    • You have SAP HANA Studio installed on your machine (Section 3.2)
    • You have added an SAP HANA system in HANA Studio (Section 3.3)
    • You have created the attribute view as mentioned in Section 4.5
      In the analytic view, we will reuse that attribute view.
Steps for creating Analytic view:

  1. Right click on the package and choose “New Analytic View.” Enter a name and a description and click “Finish”

    SAP HANA Analytic View

  2. Click on “+” sign of “Data Foundation” and add table SALES.

    SAP HANA Analytic View

  3. Right Click on the columns of table SALES and add REGION_ID and SALES_AMOUNT to output.

    SAP HANA Analytic View

  4. Click on “+” sign of “Logical Join” and add attribute view “AT_Region” which was created earlier.

    SAP HANA Analytic View

  5. Click on the REGION_ID from “Data Foundation” and connect it to the REGION_ID of attribute view AT_Region. In the properties pane select join type as left outer join and cardinality as n..1

    SAP HANA Analytic View

  6. Select “Sementics”. In the right side change the column type of SALES_AMOUNT as measure.

    SAP HANA Analytic View

  7. Activate the analytic view similar to attribute view.
    Right-click on your analytic view and choose “Data Preview.” After that, you can browse through the tabs named raw data, distinct values, and analysis.

    SAP HANA Analytic View

    SAP HANA Analytic View

Congratulation!! You have successfully created your first Analytic View.

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