UNWBW1%20

1
BW and BW Reporting Introduduction

• UNWBW1 Business Information
  Warehouse
• NetWeaver Support Consultant Training

2
Content

• Introduction
• Reporting
• Business content
• Data loading
• InfoCube Design
• Aggregates
• BW-BPS Business Planning Simulation
• Monitoring Technical Risks

3
SAP NetWeaver in Detail

• SAP Mobile Infrastructure
• Tight coupling and alignmentwith SAP business
  solutions
• SAP Enterprise Portal
• Business packages
• Collaboration
• SAP Business Information Warehouse
• Business content
• Open architecture (Crystal, Ascential)
• Master Data Management
• SAP Exchange Infrastructure
• Cross-component business processes
• Shared integration knowledge
• SAP Web Application Server
• Proven, scalable, comprehensive toolsets
• Leverage existing infrastructure/skillsets

SAP NetWeaver
People Integration
Composite Application Framework
Life Cycle Management
Multi-Channel Access
Portal
Collaboration
Information Integration
BusinessIntelligence
KnowledgeManagement
Master Data Management
Process Integration
Integration Broker
Business ProcessManagement
Application Platform
J2EE
ABAP
DB and OS Abstraction
DB and OS Abstraction
4
Information-Based Management
How do we get from here . . .
to here?
Knowledge
Data
Results
Information
Realizing business value from transaction data
5
Data Warehouse Definitions

• A collection of integrated, subject-oriented
  databases designed to support the DSS (Decision
  Support System) function, where each unit of data
  is relevant to some moment in time.W. H. Inmon,
  Building the Data Warehouse, 1996, page 371
• A copy of transaction data specifically
  structured for query and analysis.R. Kimball,
  The Data Warehouse Toolkit, 1996, page 310

6
Data Warehouse Objectives

• Standardized structures and representation for
  all enterprise information
• Easy-to-use access, single-point of access to all
  enterprise information
• Self-service, high quality business reporting and
  analysis on all levels
• Fast and cost-effective to deploy
• High performance environment fed from
  heterogeneous sources
• Freed-up systems and IT resources in OLTP
  environment

7
SAP Business Information Warehouse

• Data Warehouse system with optimized structures
  for reporting and analysis
• OLAP engine and tools
• Integrated meta data repository
• Data extraction and data staging
• Preconfigured support for data sources from R/3
  Systems
• BAPIs for data sources from non-SAP systems
• Automated Data Warehouse management
• Administrator Workbench for controlling and
  managing content
• Only one productive client

8
Business Information Warehouse Architecture
Business Explorer
Web Reporting
3rd Party Tools
BusinessInformation WarehouseServer
OLAP processor
Administrator Workbench
Meta DataRepository
Staging Engine
InfoObject
Data Sources
9
OLTP versus OLAP
10
Administrator Workbench (RSA1)
Purpose The Administrator Workbench is the tool
for controlling, monitoring, and maintaining all
of the processes connected with data staging and
processing in the Business Information Warehouse.
Integration The data for the SAP Business
Information Warehouse that has been staged with
the help of the Administrator Workbench can be
evaluated and presented with the Business
Explorer reporting tool.
Functions The Administrator Workbench encompasses
the following functional areas         Metadata
Repository         Installing Business
Content         Modeling        
Administration         Reporting Agent        
Documents         Translating Texts for BW
Objects
11
What is an InfoObject ?

• The various OLTP data models are unified for
  BWBusiness objects / table fields become
  InfoObjects

Table of cost centers
InfoObject 0COSTCENTER
Table of employees
InfoObjects are unique across application
components !
12
Types of InfoObjects

• Characteristics evaluation groups like Cost
  Center, Product group, Material
• Have discrete values stored in their master data
  tables(e.g. the characteristic Region has the
  values North, South, ... )
• Special types of characteristics
• Time characteristics like Fiscal period,
  Calendar year
• Unit characteristics which comprise currencies
  and units of measure like Local currency
• Key figures continuously valued numerical fields
  like amounts and quantities (e.g. Revenue and
  Sales quantity)

13
Master Data tables for Characteristics

• Information about characteristics is stored in
•  Master Data Tables
• Attribute Tables
• Dependent attributes of a characteristic can be
  stored in an Attribute Table for the
  characteristic.
• Text Tables
• Textual descriptions of a characteristic are
  stored in a separate text table.
• External Hierarchy Tables
• Hierarchies of characteristics or attributes may
  be stored in separate hierarchy tables.

Material Attribute Table
MATERIAL_ID
Material GroupMaterial Type
Material Text Table
MATERIAL_ID
Material Name
Material Hierarchy
14
InfoCube

• Central data store for reports and evaluations
• Contains two types of data
• Key figures
• Characteristics
• 2 fact tables and 16 dimension tables
• 3 Dimensions are predefined by SAP
• Time
• Unit
• Packet

