Training

 

 

Popular Courses

Browse Our Free Resources

  • whitepapers
  • whitepapers
  • webinars
  • blogs

Our Locations

Training Centres

Vancouver, BC
Calgary, AB
Edmonton, AB
Toronto, ON
Ottawa, ON
Montreal, QC
Hunt Valley
Columbia

locations map

Calgary

550 6th Av SW
Suite 475
Calgary, AB
T2P 0S2

Toronto

821A Bloor Street West
Toronto, ON
M6G 1M1

Vancouver

409 Granville St
Suite 902
Vancouver, BC
V6C 1T2

U.S. Office

436 York Road
Suite 1
Jenkintown, PA
19046

Other Locations

Dallas, TX
Miami, FL

Home > Training > SAP > WebIntelligence 4.1 Advanced Reporting Training

WebIntelligence 4.1 Advanced Reporting Training

Course#: WA2413

This class is a combination of instructor-led lecture, discussions, and demonstrations with a heavy emphasis on hands-on workshops to teach WebIntelligence. Topics include:  formulas, variables and functions, multiple data providers, advanced query filters, subqueries, drilling on reports, cross tables and charts, combination queries, and revising SQL.

Objectives

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

  • Create formulas and variables, build advanced queries, access multiple data providers, merge multiple data providers, create combination queries, create drillable reports, and revise SQL in existing reports.

Topics

  • Creating/Editing Formulas
  • Creating/Editing Variables
  • Converting Formulas to Variables
  • Utilize Functions in Calculations
  • Adding New Queries
  • Duplicating Queries
  • Deleting Queries
  • Merging Dimensions to Link Data Providers
  • Add To Merge
  • Reporting From Excel Files
  • Creating Single Report Blocks From Multiple Data Providers
  • Object To Object Filters
  • Creating Subqueries (Any/All)

Audience

This course is designed for WebIntelligence users and/or anyone using WebIntelligence  Desktop Reporting.

Prerequisites

WA2412 WebIntelligence 4.x Intermediate Reporting

Duration

1 Day

Outline of WA2413 WebIntelligence 4.1 Advanced Reporting Training

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

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

Advanced Query Filters

  • Object To Object Filters
  • Creating Subqueries (Any/All)
  • Filters based on Previous Queries

Drilling

  • Setting Drill Preferences
  • Hierarchies
  • Drilling Down/Up/Through
  • Using Scope of Analysis
  • Snapshots
  • Drill Mode
  • Single Dimension Drilling in Headings
  • Multiple Dimension Drilling in Crosstabs
  • Drill Options Up, Down, Across
  • Converting to Chart

Combination Queries

  • Union Queries
  • Intersect Queries
  • Minus Queries

Advanced Formatting  

  • Hiding Objects
  • Conditionally Hiding blocks, cells and Sections
  • Linking Report Elements
  • Creating and Publishing Web Services
We regularly offer classes in these and other cities. Atlanta, Austin, Baltimore, Calgary, Chicago, Cleveland, Dallas, Denver, Detroit, Houston, Jacksonville, Miami, Montreal, New York City, Orlando, Ottawa, Philadelphia, Phoenix, Pittsburgh, Seattle, Toronto, Vancouver, Washington DC.
*Your name:

*Your e-mail:

*Phone:

*Company name:

Additional notes:

We have received your message. A sales representative will contact you soon.

Thank you!.

more details
buy this course

Register for a courseware sample

It's simple, and free.

 

Thank You!

You will receive an email shortly containing a link to download the requested sample of the labs for this course.