Course Description
WebIntelligence 4.x Intermediate Reporting, the second course in a 3-part series, discusses the 4 major types of report blocks. You will learn how to convert report blocks utilizing features like templates and TURN TO. We’ll discuss how to apply those same concepts to create charts. You’ll create complex query filter prompts and learn how to mix AND/OR conditions together in a query filter. You’ll work with more complex cross table reports and applying the various report functions in a cross tables. You’ll learn how to create input controls in a report/chart to do dynamic filtering, and how to apply more advance conditional formatting features to a cross table report. There will be lab exercises throughout the course to help you practice what you’ve learned, and require an in-house server running SAP BusinessObjects. Lab exercises are also demonstrated throughout the entire course.
In This Course You Will Learn:
- Create a variety of report format types
- Create a variety of charts
- Create complex conditions with prompts
- Create complex cross tables
- Apply formatting options, reporting functions, Input Controls, and conditional formatting to crosstab blocks
Prerequisites
WebIntelligence™ 4.x Basic Reporting
Outline
Module 00: WebIntelligence™ 4.x Intermediate Reporting - Course Introduction
Module 01: Report Block Types
- Drag and Drop
- Using Turn Into
- Using Templates
- Demos
Module 02: Creating Section Reports
- Relative Positioning
- Sectioning a Report
- Formatting the Section
- Exercise: Creating Types of Report Blocks
- Demos
Module 03: Exercise Demo: Creating Types of Report Blocks
Module 04: Creating Charts Part 1
- Using Templates
- Using Turn To
- Formatting Charts
- Demos
Module 05: Creating Charts Part 2
- Using New Chart styles
- Color Formatting
- Measure Values Orientation
- Exercise: Creating Charts
- Demos throughout
Module 06: Creating Charts Part 3
- Changing Chart Style
- Chart Dimensions
- Changing Chart Variables
- Exercise: Creating Charts
- Demos throughout
Module 07: Exercise Demo: Creating Charts
Module 08: Creating Complex Query Filters
- Creating Prompts
- Prompt Properties
- Cascading List of Values
- Demos
Module 09: Using Ands and Ors
- Creating Multiple Filters
- Using Brackets
- Mixing Ands and Ors
- Exercise: Creating Complex Conditions
- Demos throughout
Module 10: Exercise Demo: Creating Complex Conditions
Module 11: Intermediate Cross Tables Part 1
- Drag and Drop
- Turn Into
- Pivoting Via Headers
- Demos
Module 12: Intermediate Cross Tables Part 2
- Displaying Row and Column Headers
- Crosstab formatting
- Displaying Multiple Objects in the Headers
- Exercise: Creating and Formatting Cross tables
- Demos throughout
Module 13: Exercise Demo: Creating and Formatting Cross Tables
Module 14: Advanced Cross Tables Part 1
- Advanced Breaking:
- Break Properties
- Advanced Ranking
- Rank Properties
- Demos
Module 15: Advanced Cross Tables Part 2
- Sorting/Custom Sorting
- Sorting on Properties
- Filtering on Headings
- Demos
Module 16: Input Controls
- Creating an Input Control
- Single Value/Multiple Value
- Dimensions vs. Measures
- Exercise: Advanced Cross Tables
- Demos
Module 17: Exercise Demo: Advanced Cross Tables
Module 18: Conditional Formatting Part 1
- Creating Rules
- Cell Format
- Text Format
- Demos
Module 19: Conditional Formatting Part 2
- Variable Format
- Applying Condtional Formatting to Cross table
- Editing and Reformatting Conditional Formatting
- Exercise: Conditional Formatting
- Demos
Module 20: Exercise Demo: Conditional Formatting
Certification
The SAP Certified Application Associate™ – SAP BusinessObjects Web Intelligence 4.0 Certification exam verifies proven skills and fundamental knowledge in using SAP BusinessObjects Web Intelligence 4.0 to create and maintain queries and reports that will help you analyze and interpret important information.
GogoTraining’s three course series, SAP BusinessObjects WebIntelligence™ 4.x Advanced Reporting , SAP BusinessObjects WebIntelligence™ 4.x Basic Reporting , and SAP BusinessObjects WebIntelligence™ 4.x Intermediate Reporting has been designed to cover everything that is provided in the SAP recommended courses below:
- Web Intelligence – Report Design I, E-Learning course BOW310 and classroom course BOW315
- Web Intelligence - Advanced Report Design E-Learning course BOW320 and classroom course BOW325
The SAP Certified Application Associate™ – SAP BusinessObjects Web Intelligence 4.0 Certification exam is an 80 question exam and you may take up to 180 minutes (3 hours) to complete it. A passing mark is 66% or higher. The exam number is C_BOWI_40.
EXAM LOCATION
Exam Locations: For exam locations, click on this link.