Academic Research
Consumer Reports
Technology Reports
Corporate Consulting

Got a Deadline?
Get a Summary!
saving you time.

Personal Services:
Research Summary
Job Summary
Tech Summary

Corporate Services:
SAP BW Training
BW User Guide
BW Answer Service

Payment Information

About Us
Contact Us
Privacy Policy

Help

Join our Mailing List! Enter your Email Address below:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 


SAP CORPORATE CONSULTING

ON-SITE CUSTOM BW BEx TRAINING!

Achieve the maximum ROI on your BW implementation investment.

DETAILED LIST OF TOPICS COVERED:

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....

 

For more information on this or any of our Corporate Services please contact our Sales Team.

esolutions@researchsummary.ca


MAXIMIZE YOUR INVESTMENT!

NEW! BW User Guide NEW!

ABOUT RESEARCH SUMMARY CONSULTING
Research Summary Consulting has a long and successful track record of teaching Business Information Warehouse (BW) to Fortune 500 companies throughout North America. We employ highly experienced classroom instructors with a passion to transfer in-depth knowledge of BW to our clients.

Back to BW Consulting Services