SAP HANA Calculation Views

Опубликовано: 25 Май 2026
на канале: Krish & Naresh Ganatra

16,635

The demo where I am showing Analytic views at a slower pace is at
• SAP HANA Modeling

** Video best visible in 720HD mode with your screen resolution at or closer to 1280x720 **
Below is the script I have used for this demo...

Regards,
Naresh

------------------- CREATE SCHEMA --------------------

create schema a2sales;

----------------- CREATE FACT TABLES -----------------

create column table a2sales.sales_fact
(sf_key integer, country_id integer, item_id integer, sales_amount double );

create column table a2sales.forecast_fact
(ff_key integer, country_id integer, forecast_amount double );

---------------- CREATE DIM TABLES -----------------

create column table a2sales.COUNTRY_DIM
(
country_id integer,
country_name varchar(100),
region_name varchar(100)
);

create column table a2sales.ITEM_DIM
(
item_id integer,
item_name varchar(100)
);

------------ INSERT DATA INTO TABLES -----------------
insert into a2sales.COUNTRY_DIM values (1,'USA','Americas');
insert into a2sales.COUNTRY_DIM values (2,'Canada','Americas');
insert into a2sales.COUNTRY_DIM values (3,'China','APJ');
insert into a2sales.COUNTRY_DIM values (4,'India','APJ');
insert into a2sales.COUNTRY_DIM values (5,'Germany','EMEA');

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

insert into a2sales.forecast_fact values (1,1,250);
insert into a2sales.forecast_fact values (2,2,400);
insert into a2sales.forecast_fact values (3,3,200);
insert into a2sales.forecast_fact values (4,4,100);
insert into a2sales.forecast_fact values (5,5,50);

insert into a2sales.sales_fact values (1,1,1,100);
insert into a2sales.sales_fact values (2,1,2,90);
insert into a2sales.sales_fact values (3,1,5,85);
insert into a2sales.sales_fact values (4,2,2,80);
insert into a2sales.sales_fact values (5,2,1,75);
insert into a2sales.sales_fact values (6,3,3,85);
insert into a2sales.sales_fact values (7,4,4,75);
insert into a2sales.sales_fact values (8,5,1,65);
insert into a2sales.sales_fact values (9,5,2,65);