TP3578
Advanced Web Intelligence 4.3 Reporting Training
In our 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.
Course Details
Duration
1 day
Prerequisites
PAll students should have taken our Intermediate Web Intelligence training course, or have the equivalent knowledge.
Skills Gained
- Create formulas and variables
- Build advanced queries
- Access multiple data providers
- Merge multiple data providers
- Create combination queries
- Share elements
- Apply advanced formatting techniques
Course Outline
- 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