15
InfoCube Example
Customer group
Region
North South East
Dept. Stores Wholesale Retail
Glass- Ceramics Plastics Pottery Copper
Pewter ware
Division
16
InfoCube Multi-dimensional analysis
Characteristics
InfoCube
Product group Customer group Division Area Company
code Region Period Profit Center Bus. Area
East
Customer group
Region
South
DeptStores
Wholesale
North
Retail
Glass- ware
Ceramics
Plastics
Division
Analysisof Ceramics division
Analysisof Plastics division
Analysis of Plastics division and Southern
region
East
East
East
Customer group
Customer group
Customer group
Region
Region
Region
South
South
South
DeptStores
DeptStores
DeptStores
Wholesale
Wholesale
Wholesale
North
North
North
Retail
Retail
Retail
Glass- ware
Ceramics
Plastics
Glass- ware
Ceramics
Plastics
Glass- ware
Ceramics
Plastics
Division
Division
Division
17
Operational Data Store

• The BW ODS-Object
• Stores transaction data
• Is a denormalized data structure
• Transparent table
• Not a star schema
• Can hold data that is available for reporting
• Not optimized for query
• performance

18
InfoProvider

• InfoProviders are the objects or views relevant
  to reporting. All BW objects for which queries
  in SAP BW can be created or executed are
  InfoProviders.
• Examples for InfoProviders are
• InfoCubes
• ODS Objects
• MultiProviders
• InfoObjects

19
MultiProvider

• MultiProvider Union of InfoProviders
• homogeneous MultiProvider
• same Characteristics and Key Figures in all
  participating InfoProviders ("partprov")
• example MultiProvider with identical InfoCubes
• InfoCube 1 data for EUROPE
• InfoCube 2 data for ASIA
• InfoCube 3 data for AMERICAS
• purpose partitioning on InfoProvider level
• heterogeneous MultiProvider
• only a subset of common Characteristics
• purposes
• integrating scenarios that share some semantics
• combine differing aggregation levels (e.g. plan
  actual scenarios)
• tackle sparse tables

20
MultiProvider Example
MultiProvider
Basic Cube
Basic Cube
21
Queries
A query is a collection of characteristics and
key figures (InfoObjects) for the analysis of the
data of an InfoProvider. A query always refers
exactly to one InfoProvider, whereas you can
define as many queries as you like for each
InfoProvider.
22
Content

• Introduction
• Reporting
• Business content
• Data loading
• InfoCube Design
• Aggregates
• BW-BPS Business Planning Simulation
• Monitoring Technical Risks

23
Business Information Warehouse Architecture
Business Explorer
Web Reporting
3rd Party Tools
BusinessInformation WarehouseServer
OLAP processor
Administrator Workbench
Meta DataRepository
Persistent Staging Engine
InfoObject
Data Sources
24
Query Design

• BEx Query Designer
• Ease-of use via drag drop
• Personalized access
• Comfortable formula editor for calculations
• One-step web publishing
• Windows-based component
• Web interface for intuitive ad-hoc analysis on
  the web

Only Filter and Column Section in tabular mode
25
Business Explorer Analyzer
Windows Start menu ? Programs ? Business Explorer
? Analyzer
You may choose a single query or a
workbook,which executes several queries at once.
26
Web Reporting
Queries can be published to the Web using the
BEx, accessible then via URL
If the standard webtemplate does not
fitcustomer may use theBEx Web Application
Designer to change the template
27
Reporting - Integration with Crystal Reports

• Reports and documents optimized for printing and
  Sharing ? here we go, thats the main reason for
  using crystal
• Out of the box presentation-quality reporting
• Broad range of pre-defined crystal reports
  legal, financial, etc
• SAP and non-SAP data in a singlereport
• Seamless portal integration
• Schedule and view Crystal reports in managed web
  environment
• Offline reporting and viewing of reports

28
BI Suite Business Explorer (BEx) 3.5
Portal Integration
29
Key Functions Information Broadcasting

• Information Broadcasting allows the distribution
  of BI information
• ... via different channels ...
• (?) E-Mail (works independently from an EP
  installation)
• (?) Enterprise Portal
• ... in different formats ...
• (?) HTML, MHTML
• (?) BEx Analyzer Workbooks
• (?) ZIP Files
• of different sources
• (?) BI Web Applications - Dashboards, cockpits
• (?) BEx Analyzer Workbooks
• (?) Queries
• in different modes
• (?) Online pre-calculated

30
Key Functions Information Broadcasting

• Information Broadcasting supports different
  business scenarios
• (?) Event based (Intelligent push)
• Integration into process chains
• E.g If new data is loaded into the data
  container (InfoCube)
• (?) Ad hoc
• BEx Broadcasting Wizard for one-step distribution
• (?) Scheduled
• BEx Broadcaster
• Guided scheduling times (for end users /
  information consumers)
• Ensures system performance because of better load
  balancing
• Scheduling at any time (for power users /
  administrators)
• Create scheduling slots for specific user groups
• No time restriction and no target restriction
• Create pre-calculations based on the data
  authorizations of the target user