Features
& Functions
of SAP Business
Information Warehouse
(SAP BIW)
Business
Information Warehouse
(sometimes shortened
to "Business
Warehouse"
or BW) is a packaged,
comprehensive
business intelligence
product centered
around a data
warehouse that
is optimized for
(but not limited
to) the R/3 environment
from SAP. Like
most data warehouses,
BW is a combination
of databases &
database management
tools that are
used to support
management decision
making. It supplies
the infrastructure
typical of data
warehouses, but
also includes
preconfigured
data extractors,
analysis &
report tools,
& business
process models.
Among the other
features of BW
are: Business
Application Programming
Interfaces (BAPIs)
that enable connections
to non-R/3 applications;
preconfigured
business content;
an integrated OLAP processor;
automated data
extraction &
loading routines;
a metadata repository;
administrative
tools; multiple
language support;
& Business
Explorer, a Web-based
user interface.
Program:
SAP Business Information
Warehouse (SAP
BIW or SAP BW/BI)
Part
I: Basics of Business
Warehousing
This part of the
course gives a
complete understanding
of how BW works,
how data is brought
into it from R/3
and Flat files
& the organization
of different components
of BW. It lays
a firm foundation
for anyone to
start off on a
BW assignment
& enforce
their learning
further on the
job through largely
self learning
Basics of Data
warehousing &
Multi-Dimensional
Modeling
SAP BW &
its Components,
Plug In For R/3
Setting Up the
R/3 & BW Link
-Customizing settings
- Business
Content
- Implementing
Business Content-Customizing
- Extracting
Business Content
Based Data From
R/3
- Data Source
and Transfer
Structures &
Replication
- Setting Up
The Source Systems
- Info Objects,
types, standard
& custom
info objects
- Master Data
Info objects
- Extracting
Business Content
Master Data
from R/3
- Flat File
Extractors For
Master Data
Part
II: Data Extraction
into Business
Warehousing From
R/3 & Flat
File Systems
This
part of the course
gives an in depth
knowledge, understanding
of how BW extraction
works, various
ways & means
of bringing in
data to it from
R/3 and Flat files.
- Delta Loading
- Extraction
from R/3
- Delta Extraction
- Logistics
Extraction Using
LIS Structures
(SD, MM, PP
etc.)
- Logistics
Extraction Using
LO Cockpit (SD,
MM, PP etc.)
- FI, CO-PA
, SPL, R/3 Custom
Tables Extraction
- Data Loading
Administration
and Customizing
- Sequencing
of Data Load
– Tips
& Tricks
- Extractor
checking, Data
Loading &
Monitoring Tools
- Performance
Bottle Necks
in R/3 &
BW, ways &
means to improve
performance
- Info package
Groups
- Statistics
on BW
- Data Compression
Part
III. Authorizations
- Authorizations
- Authorization Objects
- Roles
Part
IV. Reporting - The Purpose of BW
This part of the
course gives an
overview knowledge,
understanding
of how reports
are built, how
query creation
is dependent on
ODs and Info cube
Design, Queries
on Multi-Cubes.
- Reporting
using Bex Analyzer,
Bex Browser
- Settings on
Info objects,
Data Targets
for queries
- Queries
- Calculations
& Formula
Builder
- Different
Types Of Key
Figures
- Filters
- Conditions
- Variables
- Settings For
Queries
- Multiple Queries
- Workbook Templates
- Formatting,
Graphs &
Charts in Queries
- Geo-Coding
- Query Performance
& Tools
- Bex Browser
Part
V. Implementation
- Procedure for Project
- Project Organization
- Project Phases
- Requirement Analysis
Part
VI. Advanced Topics: Performance Tuning and SEM
- Performance Improvement
- Aggregation, Indexes
- Partition
- Real Project Walkthrough
- Introduction to SEM
Want to learn
more about our
training program
contact us at
972-713-1732/972-713-1702
or
Email: info@acesap.com.
|
