sap bi training
TRANSCRIPT
SAP – Business Intelligence / Analytics
GET TRAINED BY INDUSTRY EXPERTS.
TRAINING BASED ON REAL-TIME SCENARIOS.
HANDS ON EXPERIENCE ON REAL-TIME PROJECTS.
RIGOROUS ASSESSMENTS & INTERVIEWS.
COMMUNICATION & PERSONALITY DEVELOPMENT SESSIONS.
Contact Details:
Ph: 09582320999, 040 – 65409997
Mail: [email protected] Website: www.airysol.com www.sapstreet.com
Unit 1 - SAP ERP Overview 1 hours
Understanding ERP(Enterprise Resource Planning) and SAP ERP (ECC 6.0)
Why SAP ? What’s the use of a ERP Software
Difference bitween OLAP and OLTP
Different SAP ERP Modules SD, FI, HR
Unit 2 - SAP BW Overview 2 hours
Understaing DW/ BW and what’s the speciality of SAP BW
Fundamentals of Data Warehousing and Business Intelligence.
SAP NetWeaver Business Intelligence (BW) Overview
SAP NetWeaver Solution Delivery: IT Practices, Scenarios, and Usage Types
SAP NetWeaver Business Intelligence: Data Warehousing
Other BI Tools Available in Market (Informatica, Cognos, OBIEE, Hyperion)
SAP BW / BI Release
GUI 6.20
ABA 6.20
Web AS 6.20
Kernel 6.20
BW 3.1
BI CONT 3.10
BI CONT 3.20
BI CONT 3.30
GUI 6.40
ABA 6.40
Web AS 6.40
Kernel 6.40
BW3.5
BW 3.5
BI CONT 3.5.1
BI CONT 3.5.2
BI CONT 3.5.3
BW3.1 / (BW 3.0)
GUI 7.00
ABA 7.00
Web AS 7.00
Kernel 7.00
BW 7.0
BW 7.00
BI CONT 7.0.1
BI CONT 7.0.2
BI CONT 7.0.3
GUI 7.10
ABA 7.10
Web AS 7.10
Kernel 7.10
BW 7.3
BW 7.10
BI CONT 7.1.1
BI CONT 7.1.2
BI CONT 7.1.3
SAP BW ARCHITECTURE
SAP BW ARCHITECTURE
Unit 3 - Modelling 6 Hours
Objects in the BW Data Warehouse Layer
Data Warehousing Workbench.
InfoProviders: Business Purpose
InfoObjects: Characteristics (Attribute,Text,Hier)
InfoObjects: Key Figures
The BI InfoCube: An Extended Star Schema
Creating InfoCubes (Fact, Dimension, SID Tables)
Exercise
Look and Feel with Navigations
SAP BW Info Provider
SAP InfoCube types SAP
BusinessObjects
Basic InfoCubes –
data and metadata are
physically stored in the same
SAP BW system
Standard InfoCubes – optimized for read access
while allowing scheduled uploads
Supported
Transactional InfoCubes – designed for
applications, such as budgeting and planning, that
require read and write-back access
Supported
Remote InfoCubes – data is physically stored on a remote system, usually R/3 (it
can also be another BW system or any 3rd-party/custom system supporting the
remote InfoCube BAPI)
Supported
InfoCubes
Contains two types of data Key figures
Characteristics
Can contain up to one fact table and 16 dimension tables
Each dimension table = max. 256 characteristics
Three dimensions are predefined by SAP Time
Unit
Packet
Unit 4 - Data Acquisition 8 Hours
Data Acquisition and Transformation from SAP Source Systems
Data Flow: Overview - Data Source, Info Source..
Loading Master Data from an SAP Source System
Loading Transaction Data from an SAP Source System
ETL Processes and Loading Hierarchies
PSA, Source Systems
•Info Source
•Info Package
•Transfer Rules
•Update Rules
•Transformation
•Data Transfer Process
Exercise
DataSource
Dataflow Overview
Source System 1 Source System 2
Transfer Rules Transfer Rules
InfoSource
Communication Structure
Extract Structure Extract Structure
DataSource (Replicate) Transfer Structure
Transfer Structure
Transfer Structure
Transfer Structure
Transfer Structure
Communication Structure
Extract Structure
Transfer Structure
Transfer Rules
InfoSource
Transfer Structure
Extract Structure
Transfer Structure
Transfer Rules
ODS
Object
new with BW 3.0 Update Rules Update Rules
Transformation and DataSource
A Transformation is used to consolidate, cleanse, and integrate data. The fields of the source are converted into the fields of the target
Fields of the data source Fields of the data target Fields that are delivered from the source system
A Data Source is defined to specify which kind of data is to be uploaded from the source system
Data Transfer Process and InfoPackage
InfoPackages are used to upload data from the source systems into PSA (that is assigned to the DataSource); once a DTP is in place, all other processing options are not available (grayed out)
Data transfer processes are used to transfer the data further; in this case from the PSA table (that is assigned to the data source) to the InfoCube
Unit 5 - BW Content 3 Hours
1. BW Content Definition
2. Business Content Add-On:pre-configured information
3. Business Content Installation
4. Business Content Install Demo
5. BW Administration Cockpit and Technical Content
6. Versioning Concept
7. Upgrade and Patching
8. BW Content Enhancing
SAP BW Business Content: Definition
Business Content Add-On: pre-configured information models
+340 ODS Objects
+600 InfoCubes
+120 MultiProviders
+3,200 Queries
+1,900 Workbooks
+800 Roles
The ideal starting point for custom-built Analytical Applications
+11,000 InfoObjects
Step 1: Available Objects
1. Select available objects by several trees
DataTargets InfoObjects InfoSources Roles By Types By Patch
By D
evelop
men
t Class
Unit 6 - Transport and ABAP (specific to BW) 2 Hours
Transports
Types and Usage of Transports
ABAP: Basics of ABAP
Transformations: Start, End Routine
CMOD
Enhancements
Unit 7 - Other InfoProviders 4 Hours
DataStore Objects Types:
Standard DSO
Write Optimised DSO
Direct Update DSO
VirtualProviders and Real-Time Data Acquisition
MultiProviders and BW InfoSets
SAP BW Multiprovider
Multiproviders
Is a combination of other InfoProviders (UNIION only)
Needs no additional data storage
Splits queries automatically and distributed to InfoProviders
Is transparent for reporting
MultiProvider
InfoCube Master Data
ODS Object InfoSet Info
Pro
vid
er
Unit 8 - Data Acquisition from Other Systems 7 Hours
SAP BW data extraction process • Data Transfer into SAP BW • Flat file Extraction • DB Connect extraction • CO-PA data extraction • LIS and LO data extraction • Generic extractor • How to enhance standard business content
Exercise
1. Creation of Data Source
2.Loading through Info Package to PSA
3. Loading through DTP to Info Cube
Unit 9 - SAP BW Front End Solutions : BEX 4 Hours
BEx Query Designer
Central tool for creation of queries
Design queries once – reuse many times (in Web templates, Bex Analyzer Workbook, Report Designer)
Publish queries directly to the Web
Two different versions exist: BW 3.5 and BI 7.0 BEx Query Designer
BEx Analyzer
Full-featured OLAP analysis in MS Excel
Operational, tabular reporting
Workbooks can integrate several queries
Ad hoc reporting based on InfoProvider (as of BI 7.X)
Leverage native Excel features (i.e. office integration)
Two different versions exist: BW 3.5 and BI 7.0 BEx Analyzer
BEx Web Applications
Execute Web Templates (created with BEx Web Application Designer), Web Ad-hoc Analysis, Reports created with Report Designer, Formatted Reporting (Crystal Reports)
Designed for building targeted web applications
One step publishing BEx (Web Application Designer, Report Designer
Two different versions exist: BW 3.5 (ABAP based Web Reporting) and BI 7.0 (Java based Web Reporting) BEx Web Application Designer
Defining
Excel
Reporting
Web
Reporting
Unit 9.1 - Query Designer
Designing a Simple Query with Free Characteristics and Prompts(Variable)
Calculated Key Figure, Restricted Key Figure
Query Properties on Formatting and Publishing to Business Object Tools
Variables (Text, Hierarchy Node)
Processing Types (Manual Input, SAP Exit, Customer Exit, Replacement Path)
Exceptions, Conditions
Information Broadcasting
Web Application Designer
Integration with Enterprise Portal
Definition of a query
Queries are created: Using the BW 3.5 or the BW 7.0 BEx Query Designer Are the basis for WEB Templates, BEx Analyzer Workbooks, Formatted Reporting (Report Designer)
InfoObjects of the InfoProvider: Key Figures and Dimensions (Characteristics)
Queries can be created for different InfoProviders: InfoCubes Operational Data Store objects / Data Store Objects InfoSets InfoObjects Virtual Providers Aggregation Layers MultiProviders
The concept of a MultiProvider is explained on the next slide
Unit 10 - SAP ASAP Methodology
What is ASAP
• Team Member Roles and Responsibilities
• Documents required in each phrase
• Major Milestones and Activities for BW developer
• How to Write BRD and Blueprint
• Introduction of the Business Scenario for the Simulated BW Project
Introduction to
• SAP Notes
• Service Market Place
Unit 11: Administration of Data Targets 3 Hours
System Administration Tasks in BI: Overview
Administration of InfoCubes
Roll Up, Compression, Chang Run
Administration of DataStore Objects
Open Hub service
•Data Marts
•Info Spokes
•Open Hub Destination
Delta Management
Unit 12 - Process Chains 2 Hours
A process chain is a sequence of processes that wait in the background for an event. Some of these processes trigger a separate event that can start other processes in turn.
A process in the context of BW process chains is a procedure inside of or external to an SAP system with a defined beginning and end. A distinction is made between a start process, an application process and a collection process.
Unit 13: Introduction to Query Performance Optimization 2 Hours
Introduction to Query Performance Optimization in BW
BW Aggregates
BW Accelerator
Statistics Overview
Unit 14: BW Support Activities 2 Hours
Work Process Overview
Process Chain Monitoring
Database Monitoring
Dump Analysis
Performance Tuning
Data Inconsistency Issues
Query Tuning
Etc..
Unit 15: SAP BI Latest Features and Functionalities 2 Hours
Business Intelligence Accelerator (BIA)
Units of Measure (UOM)
Analysis Process Designer (APD)
Unit 16: SAP INTEGRATED SOLUTIONS WITH BUSINESS OBJECTS 2 Hours
Installing the software – IS with Business Objects
What you get:
1. SAP Connectivity
Open SQL (CR ERP), InfoSet (CR ERP), BW Query and MDX (CR), ODS (CR), OLAP BAPI (Webi and Voyager)
2. SAP Authentication
3. BW Publisher Service
4. Web Content
5. BW Content Administration Workbench - /crystal/rptadmin
6. SAP Enterprise Portal – Knowledge Management
7. SAP Enterprise Portal – iView template and sample iViews