1
-TECH -
3
4
** 1) ODS(Operational Data Store) : ** 2) MART : ** 3) OLAP [ Online Analytical Processing ] :
EDW : DW/BI
// BI
5
SAP HANA (High-Performance Analytic Appliance) Synergy: Columnar + Compression + In-memory + MPP
SAP HANA (DRAM)
OLTP OLAP .
H/W S/W Appliance .
In-Memory DBMS
Data 5 70%
UI , DB Admin
Smart Data Access DBMS DB-Link(DML)
SAP Business Suite, SAP BW Repository DBMS .
6
SAP HANA Oracle(SUN) H/W Global H/W Vendor SAP HANA Certified Platform .
7
SAP BW ERP , . /
(ERP , Legacy )
(DM)
//
(Query)
BW
( BEx Analyzer )
( =Workbook )
/
/ (DM)
(DW)
Source System (Legacy, ERP )
Interface
,
(DW)
8
SAP BW , , , , , . SAP BW Query Designer MS-Excel BEX Analyzer
Query Designer Bex Analyser
EXCEL
Query ()
Query Designer Drag & Drop
Bex Analyzer
Drill-down,
(),
ERP
, DTP BW
9
REPORT
BI
SAP BW on HANA SAP NetWeaver BW
HANA
10
Business Information Warehouse + HANA
SAP NetWeaver BW
Data Modeling
Planning
Data Management
OLAP Pro
cess
Orc
hest
ration
BW on HANA
1. OLAP(Query ) -> (10~50)
2. (Transformation/Loading)
3. EDW
4. (1/7)
HANA BW
SAP BW on HANA
Data Modeling
Planning
Data Management
OLAP Pro
cess
O
rchest
ration
Push Down HANA RDBMS
11
BW 100% Migration SAP Migration Tool Migration BW 100% Migration
RDBMS 100% .
12
Process Chain Steps GBP BW on
HANA
PSA -> DSO
PSA -> InfoCube
DSO
DSO -> InfoCube
X
X
DB X
BWA X
BW
DSO (80%)
BW on HANA
BWA / DB BWA
82% BW PSA staging InfoCube steps ERP BW .
x6
0 200
0
4000 12000 14000
BW
BW on HANA
(35,049,270 )
6000 8000 10000
29
1944
1272
1820 1791
183 244
564
311
0
500
1000
1500
2000
2500
FI MM SD
BW BW on HANA
:
3 12
13
, SAP BW on HANA .
BW powered by SAP HANA
- SAP HANA Appliance
- BW 7.0
- BW DB SAP HANA DB Migration
(Real-time)
- SAP HANA ///
BW
DW DW
BI
BW 7.0
O***** DBMS
BW
BW 7.3 SP6
HANA In-memory DB
BW on HANA
ABAP export(SAPInst )
DDL (SMIGR_CREATE_DDL)
CI (SAPInst)
ABAP export DI (SAPInst)
BW
(RSA1)
(RS_BW_POST_MIGRATION)
ODS/DTP (RSSGPCLA)
/
14
Customer Business Scope Status Customer Business Scope Status
DAELIM COPORATION BW on HANA implementing LG ELECTRONICS INC. BW on HANA(B2B) 2014 1
Samsung Fine Chemical Co., Ltd BW on HANA 2012 9 LS Networks Co. BW on HANA 2014 6
Samsung Everland BW on HANA 2012 12 CJ Foodville Corp. BW on HANA 2015 3
Daelim Industrial Co., Ltd. BW on HANA implementing Hanwha L&C Corp. BW on HANA 2014 2
LG CHEM CO.,LTD. BW on HANA,CO,MM, 2013 1 ASIANA IDT BW on HANA 2014 6
Samsung Corning Precision Materials
BW on HANA 2012 4 Hanwha Advanced Materials Corp. BW on HANA 2014 10
SK ENERGY CO.,LTD.
BW on HANA implementing Asiana Airlines Inc. BW on HANA 2014 9
Daesang Corp.
BW on HANA, CO-PA, implementing Asiana IDT Inc. BW on HANA 2014 5
SK HYNIX INC.
BW on HANA 2014 10 Lotte Confectionary Co. Ltd. BW on HANA, CO-PA, 2014 9
LG Fashion Corp.
BW on HANA 20148 Samsung Techwin BW on HANA 2014 8
AmorePacific Corporation BW on HANA, CO-PA, 20153
SK Telecom Co. Ltd. BW on HANA (accelerator -
VAT Calculation) 2013 3
Hanwha Corp. BW on HANA, CO-PA, 2014 11
GS-CALTEX CORPORATION BW on HANA, CO-PA, 2012 11 Korea Hydro & Nuclear BW on HANA 2014 7
Hanwha Corp. BW on HANA 2013 3 Lotte Chilsung Beverage Co., Ltd. BW on HANA 2015 1
Cheil Worldwide Inc. BW on HANA 2013 9 Lotte Data Communication Company BW on HANA 2014 7
Samsung C&T BW on HANA,CO,PM 2012 5 Samsung Electro-Mechanics Co., Ltd. BW on HANA 2015 2
Samsung Heavy Industry BW on HANA 2012 7 Samsung Electro-Mechanics Co., Ltd. BW on HANA 2015 2
15
BW HANA DB BO
BW Server #1 BO #1 BW Server #2 DB Server #1 DB Server #2
SAN #1
Storage
HA Active
San #2
HA Standby
HANA DB BW
16
17
BW on HANA Database SAP HANA Appliance Server, Application BW AP Server, BI SAP BusinessObjects Server .
Lenovo x3950 X5
CPU: 2.4 GHz * 10 core * 8 socket ( 72 Core)
Memory: 512 GB
O/S: SUSE Linux
SAP HANA Appliance BI
SAP BusinessObjects BI platform 4.2
Suse Linux
BW
SAP Business Warehouse 7.4 SPS14
Suse Linux
DB
SAP HANA 1.0 SPS10
Suse Linux
18
Phase8 Activity
1.
BW
BW / Log Data
Object Activation
PoC
2. DB
O****** DBMS export System Copy Oracle Data HANA DB Import File . (SOFTWARE PROVISIONING MGR)
11
HANA DBMS import BW Export File O***** Data HANA DB . (SOFTWARE PROVISIONING MGR)
4
BW CI BWoH .(Application DB Appliance ) TMS Setup, License Key, Language
3. Post
7.4 SP SAP Netweaver 7.4 SP 7 14 Upgrade Solution Manager Upgrade file Download Notes
8
Upgrade component version . Program
BW Cockpit BW Post-Migration Task
BW (InfoCube) InfoCube , SPO MultiProvider
19
*1,034GB 112GB
1/10
O*****
20
[ : ]
As-is BW on HANA
()
1 HANA Direct 17 2 9 2 - HANA Direct 105 3.5 30 3 HANA Direct 46 2 23 4 HANA Direct 63 2.5 25 6 PL() BW-BICS 39 6 7 7 PL() BW-BICS 49 11 4 8 BS() BW-BICS 74 8 9 9 BS() BW-BICS 66 4.5 15 10 BW-BICS 13 1 13
()
9
30
23
25
7
4
9
15
13
21
[ : ]
SAP
()
Daily
CO 31 8 4
CO 51 5 10
FI 20 3 6
()
4
10
6
22
, ,
IT ( ) ,
BW on HANA ( )
Broad
Deep
High Speed
Simple Real-time IT
AS-IS To-BE
DB BW -> BW on HANA : 2 ~ 5 BW -> HANA : 10~30
: ,
/, 1~2 .
1 / 10 /
5 3 6
BW -> BW on HANA : 2 ~ 5 BW -> HANA : 10~30
6 . ,
23
24
25
Distributor
Distributor
Distributor
X86 SERVER
Linux OS
Storage
Distributor
Storage
Distributor
SERVER
Distributor
SERVER
Server
Storage
Os
Distributor
SERVER
Software CCTV
2016
26
27
.
02-2120-7050
Top Related