IBM Cognos PowerPlay Studio: Web Exploration (V10.1/10.2)

Overview of IBM Cognos BI

• Discuss IBM Cognos BI and Performance Management
• Describe IBM Cognos BI components
• Describe IBM Cognos BI architecture at a high level
• Define IBM Cognos BI groups and roles
• Explain how to extend IBM Cognos BI

PowerPlay Studio Fundamentals

• Discuss fundamental terminology
• Login to a secure namespace
• Describe the contents and uses of data sources
• List the PowerPlay components and describe their process
• Explain the PowerPlay application development process
• Use the dimension line, dimension viewer, and online help
• View an Explorer report
• Publish reports to the IBM Cognos portal

Tools for Investigation

• Drill down to lower levels of details
• Replace rows and columns
• Change measure values
• Change display types
• Investigate various ways to arrange a report

Data Exploration and Reporting

• Filter data
• Sort and rank data
• Suppress data
• Multiline and bar graphs
• Use alternate drill paths
• Examine scenario dimensions

Add Value to your Exploration

• Use layers to analyze a third dimension
• Show multiple dimensions with a stacked bar display
• Add and explore multiple displays
• Nest categories in rows, columns and layers
• Change the layout of nested crosstabs
• Use nested charts

Data Analysis

• Apply multiple measures
• Compare two measures
• Use special categories
• Show values as percentages
• Create 3D Bar, Pie, and Correlation displays
• Add statistical lines to charts

Calculations in Explorer Mode

• Create and use calculations
• Create forecast calculations
• Use calculated categories

Reporter Mode

• Determine why to use Reporter mode
• Compare Report and Explorer modes
• Drill down in Reporter mode
• Add categories as rows or columns

Calculations in Reporter Mode

• Define different types of calculations in Reporter mode
• Create group calculations
• Work with calculated categories in Reporter mode
• Generate calculations when adding categories

Add Value to the Report

• Create new styles
• Develop custom exceptions
• Create nested crosstab reports in Reporter mode
• Explore drop zones in Reporter mode
• Use blank cells, blank lines, and currency conversions to add value to reports
• Format values and labels and add titles, headers, and footers to reports

Subsets in Standard Reports

• Define standard reports and subsets
• Create subset definitions and subsets
• Differentiate between parentage and find-in-cube subset definitions
• Modify subsets by editing
• Highlight subsets and perform calculations
• Create advanced subset definitions
• Understand restrictions by Parent, Find, and Value

Special Features

• Analyze details using a sub-cube to limit data
• Understand how to work off line with data from a remote cube
• Drill through to PowerCubes
• Explain methods of updating data and sharing dimension lines

Distributing Reports

• Set prompting and PDF properties for published reports
• Export a report to a different file format
• Set PDF properties and save the report in PDF format
• Print the report
• Attach the report to an email message
• Schedule a published report

Optional Modules

• Determine when to use Explorer or Reporter
• Interpret which display type to use
• View reports and use the Print dialog box
• Change display types
• Investigate various ways to arrange a report