WebIntelligence XI R2 Advanced Reporting

Course Length - 1 Day

Description

This class is a combination of instructor-led lecture, discussions, and demonstrations with a heavy emphasis on hands-on workshops to teach WebIntelligence^TM. Topics include; revising SQL, creating complex conditions, advanced query filters, multiple data providers, combination queries, variables and functions.

You Will Learn

Upon completion of this course, the participant will be able to:

Create SQL queries
Build advanced queries
Access multiple data providers
Create combination queries
Create variables and functions

Prerequisites

WebIntelligence^TM XI R2 Intermediate Reporting

Who Should Attend

This course is designed for WebIntelligence^TM users and/or anyone using Desktop Intelligence^TM reporting.

Outline

Variables and Functions

Creating And Validating Formulas
Creating Variables
Editing Variables
Duplicating Variables
Deleting Variables
Using Functions In Variables

Advanced Query Filters

Object To Object Filters

Creating Subqueries (Any/All)

Multiple Data Providers

Adding New Queries

Duplicating Queries

Deleting Queries

Merging Dimensions to Link Data Providers

Creating Single Report Blocks From Multiple Data Providers

Combination Queries

Union Queries
Intersect Queries
Minus Queries

Drilling

Setting Drill Preferences
Hierarchies
Drilling Down/Up/By/Through
Using Scope of Analysis
Snapshots

Revising SQL

Viewing SQL
Editing SQL
Saving Changes
Resetting Changes

Contact Us

Interested in this course? We deliver on-site, online, and self-paced. If you have questions, or would like to talk with a Dashcourses representative, call us at 1-866-945-4844 or fill out the form below.

Course*	Please enter the Course Name.
Name*	Please enter your name
E-Mail*	Please enter a valid email address
Company*	Please enter your Company Name.
Phone	Please enter a valid phone number
Message	Invalid Input
* indicates a required field

Would you like to receive our Monthly Newsletter? (You can unsubscribe at any time.)
	YesNo Invalid Input
Please enter the characters below*	Refresh Invalid Input

**Note: We keep your information private and will not share your information with any other organization.