![Page 1: OBT Global presents - ERP · PDF filezGeneral Overview zArchitecture Overview ... comprising data extractors, ... Business Content Examples. 6/19/2009 8 Benefits of BW](https://reader034.vdocuments.us/reader034/viewer/2022051507/5a7523997f8b9aa3688c3edf/html5/thumbnails/1.jpg)
SAP Business Information Warehouse
-an overview -
OBT Global presents …….
![Page 2: OBT Global presents - ERP · PDF filezGeneral Overview zArchitecture Overview ... comprising data extractors, ... Business Content Examples. 6/19/2009 8 Benefits of BW](https://reader034.vdocuments.us/reader034/viewer/2022051507/5a7523997f8b9aa3688c3edf/html5/thumbnails/2.jpg)
6/19/2009 2
Contents
General Overview
Architecture Overview
Reporting Overview
![Page 3: OBT Global presents - ERP · PDF filezGeneral Overview zArchitecture Overview ... comprising data extractors, ... Business Content Examples. 6/19/2009 8 Benefits of BW](https://reader034.vdocuments.us/reader034/viewer/2022051507/5a7523997f8b9aa3688c3edf/html5/thumbnails/3.jpg)
6/19/2009 3
General Overview
![Page 4: OBT Global presents - ERP · PDF filezGeneral Overview zArchitecture Overview ... comprising data extractors, ... Business Content Examples. 6/19/2009 8 Benefits of BW](https://reader034.vdocuments.us/reader034/viewer/2022051507/5a7523997f8b9aa3688c3edf/html5/thumbnails/4.jpg)
6/19/2009 4
BW is SAP's Data Warehouse offering.
BW replaces selected R/3 information systems over a period of time.
End to End open DW Solution – all in one package comprising data extractors, administrator workbench, OLAP engine and a graphical user interface.
Pre-configured for the needs of the business users
Delivered Cubes, reports, templates
BW Defined
![Page 5: OBT Global presents - ERP · PDF filezGeneral Overview zArchitecture Overview ... comprising data extractors, ... Business Content Examples. 6/19/2009 8 Benefits of BW](https://reader034.vdocuments.us/reader034/viewer/2022051507/5a7523997f8b9aa3688c3edf/html5/thumbnails/5.jpg)
6/19/2009 5
BW Defined (cont‘d)
Front-End (BEx Analyzer)- provides access to the data via internet, intranets or extranets.
Presentation backend is MS Excel
Open solution that allows data to be loaded from practically any source or system, including 3rd party systems and legacy applications. You can also use 3rd party extracting / reporting tools via BAPI’s.BW changes the focus from Build to Buy
Provides faster integration and implementation
![Page 6: OBT Global presents - ERP · PDF filezGeneral Overview zArchitecture Overview ... comprising data extractors, ... Business Content Examples. 6/19/2009 8 Benefits of BW](https://reader034.vdocuments.us/reader034/viewer/2022051507/5a7523997f8b9aa3688c3edf/html5/thumbnails/6.jpg)
6/19/2009 6
BW is the heart of mySAP.com
ManagementCockpit
SAP BusinessTo Business
SAP Service
SAPBusiness
InformationWarehouse
Info DB
SAP AdvancedPlanner&Optimizer
R/3
SAP LogisticsExecution
System
SAPStrategic
EnterpriseManagement
SAP Business Intelligence Initiative
SAP Business Intelligence Initiative
SAP Marketing
SAP Supply Chain Management InitiativeSAP Supply Chain
Management Initiative
SAP Sales
SAP Customer Relationship Management Initiative
SAP Customer Relationship Management Initiative
![Page 7: OBT Global presents - ERP · PDF filezGeneral Overview zArchitecture Overview ... comprising data extractors, ... Business Content Examples. 6/19/2009 8 Benefits of BW](https://reader034.vdocuments.us/reader034/viewer/2022051507/5a7523997f8b9aa3688c3edf/html5/thumbnails/7.jpg)
6/19/2009 7
FinanceFinance
Accounts Receivable
Accounts Payable
General Ledger
Special Ledger
Profitability Analysis
Product Costing
Overhead Mgmt
Profit Center Account.
ControllingControllingSales & Distribution
Purchasing
Inventory Mgmt
Warehouse Mgmt
Manufact. Req. Plan.
LogisticsLogistics
Time Management
Personnel Admin.
Human ResourcesHuman Resources
Payroll
Business Content Examples
![Page 8: OBT Global presents - ERP · PDF filezGeneral Overview zArchitecture Overview ... comprising data extractors, ... Business Content Examples. 6/19/2009 8 Benefits of BW](https://reader034.vdocuments.us/reader034/viewer/2022051507/5a7523997f8b9aa3688c3edf/html5/thumbnails/8.jpg)
6/19/2009 8
Benefits of BW
No longer necessary to configure LIS
Removes reporting overhead from the R/3 system
No need to use COPA on R/3
Provides a robust reporting environment
![Page 9: OBT Global presents - ERP · PDF filezGeneral Overview zArchitecture Overview ... comprising data extractors, ... Business Content Examples. 6/19/2009 8 Benefits of BW](https://reader034.vdocuments.us/reader034/viewer/2022051507/5a7523997f8b9aa3688c3edf/html5/thumbnails/9.jpg)
6/19/2009 9
SAP BWSAP BW
Eliminates need to
decipher and build custom SAP extracts
Capability for On Line Analytical
Processing(OLAP)
Pre-built SAP templates
for R/3 systemsSimplifies
data warehouse management &administration
Reduces time for
data warehouse implementation
in SAPEnvironment
Compatible with other
applications and ERP systems
Automatic data
extraction
Advantages of SAP - BW
![Page 10: OBT Global presents - ERP · PDF filezGeneral Overview zArchitecture Overview ... comprising data extractors, ... Business Content Examples. 6/19/2009 8 Benefits of BW](https://reader034.vdocuments.us/reader034/viewer/2022051507/5a7523997f8b9aa3688c3edf/html5/thumbnails/10.jpg)
6/19/2009 10
Architecture Overview
![Page 11: OBT Global presents - ERP · PDF filezGeneral Overview zArchitecture Overview ... comprising data extractors, ... Business Content Examples. 6/19/2009 8 Benefits of BW](https://reader034.vdocuments.us/reader034/viewer/2022051507/5a7523997f8b9aa3688c3edf/html5/thumbnails/11.jpg)
6/19/2009 11
SAP BW Architecture
![Page 12: OBT Global presents - ERP · PDF filezGeneral Overview zArchitecture Overview ... comprising data extractors, ... Business Content Examples. 6/19/2009 8 Benefits of BW](https://reader034.vdocuments.us/reader034/viewer/2022051507/5a7523997f8b9aa3688c3edf/html5/thumbnails/12.jpg)
6/19/2009 12
BW Architecture
InfoCubesODS
InfoCubesODS
OLAP ProcessorOLAP Processor
Meta Data ManagerMeta Data Manager
R/3 OLTP ApplicationsR/3 OLTP Applications
PSAPSA
OLTP Reporting
OLTP Reporting
Production DataExtractor
Production DataExtractor
Business Explorer
BW Server
BAPIBAPI
Staging EngineStaging Engine
BEx Analyzer (hosted by MS Excel)
BEx Analyzer (hosted by MS Excel)
Meta DataRepositoryMeta DataRepository
Administrator Workbench
AdministrationAdministration
SchedulingScheduling
MonitorMonitor
Data ManagerData Manager
Business Explorer BrowserBusiness Explorer Browser
Non R/3 Production Data Extractor
Non R/3 Production Data Extractor
Non R/3 OLTP ApplicationsNon R/3 OLTP Applications
3rd party OLAP client
3rd party OLAP client
ODBOODBO
BDSBusinessDocument Service
Web BrowserWeb Browser Web Design ToolWeb Design Tool
SAP Internet Transaction Server
SAP Internet Transaction Server
BW WebServiceBW WebService
Publish views
Save HTML Templates
![Page 13: OBT Global presents - ERP · PDF filezGeneral Overview zArchitecture Overview ... comprising data extractors, ... Business Content Examples. 6/19/2009 8 Benefits of BW](https://reader034.vdocuments.us/reader034/viewer/2022051507/5a7523997f8b9aa3688c3edf/html5/thumbnails/13.jpg)
6/19/2009 13
Reporting Architecture
![Page 14: OBT Global presents - ERP · PDF filezGeneral Overview zArchitecture Overview ... comprising data extractors, ... Business Content Examples. 6/19/2009 8 Benefits of BW](https://reader034.vdocuments.us/reader034/viewer/2022051507/5a7523997f8b9aa3688c3edf/html5/thumbnails/14.jpg)
6/19/2009 14
Business Explorer
![Page 15: OBT Global presents - ERP · PDF filezGeneral Overview zArchitecture Overview ... comprising data extractors, ... Business Content Examples. 6/19/2009 8 Benefits of BW](https://reader034.vdocuments.us/reader034/viewer/2022051507/5a7523997f8b9aa3688c3edf/html5/thumbnails/15.jpg)
6/19/2009 15
Business Explorer (BEx)This is the reporting tool of the BW. The
Business Explorer consists of the Business Explorer Analyzer and the Business Explorer
Browser.
Business Explorer Browser(BEx Browser)stores workbooks, links and documents;locates queries,preview s and executes workbooks ; selects the documents assigned to you , opens and organizes the documents
Business Explorer Analyzer (BEx Analyzer)defines queries; creates different views in the queries; analyzes and presents InfoCube data; saves the queries in workbooks;
Business Explorer (BEx)
![Page 16: OBT Global presents - ERP · PDF filezGeneral Overview zArchitecture Overview ... comprising data extractors, ... Business Content Examples. 6/19/2009 8 Benefits of BW](https://reader034.vdocuments.us/reader034/viewer/2022051507/5a7523997f8b9aa3688c3edf/html5/thumbnails/16.jpg)
6/19/2009 16
BW OLAP - Business Explorer Functionality
• Role Based Security
– A role is a list of activities / tasks that a person is responsible for.
• BEx Analyzer– Result set can be used for input into another query.– Provides robust Condition processing.
• Reporting Agent – Allows for background printing.– Allows for SAP office mail exception notification.
![Page 17: OBT Global presents - ERP · PDF filezGeneral Overview zArchitecture Overview ... comprising data extractors, ... Business Content Examples. 6/19/2009 8 Benefits of BW](https://reader034.vdocuments.us/reader034/viewer/2022051507/5a7523997f8b9aa3688c3edf/html5/thumbnails/17.jpg)
6/19/2009 17InfoCube
Report (Cube)
Report viewsReport Viewer
Presentation ServerPresentation Server
Application ServerApplication Server
Database ServerDatabase Server
OLAP Processoroperates on ...
request
answer
Report Builder
Stored in
PowerPlay
Stored in (optional)
ODBO
StarStarSchemaSchema
PersistentPersistentCacheCache
CognosBusiness Explorernavigates on ...
"Thin client architecture"
BW Architecture - Layers
![Page 18: OBT Global presents - ERP · PDF filezGeneral Overview zArchitecture Overview ... comprising data extractors, ... Business Content Examples. 6/19/2009 8 Benefits of BW](https://reader034.vdocuments.us/reader034/viewer/2022051507/5a7523997f8b9aa3688c3edf/html5/thumbnails/18.jpg)
6/19/2009 18
BEx Analyzer Functionality
• Report to Report Interface -Allows the user to jump from report to report or jump through to R/3 from BW.
• Geographical Information System (GIS) -Allows the user to integrate a Map, which shows the key-figures of the corresponding Query of the BEx-Analyzer as colored / shaded Areas. You can also display location of Master Data in the map.
![Page 19: OBT Global presents - ERP · PDF filezGeneral Overview zArchitecture Overview ... comprising data extractors, ... Business Content Examples. 6/19/2009 8 Benefits of BW](https://reader034.vdocuments.us/reader034/viewer/2022051507/5a7523997f8b9aa3688c3edf/html5/thumbnails/19.jpg)
6/19/2009 19
Data Targets in BW
• Basic Infocube-- Stores multidimensional aggregated data
• Multi-Cube– Combines several traditional cubes
• Remote Cube– Is an infocube, which the transactional data is not stored
in BW, but external data areas– Only the structure is stored in BW– Data is read via BAPI’s from external system– This is helpful in provide real-time data to users
• ODS– Can be drilled down to from the Infocube– Directly reported against using BEx Analyzer
![Page 20: OBT Global presents - ERP · PDF filezGeneral Overview zArchitecture Overview ... comprising data extractors, ... Business Content Examples. 6/19/2009 8 Benefits of BW](https://reader034.vdocuments.us/reader034/viewer/2022051507/5a7523997f8b9aa3688c3edf/html5/thumbnails/20.jpg)
6/19/2009 20
BEx Analyzer: Executed report
Drilldown possible on all these fields in any
order
![Page 21: OBT Global presents - ERP · PDF filezGeneral Overview zArchitecture Overview ... comprising data extractors, ... Business Content Examples. 6/19/2009 8 Benefits of BW](https://reader034.vdocuments.us/reader034/viewer/2022051507/5a7523997f8b9aa3688c3edf/html5/thumbnails/21.jpg)
6/19/2009 21
BEx Analyzer: Executed report
Drilldown on Sold-to-party
![Page 22: OBT Global presents - ERP · PDF filezGeneral Overview zArchitecture Overview ... comprising data extractors, ... Business Content Examples. 6/19/2009 8 Benefits of BW](https://reader034.vdocuments.us/reader034/viewer/2022051507/5a7523997f8b9aa3688c3edf/html5/thumbnails/22.jpg)
6/19/2009 22
BEx Analyzer: Executed report
Drilldown on Country. Multi-level is possible in
all cases
![Page 23: OBT Global presents - ERP · PDF filezGeneral Overview zArchitecture Overview ... comprising data extractors, ... Business Content Examples. 6/19/2009 8 Benefits of BW](https://reader034.vdocuments.us/reader034/viewer/2022051507/5a7523997f8b9aa3688c3edf/html5/thumbnails/23.jpg)
6/19/2009 23
BEx Analyzer: Executed report
Drilldown on Country & Material Group
![Page 24: OBT Global presents - ERP · PDF filezGeneral Overview zArchitecture Overview ... comprising data extractors, ... Business Content Examples. 6/19/2009 8 Benefits of BW](https://reader034.vdocuments.us/reader034/viewer/2022051507/5a7523997f8b9aa3688c3edf/html5/thumbnails/24.jpg)
6/19/2009 24
BEx Analyzer: Executed report
Bar-chart presentation
![Page 25: OBT Global presents - ERP · PDF filezGeneral Overview zArchitecture Overview ... comprising data extractors, ... Business Content Examples. 6/19/2009 8 Benefits of BW](https://reader034.vdocuments.us/reader034/viewer/2022051507/5a7523997f8b9aa3688c3edf/html5/thumbnails/25.jpg)
6/19/2009 25
BEx Analyzer: Executed report
Pie-chart presentation
![Page 26: OBT Global presents - ERP · PDF filezGeneral Overview zArchitecture Overview ... comprising data extractors, ... Business Content Examples. 6/19/2009 8 Benefits of BW](https://reader034.vdocuments.us/reader034/viewer/2022051507/5a7523997f8b9aa3688c3edf/html5/thumbnails/26.jpg)
6/19/2009 26
Web Reporting
InfoCubesODS
InfoCubesODS
OLAP ProcessorOLAP Processor
Meta Data ManagerMeta Data Manager
R/3 OLTP ApplicationsR/3 OLTP Applications
PSAPSA
OLTP Reporting
OLTP Reporting
Production DataExtractor
Production DataExtractor
Business Explorer
BW Server
BAPIBAPI
Staging EngineStaging Engine
BEx Analyzer (hosted by MS Excel)
BEx Analyzer (hosted by MS Excel)
Meta DataRepositoryMeta DataRepository
Administrator Workbench
AdministrationAdministration
SchedulingScheduling
MonitorMonitor
Data ManagerData Manager
Business Explorer BrowserBusiness Explorer Browser
Non R/3 Production Data Extractor
Non R/3 Production Data Extractor
Non R/3 OLTP ApplicationsNon R/3 OLTP Applications
3rd party OLAP client
3rd party OLAP client
ODBOODBO
BDSBusinessDocument Service
Web BrowserWeb Browser Web Design ToolWeb Design Tool
SAP Internet Transaction Server
SAP Internet Transaction Server
BW WebServiceBW WebService
Publish views
Save HTML Templates
![Page 27: OBT Global presents - ERP · PDF filezGeneral Overview zArchitecture Overview ... comprising data extractors, ... Business Content Examples. 6/19/2009 8 Benefits of BW](https://reader034.vdocuments.us/reader034/viewer/2022051507/5a7523997f8b9aa3688c3edf/html5/thumbnails/27.jpg)
6/19/2009 27
Web Reporting: Executed report
Publishing on Web is readily
possible !
Drilldowns, selections, sorting etc. are provided
for interactive use ! Access authorizations
ensure data security !
![Page 28: OBT Global presents - ERP · PDF filezGeneral Overview zArchitecture Overview ... comprising data extractors, ... Business Content Examples. 6/19/2009 8 Benefits of BW](https://reader034.vdocuments.us/reader034/viewer/2022051507/5a7523997f8b9aa3688c3edf/html5/thumbnails/28.jpg)
6/19/2009 28
Web Reporting: Executed report
Report with multi-level drilldown