DAY 1 - BW BEx Beginner Course

Overview of Data Warehouses
Basic Data Structure in SAP BW
Introduction to the Business Explorer Tools
Browser vs. Analyzer
Logging into the System
BEx Browser Components
Create/Rename/Delete Folders
Move and Organize Workbooks
Add Websites, R/3 Transactions and Application shortcuts
BEx Analyzer Features
Tools available from BEx Toolbar
Using Excel Functionality in parallel
Roles vs. History vs. Favourites
Screen layout
Browser vs. Analyzer
Relationship of Technical Queries to Workbook files
BW-specific terminology
Changing Queries - Local Views vs. Global Views
Selection Criteria
Multiple Selection Options
Wildcards
Using Text Elements
Data Relevance
Variables and Filters
OLAP functionality
Drilldown/across
Using Results Rows
Swap columns
Single value filters
Free Characteristics
Key Figures
Multiple value filters
Characteristic display options
Sorting
Hierarchies
Query Properties
Defining and using Exceptions
Exception Variable Creation
Defining and using Conditions
Condition Operands
Condition Variable Creation
Exceptions vs. Conditions
Saving Workbooks
Best practices
Detaching Reports
Emailing Results
Customized Practical Exercises & Review

DAY 2/3 - BW BEx Advanced Course

Review of Beginner Course Topics
Query Designer Screen
Building Queries from Data Sources
Infocubes vs. Multicubes
Query Designer Settings
Report Titles
Sequence of Entry Variables
Display Options
Columnar Queries
Characteristic Restrictions
Characteristic Properties
Key Figure Properties
Where-used feature
Restricted Key Figures
Business Content
Cube level vs. Query Level
Calculated Key Figures
Cube Level vs. Query Level Objects
Operands and Math Functions
Structure creation and Re-use
Variables
Variable Types
Variable Processing
Characteristic Variables
Key Figure Variables
Text Variables
Variable Offsets
Advanced Workbook Formatting
Moving Filters
Moving Text Elements
Creating Templates
Color formatting
Inserting Graphics
Inserting Charts
Removing Toolbars and Gridlines
Multiple Query Workbooks
Deleting Results
External Excel Functions
Reporting Agent
Scheduling Queries
Batch Printing
Exception Reporting
Package Creation
Package Scheduling
Reporting Log
Exception Log
Web Reporting
Web Template Creation
Web Application Designer
Using Web Objects
Additional Features
Data Integrity and Security
Practical Exercises & Review
Customized Practical Exercises & Review
And More....