Hello, Habr! It's time to talk about the path of data from the source, where it occurs, to the view, in which it is convenient to analyze it. Now we all work in an environment in which the speed of preparing data for their use can become a competitive advantage. Let's take a look at how data modeling in SAP BW / 4HANA is done, how fast and convenient it is, and whether it allows companies to benefit from it.
But first, a little history, and then, using the example of everyone who is not indifferent to the topic of football, we will analyze the practical steps in the system.
In 1998, the first version of the SAP product for reporting, analysis and data storage called the Business Warehouse Information System was presented. The main idea behind the creation was to implement a simpler and more efficient data storage with a special focus on SAP ERP data. Since then, the solution has gone from version 1.2A to BW / 4HANA, becoming an essential component for building data warehouses for thousands of companies around the world.
The changes that SAP BW has received during its existence were a response to the challenges of different stages in the development of data warehouses. These are requirements for functionality, performance, data volumes for analysis. For example, the transition of SAP BW from traditional to resident (in-memory) databases. In fact, this is a movement towards the speed of processing the increased volumes of data and solving practical business problems with the help of BW. This is especially true now, when business expects IT to apply new requirements as soon as possible. This is not a whim, but the conditions that the competitive environment dictates for the normal functioning of the business and its development.
SAP BW/4HANA BW LSA ( ). LSA++. LSA++ SAP BW/4HANA , . – – .
LSA++. , 13 30 1930 .
.csv – , , , -, , , . , - 2018 , ( ? :)), (. 1).
, . , , , , ? , , . ?
, , . SAP HANA Studio, .
- – (Characteristic) (Key Figures) . – , BW.
– , , , -, , (. 2).
, , (. 3).
(. 4 4).
SAP BW/4HANA - . - -, . , , , , ? . , - , , . , - : , , , ..
, -, (-). ADSO (. 5).
-, (.6).
, , , , ADSO (0Calday) (0Calyear). , , « ». BW , , .. , SAP.
, . – ( ) ( , ), BW. . (Flat file) (. 7).
, : , , . , ( ) -. , (. 8).
, , ADSO. , , (. 9).
, drag and drop. ( ) . , (.10).
, , «» . «». , (. 11).
: , , , , .. (. 12).
, -, «». drag and drop , : , .. (. 13).
, – (DTP - Data Transfer Process). «» (. 14).
, , . , (. 15).
, .
, ADSO (. 16).
: (Debugging). , , , . (. 17).
, , . , , , .
(. 18).
. , (. 19).
, , ADSO . (. 20).
(. 21).
, «Act.». , ADSO . , ADSO , BW , , .
, LSA++ (Virtual provider). , ?
, ADSO, , : , , . (. 22).
Composite provider, Virtual Data Marts (. 23).
, ADSO Left Outer Join ZSTAD – . .
, . -, (. 24).
, ! – Composite provider. Query – , BI- (. 25).
Query . , , , . ..
Query ! , (. 26).
(. 27).
! - , !
LSA++. LSA , , time-to-market , .
4 :
InfoObject – BW. , , -. - - ( ) - ( ).
Advanced DataStore Object (ADSO) – , BW HANA. ADSO - BW. , . ADSO -, , BW -. .
Open ODS View – , BW HANA. BW (View) , BW . -. Open ODS View , .
Composite Provider – , « ». - -, Union Join, .
, , LSA++, (. 28).
Staging layer/Corporate memory
Corporate memory. . . . , , , , «» - . ADSO.
Open ODS layer/Raw DWH
.
:
- DSO, SAP HANA, BW HANA Calculation View;
- Open ODS View.
, , -SAP-, - .
Propagation layer/Integrated DWH
. , . ADSO.
Architected Data Mart
. , Propagation layer Virtual data marts .
ADSO -.
Virtualization/Virtual Data Marts
-, ( ), , Union Join. Open ODS Propagation layer Architected Data Mart, .
-. -, , .
Virtual Data Marts Composite Provider Open ODS View .
LSA++ Virtualization/Virtual Data Marts . , , . , , , ..
:
- ;
- , ;
- ;
- - – ;
- , ;
- .
, , – , SAP BW/4HANA . , ! LSA++, , , , ?
, , ! !