hana modeling using sample efashion database

7/22/2019 HANA Modeling Using Sample eFashion Database

1/57

Learn SAP HANA Modeling using

sample eFashion DatabaseDhirendra Gehlot

[


2/57

[ Learning Points

Quickly learn HANA modeling using eFashion data model

Quickly build eFashion universe using HANA model

Compare and contrast eFashion HANA model/UNX universewith sample MS Access based eFashion universe

Real Experience. Real Advantage. 2


3/57

[ Agenda

eFashion Database and Universe Overview

SAP HANA Modeling Process Overview

Build HANA Model using eFashion Database

Build Universe using HANA Model

Compare and Contrast



4/57

[ eFashion Universe Classes and Objects

Sample Universe/MS Access Database

Dimensions

Time period Store

Product


ro uct o or Promotions

Facts

Sales

Promotions


5/57

[ eFashion Universe Structure



6/57

[ Agenda



Build HANA Model using eFashion Database





7/57

[ SAP HANA Modeling Process Overview

1. Create eFashion Schema and Tables

2. Load Sample Data

3. Create HANA Model Package4. Create Attribute Views for each dimensions

5. Create Analytic View for Sales


6. Create Analytic View for Promotions7. Create a Calculation View combining Sales and Promotions


8/57

[ 1. Create eFashion Schema and Tables

Launch SQL Editor from HANA Studio

Run SQL Command to create schema

CREATE SCHEMA EFASHION;

Run SQL Commands to create tables Six(6) Dimension Tables


wo act a es

CREATE COLUMN TABLE EFASHION.OUTLETS


9/57

[ 2. Load Sample Data

Several options for Data Load

Run SQL Commands to insert data into EFASHION schema INSERT INTO . INSERT INTO EFASHION.ARTICLE_LOOKUP values (119427,'Stole and Feather Boa Set','Jewelry',110,'Accessories','F60');

INSERT INTO EFASHION.CALENDER_YEAR_LOOKUP VALUES(1,1,1999,'FY99','1999/01',1,'January',1,'n');

.


Bulk Data Load from CSV file

Data Services


10/57

[ 3. Create HANA Package

Create HANA Package Select Content folder

Right Mouse Click > New > Package

Provide Package Definition



11/57

[ 4. Create Attribute View for Time Dimension

Select efashionsample package

Right Click > New > Attribute View

Provide View Definition

Next

Select Calendar_Year_Lookup table

Finish


Add Attributes

Select WEEK_ID > Right click

Add as Key Attribute

Add all other fields as Attributes

Save and Activate

Data Preview


12/57





Next


Finish


Add Attributes




Save and Activate

Data Preview


13/57





Next


Finish


Add Attributes




Save and Activate Data Preview


14/57





Next


Finish


Add Attributes



Add all other filed as Attributes



15/57





Next


Finish


Add Attributes



Add all other filed as Attributes



16/57





Next


Finish


Add Attributes Select WEEK_ID > Right click





17/57





Next


Finish





Save and Activate

Data Preview


18/57





Next


Finish







19/57

[ 4. Create Attribute Views for Store Dimension

Follow similar process to Create Attribute Views for remainingDimensions

Store

Product

Product Color


Promotions


20/57

[ 4. Create Attribute Views for Product Dimension


Store

Product

Product Color


Promotions


21/57

[ 4. Create Attribute Views for Product Color Dimension


Store Product

Product Color


Promotions


22/57

[ 4. Create Attribute Views for Promotions Dimension


Store Product

Product Color


Promotions


23/57

[ 5. Create Analytic View for Shop Facts


Right Click > New > Analytic View


Next, Select SHOP_FACT table

Next, Select Dimensions

Finish


Add Attributes SHOP_FACT_ID, ARTICLE_ID, COLOR_CODE, WEEK_ID, SHOP_ID

Add Measures

MARGIN, AMOUNT_SOLD, QUANTITY

Create Calculated Measures Join Fact Table and Dimensions

Save and Activate

Data Preview


24/57







Finish



Add Measures



Save and Activate

Data Preview


25/57







Finish



Add Measures



Save and Activate

Data Preview


26/57







Finish



Add Measures



Save and Activate

Data Preview


27/57







Finish



Add Measures



Save and Activate

Data Preview


28/57







Finish



Add Measures



Save and Activate

Data Preview


29/57







Finish



Add Measures



Save and Activate

Data Preview


30/57







Finish



Add Measures



Save and Activate

Data Preview


31/57







Finish



Add Measures



Save and Activate

Data Preview


32/57







Finish



Add Measures



Save and Activate

Data Preview


33/57

[ 6. Create Analytic Views for Promotion Fact

Follow similar process to Create Analytic View for PromotionFact



34/57

[ 6. Create Analytic Views for Promotion Fact

Follow similar process to Create Analytic View for PromotionFact



35/57

[ 7. Create a Calc View to combine Sales and Promotions


Right Click > New > Calculation View


Next, Select Analytic Views

Finish

Select UNION, Link views to UNION, Link UNION to OUTPUT


Select UNION and MAP elements Select OUTPUT, and add Attributes and Measures

Save and Activate

Data Preview


36/57






Finish




Save and Activate

Data Preview


37/57






Finish




Save and Activate

Data Preview


38/57






Finish



Select UNION and MAP elements

Select OUTPUT, and add Attributes and Measures

Save and Activate

Data Preview

[


39/57






Finish





Save and Activate

Data Preview

[


40/57



[


41/57






Finish





Save and Activate

Data Preview

[


42/57



[


43/57






Finish





Save and Activate

Creates a database view or column view in schema _SYS_BIC

Name of the column view: _SYS_BIC./ Data Preview

[


44/57



[


45/57

[ eFashion HANA Package/Model


[


46/57

[ Agenda


SAP HANA Modeling Terminology

SAP HANA Modeling Process Overview Build HANA Model using eFashion Database




[ B ld U HANA M d l


47/57

[ Build Universe using HANA Model

Launch Information Design Tool (IDT)

Create a Repository Connection to HANA Database

Create a Project

Create a Short Cut for Connection

Create Data Foundation Layer

Create Business Layer


Publish Business Layer to the Enterprise

[ B ild U i i HANA M d l


48/57



Create a Repository Connection to HANA

Create a Project



_SYS_BIC./






49/57




Create a Project








50/57




Create a Project






[ Agenda


51/57

[ Agenda



Build HANA Model using eFashion Database Build Universe using HANA Model



[ Universe Objects


52/57

[ Universe Objects

eFashion on HANA eFashion on MS Access


[ Universe Structure


53/57

[ Universe Structure



[ Universe Objects Definitions


54/57

[ Universe Objects Definitions


State State


Sales Revenue Sales Revenue

[ Universe


55/57

[ Universe


No Summary Tables

No JoinsNo ContextsNo Calculated objectNo Use of @Aggragate_Aware() Function

Summary Tables

JoinsShop and Promotion ContextsCalculated Objects/MeasuresUse of @Aggragate_Aware() function


o a a ase n ex

One-to-one mapping to Calc View output

a a ase n ex requ re o mprove

performance

[ Learning Points


56/57

[ Learning Points

Quickly learn HANA modeling using eFashion data model

Quickly build eFashion universe using HANA model

Compare and contrast eFashion HANA model/UNX universewith sample MS Access based eFashion universe


[

]


57/57

[

] Thank you for participating.SESSION CODE: 0213

Please remember to complete and return your

evaluation form following this session.

For ongoing education on this area of focus, visit the

Year-Round Community page at www.asug.com/yrc


hana modeling using sample efashion database

Documents