Sapbi BBP
Sapbi BBP
Sapbi BBP
1.
1.2.
1.3.
2.
2.1.
2.2.
3.
3.1.
3.2.
Executive Summary.........................................................................................................7
Objective........................................................................................................................................7
Benefits..........................................................................................................................................7
Project Scope...................................................................................................................7
Deliverables Considered In Scope..............................................................................................7
Deliverables Considered Out of Scope.......................................................................................8
4.
Approach...........................................................................................................................9
5.
5.1.
5.2.
5.3.
5.4.
5.5.
6.
6.1.
6.2.
6.2.1.
6.2.2.
6.2.3.
6.3.
6.3.1.
6.3.2.
6.3.3.
6.3.3.1.
6.3.3.2.
7.
7.1.
8.
8.1.
9.
9.1.
9.2.
9.3.
9.4.
11.
11.1.
11.2.
11.3.
11.4.
12.
12.1.
12.2.
12.3.
12.4.
12.5.
12.6.
12.7.
12.8.
12.9.
12.10.
12.11.
12.12.
12.13.
12.14.
12.15.
Page 2 of 21
Key Figure....................................................................................................................................22
Master Data.................................................................................................................................22
Meta Data....................................................................................................................................22
Monitor.........................................................................................................................................22
OLAP...........................................................................................................................................23
OLTP............................................................................................................................................23
Operational Data Store................................................................................................................23
Primary Key.................................................................................................................................23
Query...........................................................................................................................................23
Relational Integrity.......................................................................................................................23
Scheduler.....................................................................................................................................23
Source System.............................................................................................................................23
Star Schema................................................................................................................................24
Table of Pictures
Picture 1: Layout of KPI Dimension Matrix................................................................................10
Picture 2: SAP BI ECC System Landscape Strategy................................................................12
Picture 3: Sample Process Flow....................................................................................................13
Picture 4: Finance Data Flow in BI.................................................................................................17
Picture 5: Material Management Data Flow in BI..........................................................................18
Picture 6: Sales & Distribution Data Flow in BI............................................................................19
Picture 7: Productin Planning Data Flow in BI.............................................................................19
Page 3 of 21
2. Project Scope
2.1. Deliverables Considered In Scope
The following actions and deliverables are considered within the scope of the BI-POC project:
1.
Functional Areas Involved:
a. Material Management
b. Production Planning
c. Finance
Page 4 of 21
Identifying the Key Performance Indicator (KPI) metrics and the dimensions with
the functional areas involved.
The extraction and one time load from Lancos ECC systems of all relevant detail
and master data from the different data sources, to a historical depth subject to
data availability or other project team defined constraints.
The design and development of BI-POC InfoCubes that will provide efficient and
effective end users access to the identified KPIs in each functional area.
Define ETL Strategy for the SAP BI Info Providers and the respective Master / Text
Data.
Performance Tuning of the SAP BI the defined data model and the ETL flow.
The establishment of a technical environment supporting Business Intelligence
processing, including the client landscape, transport management processes,
desktop client management, naming conventions, distributed printing, security
administration and end user and technical standards and procedures.
Development in the functional areas other than MM, PP, FI and SD.
Devolopment of BEx reports on top of the InfoProviders that are built.
Training on SAP BI Developments.
Page 5 of 21
4. Approach
SAP BI team will conduct workshop to Lanco Industries senior management introducing
the advantages and the best practices.
Meeting the heads of each department along with their Module Leads building the
understanding on SAP BI and its features.
Understanding the requirement of HODs with the help of respective Module Leads.
Identifying the KPIs and the Dimensions in each functional area with the help of the
requirements given by Module Leads
On receiving the initial requirement from the departments, prepare the KPI-Dimension
Matrix for each department.
Review of KPI-Dimension Matrix along with respective Module Leads and finalize.
Review of KPI-Dimension Matrix with the Process Owner of Lanco Industries
For the identified KPI-Dimension Matrix, collect the source field information and the
formulae to build the data model in SAP BI.
Bridge the gaps and freeze the requirements with the help of Module Leads.
Develop the InfoCubes in SAP BI according to the finalized requirements.
Page 6 of 21
Purpose
Logical System
Name
Source System
BID
Development (DEV)
BIDCLNT444
BIQ
BIQCLNT555
BIP
Production (PRD)
BIPCLNT666
Page 7 of 21
Page 8 of 21
Source Locations:
Applicaton Server: There is a provision given in SAP BI to maintain the Flat Files.
Respective file path should be identified while loading a particular file into the data
targets. Files located in the application server can also be loaded in background.
Also the files can be globally accessible from any client work station.
Client Work Station: Other than the application server, we can also maintain them in the
clients work station. But the background scheduling is not possible in this scenario.
Moreover, files located in the client work station are not globally accessible.
Page 9 of 21
Page 10 of 21
Object Name
0CUSTOMER
0MATERIAL
0VENDOR
0PLANT
0SALESORG
0SOLD_TO
0CUST_GROUP
0STOR_LOC
0COMP_CODE
0MATL_GROUP
Description
Customer
Material
Vendor
Plant
Sales Organization
Sold to Party
Customer group
Storage Location
Company Code
Material group
Page 11 of 21
Object Name
Description
0GL_ACCOUNT
0CHRT_ACCTS
0PRODORDER
0S_OPERAT
0WORKCENTER
0WAGEGR
0PERSON
0DT_ELEMENT
0PRODORDER
0DOC_NUMBER
G/L Account
Chart of accounts
Manufacturing Order
Suboperation
Work Center/Resource
Wage Group
Person
Downtime Element
Manufacturing Order
Sales document
10.2.Tansaction Data
Transaction data is also called as historical data about the facts with respect to a functional area.
Ex: Sales Orders, Material Movements, Payments, Rceipts etc..
Transaction data is maintained in various InfoProviders in SAP BI. Data to loaded to these
InfoProviders from the DataSources that exist in the Source System.
10.3.Finance (FI):
10.3.1. FI InfoProviders
Sl No
1
2
3
4
5
6
7
8
Object Type
Object Name
InfoCube
InfoCube
InfoCube
DSO
InfoCube
InfoCube
InfoCube
InfoCube
0FIGL_C10
0FIGL_V10
0FIAP_C03
0FIAP_O03
0FIAR_C03
0FIAR_C05
0FIAR_C02
0FIAA_C03
Description
General Ledger (New): Transaction Figures
G/L (New): Balance Sheet and Profit and Loss
FIAP: Line Item
FIAP: Line item
FIAR: Line Item
FIAR: Payment History
FIAR: Transaction Data
FIAA: Transactions
10.3.2. FI DataSources
Sl No
1
2
3
4
5
6
7
8
Object Name
0FI_AR_3
0FI_AR_4
0FI_AR_5
0FI_AR_6
0FI_AR_1
0FI_GL_10
0FI_AP_3
0FI_AP_4
Description
Customers: Line Items
Customers: Line Items with Delta Extraction
Customers: Payment History
Customer Sales Figures via Delta Extraction
Customers: Transaction figures
General Ledger: Leading Ledger Balances
Vendors: Line Items
Vendors: Line Items with Delta Extrcation
Page 12 of 21
Object Type
Object Name
InfoCube
InfoCube
InfoCube
DSO
DSO
0SD_C01
0SD_C02
0SD_C03
0SD_O01
0SD_O06
Description
Customer
Deliveries
Sales: Overview
Order Items
Billing: Condition Data
10.4.2. SD DataSources
Sl No
1
2
3
4
5
6
7
8
Object Name
Description
2LIS_11_VAHDR
2LIS_11_VAITM
2LIS_12_VCHDR
2LIS_12_VCITM
2LIS_13_VDHDR
2LIS_13_VDITM
2LIS_11_VAKON
2LIS_13_VDKON
Object Type
Object Name
InfoCube
MultiProvider
InfoCube
0IC_C03
0IC_MP04
0PUR_C01
Description
Material Stocks/Movements (as of 3.0B)
Material Stocks/Movements
Purchasing Data
Object Name
Description
2LIS_03_BF
2LIS_03_BX
2LIS_03_UM
2LIS_02_SCL
2LIS_02_HDR
Object Type
Object Name
InfoCube
InfoCube
L1CBPP001
0PP_C05
Description
Production Analysis
Plan/Actual Comparison Material Consumption
Page 13 of 21
Object Name
2LIS_04_P_MATNR
2LIS_04_P_ARBPL
Description
Material View from PP/PP-PI
Work Center View from PP/PP-PI
Note: Objects in the above mentioned list are subject to customization or change during
realization.
Page 14 of 21
Page 15 of 21
Page 16 of 21
Page 17 of 21
Page 18 of 21
Page 19 of 21
Page 20 of 21
Page 21 of 21