SAP HANA Modeling

Опубликовано: 16 Июнь 2026
на канале: Krish & Naresh Ganatra

49,658

122

Headset / Mic used for recording -
USA - https://amzn.to/2RrKwrm . / India - https://amzn.to/2LSpe1t .

You might also want to watch the demo on Calculation views that I have at • SAP HANA Calculation Views
SAP HANA Demo : Modeling/Training exercise using Information Modeler in SAP HANA Studio

** Video best visible in 720HD mode **

More documentation on HANA can be found at
http://help.sap.com/hana_appliance

Also, the REGION_DIM should actually be SUB_REGION_DIM or so...I previously planned only to have the REGION names, but then later added the SUB REGION to get some additional rows in the data/graph.

Steps shown in this demo.

Create a Package
Create a Attribute View
Create a Analytic View
Data Analysis

Below is the script I have used to create and populate the 3 tables in the demo.

create schema sales;

create column table sales.sales_fact
(region_id integer, item_id integer, sales_amount double );

create column table sales.region_dim
(
region_id integer,
region_name varchar(100),
sub_region_name varchar(100)
);

create column table sales.item_dim
(
item_id integer,
item_name varchar(100)
);

insert into sales.sales_fact values (1,1,100);
insert into sales.sales_fact values (1,2,90);
insert into sales.sales_fact values (1,5,85);
insert into sales.sales_fact values (2,2,80);
insert into sales.sales_fact values (2,1,75);
insert into sales.sales_fact values (3,3,85);
insert into sales.sales_fact values (4,4,75);
insert into sales.sales_fact values (5,1,65);
insert into sales.sales_fact values (5,2,65);

insert into sales.region_dim values (1,'Americas','NA');
insert into sales.region_dim values (2,'Americas','SA');
insert into sales.region_dim values (3,'APJ','Asia');
insert into sales.region_dim values (4,'APJ','Japan');
insert into sales.region_dim values (5,'EMEA','EMEA');

insert into sales.item_dim values (1,'Shirts');
insert into sales.item_dim values (2,'Jackets');
insert into sales.item_dim values (3,'Trousers');
insert into sales.item_dim values (4,'Skirts');
insert into sales.item_dim values (5,'Purse');

Thank You !!

Thanks,
Naresh