 |
 |
| |
 |
|
|
| Contact Details |
GSI Training
900 Green St. Iselin NJ 08830 USA
Toll Free Tel: 1-877-634-9400x10
Off Tel: 732.634.9300x10
Cell: 732-841-4943
Fax: 732.634.9323
E-mail:
harry@gsitraining.net |
| |
|
|
|
| SAP
Netweaver Business Intelligence (BI 7.0)
|
 |
| |
| 1 |
Course
Overview and Data Warehousing Overview: What is BW, OLTP
v/s OLAP, Differences in reporting (Detailed transactional
v/s Summarized history) |
| 2 |
Data
Warehousing Overview – Terminology: Info Objects,
Characteristics, Key figures, Master Data –
Attributes/Texts/Hierarchies, Data source, Info source,
Data Transfer Process (DTP), Data Store objects (formerly:
ODS), Info cubes, Master data in Data Store Objects |
| 3 |
Data
Modeling: BW Extended Star Schema, BW Master Data, Info
Objects, Attributes, Hierarchies, texts.
|
| 4 |
Master
Data loading / via Flat files, to Info Object attributes
texts, Data Store objects, Info cube.
|
| 5 |
Introduction
to Data Warehousing Workbench: DWB Functions, creating an
Info cube, creating data store objects (formerly: ODS
Objects), info objects, info sets and multi providers.
Define transformations (unified transfer & update
rules) and unit conversion. |
| 6 |
OLTP
Extraction / External data extraction: Data extractors,
Data source replication, R/3 Extraction process,
Scheduling jobs in “Job Control” (Previously known as
V3 control), Monitoring, Remote cubes. |
| 7 |
Data
Store Object Functions: Structure of DSO / PSA (Persistent
Staging Area), Data staging in the DSO, Using DSO for
reporting, DSO types – Standard, Direct Update and Write
Optimized. |
| 8 |
Business
Content: Business content components.
|
| 9 |
Production
support: Administration & Monitoring, Error Handling,
BW statistics, Aggregates, Info cube maintenance.
|
| 10 |
Special
topics: Authorizations, Multi providers (and Multi Cubes),
Data Marts.
|
| 11 |
SAP
R/3 Extraction Overview: Extraction process, Types of
extractors, Enhancements to extractors (overview), Delta
management for extractors. |
| 12 |
LO
Data Extraction (LO Cockpit): BW customizing cockpit
(Transaction SBIW => LBWE), Initial Setup, data load
procedure
|
| 13 |
Extraction
from CO-PA: CO-PA Overview, Generating and replicating
Data sources, Creating Info sources, Data transfer. |
| 14 |
Data
extraction from FI-SL: FI-SL Overview, Data structures. |
| 15 |
Generic
Data Extraction: Master data / Transaction data, Data
sources, Extraction types (using Table views, Info set and
Function Module).
|
| 16 |
Enhancing
Business Content: Enhancing data sources for Transaction
data |
| 17 |
Enhancing Business Content: Enhancing datasources for Transaction data /Master
data / Texts, Enhancing data with the Function
enhancements (EXIT_SAPLRSAP_…). |
| 18 |
Delta
Management: Delta management in generic extractors,
Concepts, use of various methods - Time stamp, Calendar
day, Numeric pointer. |
| 19 |
DB
Connect Architecture: DB Connect makes it possible to
extract data from external RDBMS (supported by mySAP
technology). |
| 20 |
Reporting:
Overview of BI 7 query designer, Report designer.
Designing Queries Restricted Key Figures, Calculated Key
Figures, Query Jump, and Variables. |
| 21 |
Reporting:
Report Agent (Executing Reports in the Background),
Exceptions.
|
| 22 |
Web
Reporting: WEB Application Designer, IViews, Web
Templates.
|
|
| Integrated
Planning ( IP ) |
 |
IP functionality using a business scenario
|
|
Data Models (Infocubes, Txn Cubes, Multi-Planning areas) |
|
Planning Models, Methods, functions and Layouts |
|
Planning Applications |
|
|
|
| |
| Certification Tricks and Tips / Case study |
| |
|
