Web Intelligence Training Overview
In Accelebrate's Web Intelligence® 4.3 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.
Location and Pricing
This course is taught as a private course in-person or online for teams of 3 or more. To receive a quote for online corporate training, 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
- Share elements
- Apply advanced formatting techniques
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
- Reference Cells
- Context Operators
- Reference Cells
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 Text Files directly
- Reading SQL directly
- Reading Webi Documents
Advanced Query Filters
- Object To Object Filters
- Creating Subqueries (Any/All)
- Filters based on Previous Queries
Combination Queries
- Union Queries
- Intersect Queries
- Minus Queries
Shared Elements
- What is Element Sharing
- How do I Share a Block
- Update vs Unlinking a Block
- How it can Expedite Report Creation
Advanced Formatting
- Hiding Objects
- Conditionally Hiding blocks, cells and Sections
- Linking Report Elements
- Intra Document linking
- Cascading Input Controls
- Breaks vs Sectioning
- Visualizations in Webi
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.
