Course Overview

IBM Cognos 8 BI PowerPlay Studio: Web Exploration (V8.4) is a one-day instructor-led course designed to teach you the basic skills they need to view, explore, format and distribute PowerPlay reports using PowerPlay Studio. You will learn to create reports, view multidimensional cube data, add calculations, and use graphical displays. The course also covers drag and drop within crosstabs, ranking, custom subsets and scenario dimensions.

Who Should Attend

This intermediate course is intended for new PowerPlay Studio users.

Course Certifications

This course is part of the following Certifications:

Prerequisites

You must have an:

  • Experience using a Web browser and knowledge of business requirements.

Course Objectives

Please refer to course overview for description information.

Course Content

1: PowerPlay Studio Fundamentals

  • Discuss fundamental terminology
  • Describe the contents and use of cubes
  • Identify the PowerPlay components and describe their purpose
  • Examine the PowerPlay application development process
  • Examine the dimension line, dimension viewer, PowerPlay Studio Explorer toolbar, and online help
  • Explore PowerPlay reports and cubes in IBM Cognos Connection

2: Tools for Investigation

  • Drill down and drill up to other levels of detail
  • Change measure values
  • Replace rows and columns
  • Change display types
  • Add value by altering the appearance of a report
  • Add custom titles
  • Change currency

3: Basic Exploration and Reporting

  • Filter data
  • Use layers to move through different categories
  • Sort and rank data
  • Highlight exceptional data
  • Suppress data
  • Hide or show rows and columns
  • Use alternate drill paths
  • Examine scenario dimensions

4: Add Value to your Exploration

  • Nest categories in rows and columns
  • Change the layout of nested crosstabs
  • Drill down in nested crosstabs
  • Use the drill-through feature for PowerPlay Studio

5: Data Analysis

  • Compare multiple measures
  • Use special categories
  • Show values as percentages
  • Create and use calculations

6: Custom Subsets

  • Define custom subsets
  • Create custom subsets for a dimension in a report
  • Create custom subsets using category selection
  • Create custom subsets using search criteria
  • Create custom subsets using measure values
  • Modify custom subsets

7: Distribute Results

  • View reports in IBM Cognos 8 Report Viewer
  • Prepare a bookmark
  • Export and save reports
  • Print a report
  • Open a PowerPlay report in Analysis Studio or Report Studio
  • Schedule a report