Custom BW BEx Training:

Everyone's talking about “Business Intelligence” these days, but a BW project can only be successful if your users actually understand the new system and use it for their reporting needs. After this BEx reporting course, your business users will know how to get the reports they need without waving a white flag for help. This five-day course consists of:

• a one-day consultation to determine your course's special parameters
• followed by one day of basic BW BEx training
• two more days of advanced BEx instruction
• and a final day that covers Web-based BW reporting with the Web Application Designer, and also addresses the specific final training request of your course members

Topics covered during this session include:

• keys to efficient query design
• tips for using the BEx Analyzer, BEx Browser, and the Query Designer
• using Reporting Agents and Report Scheduling
• custom template creation and data security issues
• Manuals are provided for each course member

We have saved many SAP^® users time and money by delivering this unique course, which is built (and delivered) in your own environment. References from previous students of this course are available upon request. A list of topics covered during the three middle days of “BW101” is listed below, and you can email Training@SAPtips.com for more course details.

Expanded course detail for BW101:

BW 101: ON-SITE CUSTOM BW BEx TRAINING!

Achieve the maximum ROI on your BW implementation investment. 

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

And More...

DAY 2 and 3:

Advanced BW BEx Techniques

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

To find out more about these courses or to schedule a workshop, email Training@SAPtips.com.