SAP NETWEAVER BI / BW 7.0
Duration : 60 Hrs , Fee : Rs. 2 Lakhs + taxes
This SAP BI/BW Training is primarily geared to provide you with in-depth Hands
on, Practical and detailed Knowledge. This training covers all the Basics and
Advanced Topics that are necessary to Excel as a SAP BI/BW Consultant. The curriculum
is very extensive and intense and is compiled by a team of experts who have
been in the SAP business for 10 years now.
SYLLABUS
• Analysis Authorizations: Analysis Authorizations in
SAP NetWeaver BI
• Analysis Process Design: Analysis Process Designer
(APD) and Data Mining, Enterprise Data Warehousing
• BEx Design Tools: Analytical Engine, BEx Query Designer,
BEx Report Designer, BEx Web Application Designer, Query Definition
• BEx Reporting Tools: BEx Analyzer, BEx Web Analyzer
• Business Planning and Simulation (BW-BPS): Characteristic
relationships for deriving and validating data, Configuration of planning functions
and sequences, Definition and usage of variables, Design of end user interfaces
using planning folders and the Web, General concepts and challenges of business
planning, Integration of hierarchies and attributes into BPS, Locking concept
and commit model used in BPS, Manual planning and layout formatting, Options
for data models, Positioning of BPS and relationship to BW, Set up of planning
structures, Status and Tracking System.
• Extraction: BI Java SDK / BI Java Connectors, Universal
Data Connect, Universal Data Integration, General BEx Features and Information
Broadcasting: BEx Broadcaster, Printing and Export
• Information Broadcasting: BEx Broadcaster Functions,
BW Information Broadcasting: Overview and Positioning, SAP BW 3.5 and Enterprise
Portal 6.0 Integration, Setting up Events, Time Points and Authorizations, Workbook
Pre-calculation
• Input Enabled Queries: Create an input ready query,
Filter in Planning Applications, Implementation options for BI Integrated Planning,
Performance & Sizing, Status & Tracking System, Web Application for
Planning.
• Modeling the Enterprise Data Warehouse: (New) Data
Sources, (New) InfoSources, BI Content, Concepts in Enterprise Data Warehousing.
• Data Acquisition: SAP Source Systems, Data Modeling, Data Warehousing
Workbench, InfoObjects, InfoProviders, Meta Data Repository, Remodeling Toolbox,
Source System, Transformations.
• Other NW scenarios: BW Alerts in the Central Alert
Framework of the SAP Web AS, Web Services
Planning Model Design and Planning Functions: Aggregation Levels, Characteristic
Relationships and Data Slices, Concept of Locking, Planning Functions, Planning
Modeling, Planning Sequences, Variable Wizard,
• Reporting: Chart Designer, Internet Graphics Server (IGS) migration,
Miscellaneous BEx Enhancements, New features BI Suite, Web Analyzer, Web Application
Designer Overview, Web Items: Query View Selection and Web Template, Web Items:
XML Items
• Running the Enterprise Data Warehouse: Administrator Cockpit and BI
Statistics, Direct Access, Performance Optimization, Real Time Data Acquisition,
Scheduling and Monitoring, User Management
• SAP BW and SAP XI Integration: SAP BW and SAP XI Integration
• Warehouse Management: Analysis Process Designer (APD) and Data Mining,
Miscellaneous Warehouse Management Enhancements
ERM, MDM, Star schema, extended star schema.
• OLAP/OLTP functions.
• Data warehouse workbench functions:
Characteristics, Key Figures, Data Sources for File Source Systems, Info Package, PSA Transformations, data transfer processes.
• DSO: structure and functions (standard, direct update, Write optimized)
• INFOCUBES: Basic Cube, Real-Time-Enabled InfoCube, VirtualProviders,
Remodeling
• Master data- texts, Attributes, Hierchies.
• InfoSets, MultiProviders, open hub destinations
• Business content – installation options, grouping Options,
• Data Modeling Additional topics: Line item dimension, High cardinality,
BI statistics Aggregation, Partition, compression, indexes, Rollup. Reconstruction,
Process chain.
• Transport connection
• Production issues
Data Extraction:
• BW overview –R/3 extraction
• Data Extraction from LIS
• Data Extraction from LO cockpit
• Data Extraction from CO-PA
• Data Extraction from FI
• Generic data extraction
Reporting:
• Introduction to BW-Bex reporting & web reporting
• BEX Analyzer & Bex Browser
• Reporting features & properties
• Free Characteristics, Filters, Exceptions, Conditions, Calculated and
Restricted Key Figures, Cell Definition, Broadcasting, Query design. New selection,
new formula.Column&row properties.
• Variables: Characteristic value variables, Hierarchy Variables, Hierarchy
node variables, Text variables, Formula variables
ABAP (related to BI)
End routine.
Start routine.
Customer exit (for variables)
Characteristics routine,
Data Source Enhancements
Business flow: SD, MM, PP, FI, HR.
