Course description: IBM OpenPages: Author Reports Fundamentals and Advanced (V6.0) SPVC

PLEASE DO NOT MAKE TRAVEL ARRANGEMENT FOR THIS SELF PACED VIRTUAL COURSE (SPVC). ONCE YOU ARE ENROLLED IN THIS COURSE, YOU WILL NOT BE ABLE TO CANCEL YOUR ENROLLMENT.

After you receive confirmation that you are enrolled, you will be sent further instructions to access your course material and remote labs. You will then have a 30 day window in which to complete your course. Within this 30 days, you will have 336 hours of elab time. The self-paced format gives you the opportunity to complete the course at your convenience, at any location, and at your own pace. The course is available 24 hours a day, but lab system access is allocated on a first-come, first-served basis. When you are not using the elab system, ensure that you suspend your elab to maximize your hours available to use the elab system. Once you have accessed the course, help is available Monday through Friday; questions will be responded to within 24 hours.

NO EXTENSIONS FOR THIS COURSE WILL BE GRANTED.

This is the self paced training version of classroom course 'IBM OpenPages: Author Reports Fundamentals and Advanced'. IBM OpenPages: Author Reports Fundamentals and Advanced is a Self-Paced Virtual Class combining the Report Authoring and Advanced Report Authoring content in which OpenPages report authors learn fundamental and advanced techniques to create reports. Students will learn to use the OpenPages generated framework model and best practices to create reports based upon their business requirements.

View this course in other countries

Training Paths that reference this course are:

• IBM OpenPages V6.0 – OpenPages Report Author Role

Back to top

IBM Education Advantage Program Eligibility:

• Yes - Education Pack - online account

Back to top

This basic course is for Professional report authors.

Back to top

You should have completed:

• IBM Cognos BI Report Studio: Introduction (V8.4) WBT
• IBM Cognos BI Report Studio: Intermediate (V8.4) WBT
  • Optional
• Using IBM OpenPages (V6.0) WBT
• IBM OpenPages: Core Team Fundamentals (V6.0) WBT

Back to top

Please refer to Course Overview for description information.

Back to top

Configurations for Generated Reporting Framework

• Facts and dimensions
• Recursive object levels
• Object type dimensions
• Namespaces
• Triangle relationships

Generated Reporting Framework Overview

• Package and namespaces
• _REL namespace
• _DIM namespace

Secondary Object Reports

• Considerations and options for creating reports
• Using joins and unions

Common Performance Enhancements

• Important detail filtering
• Parameter maps
• Is Not Null filtering
• Query properties

Spreadsheet Considerations

• "View Excel" options and considerations
• "View CVS" options and considerations
• Formatting reports for CVS and spreadsheet output

IBM Cognos List Headers

• Using tables in headers
• Sub-dividing headers and footers

IBM OpenPages Functions

• Overview of all functions available for use
• Using functions in reports and prompts

Using Conditional Variables

• Formatting based upon ReportOutput()
• Conditional block tool
• Multi-language translations for text strings

Using Enumeration Maps

• Purpose of enumeration maps
• Proper formatting
• Enhancing performance
• Using in detail filters
• Using in IF-THEN-ELSE constructs

Interactive Prompt Pages

• Filtering prompt contents
• Cascading prompt selections
• Single- and multi-select prompts
• Single- and multi-value enumerated string prompts
• Re-prompting

Sorting Data

• List container columns
• List container rows by a specified column order
• Edge components or a crosstab container
• Enumerated string custom sort order
• Prompted sorting

Using Recursive Object Levels

• Entity levels in list and crosstab containers
• Using hierarchy context in a report query
• Using hierarchy context for report formatting

Using Drill Capabilities

• Drill-down and drill-up
• Drill-through
• CrossTrack™ links

Query Operations

• Overview of operations that are available and which ones are useful in OpenPages reports
• Using unions to combine data from multiple namespaces
• Using unions and joins to create Issue reports

Creating Custom List Columns

• Identifying uses for custom list columns
• Aggregating
• Using query hierarchies

Adding a Namespace

• Reasons for a new namespace
• Determining contents of a namespace
• Configuring the namespace object model

Portal Dashboards

• Requirements for reports included in a dashboard
• Adding an inline prompt
• Laying out the dashboard page

Reporting Fragments

• Limitations in reporting fragments
• Automatic and On Demand reporting fragments
• Formatting considerations
• Collecting required information for the GRC Platform administrator

Back to top

eLabs will be available for a total of 336 hours in the 30 day window.

Back to top

Minimum Requirements (for PC) to use SPVC

• Windows 2000, XP, Vista, and 7
• Firefox, including V3.6.6
• Internet Explorer, including V8
• Browser settings include:
  • Java Runtime Environment must be installed and enabled in the web browser
  • Web browser must be set to enable/allow JavaScript
  • Web browser Pop-up blocking mechanisms must be set to allow pop-ups from elearn.ihost.com
  • Cookies must be enabled
  • Flash-enabled
  • CITRIX, for the remote lab (instructions to install included with the SPVC)

Back to top