> > > B5173G Detaillierte Beschreibung

IBM Cognos PowerPlay Client: Explore and Build Reports (V10.1/10.2) (B5173G)

Kursbeschreibung Kurstermine Detaillierter Kursinhalt

Detaillierter Kursinhalt

Overview of IBM Cognos BI

  • Describe IBM Cognos Business Intelligence (BI) and Financial Performance Management (FPM)
  • Describe IBM Cognos BI components
  • Describe IBM Cognos BI architecture at a high level
  • Define IBM Cognos groups and roles
  • Explain how to extend IBM Cognos BI

PowerPlay 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 zeros
  • Use multiline and bar graphs
  • Use alternate drill paths
  • Examine and use 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 you would use Reporter mode
  • Compare Reporter and Explorer modes
  • Drill down in Reporter mode
  • Add categories as rows or columns in Reporter mode

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 conversion 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 performed 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 PowerCube
  • 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

Use PowerPlay Modes, Charts, and Formatting (Optional)

  • Determine when to use Explorer or Reporter
  • Interpret which display type to use
  • View reports and use the Print dialog box