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

IBM Cognos PowerPlay Client: Explore and Build Reports (V10.1) is a two-day instructor-led course designed to teach users the basic skills needed to analyze business data and create reports in PowerPlay Client. To analyze their data, participants will learn how to drill through cube data, replace categories and measures in a crosstab, change the display to view the data in one of several graphical formats, format each display to enhance their analysis, sort, rank, and filter data, and create calculations. To create reports, participants will learn how to build a report crosstab, perform and add calculations, use advanced nesting functions, create subsets, and distribute reports.

Visa den här kursen i andra länder

Roadmaps:

• IBM Cognos BI 10.1 – Business Author Role

Tillbaka till toppen

This course is intended for PowerPlay Report Authors.

Tillbaka till toppen

You should have:

• Knowledge of your business requirements
• Experience using basic Windows and Web functionality

Tillbaka till toppen

Please refer to course overview.

Tillbaka till toppen

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

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
• Change display types
• Investigate various ways to arrange a report

Tillbaka till toppen