Back to Web Intelligence Training

Beginner | Intermediate | Advanced Boot Camps

Price: $495 per student, per day
Duration: 3 Days

Course Description:

Users and report designers, who are new to Web Intelligence 4.2 and need to learn to access, analyze and share data using Web Intelligence. After completing this course, you will be able to create, format and maintain Web Intelligence documents and use complex functions such as: creating documents using multiple sources, using functions for character, date and strings, redefining calculation contexts, using “If” logic, as well as linking Web Intelligence documents.

Please Note: This course is broken into three days: Beginner, Intermediate, and Advanced. Students can customize their learning experience by selecting specific level of training needs. For example, you can register for just the Beginning course or continue onto Day 2 with the Intermediate and Day 3 with the Advanced.

Intended Audience:

Users and report designers, who are new to Web Intelligence 4.2

Prerequisites:

Beginner Course: None prerequisites!

Intermediate Course: The beginner course is recommended.

Advanced Course: The beginner and intermediate course is recommended.

Agenda: 3 Days

Day 1 – Beginner Course

Introduction to SAP Business Objects

• Introduction to BI Launchpad
• Introduction to Web Intelligence
• Introduction to Universe
• Different Interfaces

Understanding Web Intelligence Document

• Opening a Web Intelligence document
• Creating a new document
• Editing a document

Query Panel

• Toolbars
• Data Manager
• Adding Objects

Query Filters

• Purpose of Filters
• Elements of Filters
• Type of Filters
• Working with Filters

Report Manager

• Understanding the Report Manager
• Panels
• Design Toolbar and Toolboxes
• Navigating the Document
• Working with Table, Charts and other visual elements
• Table & Cell Formatting
• Adding, Editing & Deleting Comments
• Adding/Deleting Reports

Organizing Data

• Sorting
• Breaks
• Summarizing Data
• Sections
• Functions
• Conditional Alerts

Data Filters

• Block Filters
• Report Filters
• Input Controls
• Element Linking
• Ranking

Day 2 – Intermediate Course

Formulas & Variables

• Introduction to Formula
• Create a formula
• Formula Editor
• Pre-defined Formulas
• Create a variable

Queries & Data Providers

• Types of Queries
• Combined Queries
• Advanced Filter – Subqueries
• Advanced Filter – Query of a Query
• Multiple Queries
• Personal data providers
• Free-Hand SQL  as source
• Merging Dimensions
• Changing a Data Source

Report Functions

• Tracking Data Changes
• Optional Function Parameters
• Using Functions to override report filters in Calculations
• Shared Elements

Drill Down

• Activate drill down on a document
• Drilling down on selected hierarchy

Day 3 – Advanced Course

Calculation Context

• Custom calculation context
  • Input Context
  • Output Context

Report Techniques

• Passing a constant to a Document
• Limit number of rows on a page
• Grouping, If, Then Else
• Using hyperlinks to open documents
• Handling Nulls or Blanks

Useful Features

• Outline
• Cascading Input Control
• Dynamic Metric/Dimensions
• Using Web Services as a data source
• Creating Web Services from Webi parts

What your Universe Designer Can Do for You

• Prompt for Section Breaks
• Delegated Measures
• Cascading Prompts
• Automatic Date Prompts

Available Dates: 

Please Note: This course is broken into three days: Beginner, Intermediate, and Advanced. Students can customize their learning experience by selecting specific level of training needs. For example, you can register for just the Beginning course or continue onto Day 2 with the Intermediate and Day 3 with the Advanced.