Web Intelligence Training Overview
In Accelebrate's Web Intelligence® 4.2 Reporting training, attendees master how to use variables and functions in their reports, produce reports based on data from multiple providers, drill up/down/across data, perform combination queries, and more.
Need to train just 1 or 2 attendees? See a schedule and register for our Open Enrollment Web Intelligence Reporting Training for Individuals.
Location and Pricing
Accelebrate offers instructor-led enterprise training for groups of 3 or more online or at your site. Most Accelebrate classes can be flexibly scheduled for your group, including delivery in half-day segments across a week or set of weeks. To receive a customized proposal and price quote for private corporate training on-site or online, please contact us.
In addition, some courses are available as live, instructor-led training from one of our partners.
Objectives
- Create formulas and variables
- Build advanced queries
- Access multiple data providers
- Merge multiple data providers
- Create combination queries
- Create drillable reports
- Revise SQL in existing reports
Prerequisites
All students should have taken Accelebrate's Intermediate Web Intelligence training course, or have the equivalent knowledge.
Outline
Expand All | Collapse All
Introduction
Variables and Functions
- Creating And Validating Formulas
- Converting Formulas to Variables
- Creating Variables
- Advantages/Disadvantages of Both
- Editing Variables
- Duplicating Variables
- Deleting Variables
- Using Functions In Variables
- Resetting Values
- Saving/Sharing Report Elements
Multiple Data Providers
- Adding New Queries
- Duplicating Queries
- Deleting Queries
- Merging Dimensions to Link Data Providers
- Creating Single Report Blocks From Multiple Data Providers
- Adding to Earlier Merges
- Reading Excel files directly
- Reading SQL directly
Advanced Query Filters
- Object To Object Filters
- Creating Subqueries (Any/All)
- Filters based on Previous Queries
Drilling
- Setting Drill Preferences
- Hierarchies
- Drilling Down/Up/Through
- Using Scope of Analysis
- Snapshots
- Drill Mode
- Single Dimension Drilling in Headings
- Multiple Dimension Drilling in Crosstabs
- Drill Options Up, Down, Across
- Converting to Chart
Combination Queries
- Union Queries
- Intersect Queries
- Minus Queries
Advanced Formatting
- Hiding Objects
- Conditionally Hiding blocks, cells, and Sections
- Linking Report Elements
- Creating and Publishing Web Services
Conclusion
Training Materials
All Web Intelligence students receive comprehensive courseware.
Software Requirements
Class files and instructions for setting them up on your BusinessObjects server are provided. All attendees and the instructor will need access to the server during the training.
