IBM Cognos TM1: Analyzing Data (version 9.4) SPVC

Examine TM1 Components

• Review financial performance management
• Understand how TM1 enables financial performance management
• Identify the TM1 user community
• Describe the components of TM1

Browse Data in a Cube

• Understand what solution a model represents
• List the components of a cube
• Create a new view of the data
• Stack, swap and filter dimensions in a cube
• Use drill capabilities to focus the data

Focus Your Analysis using Subsets

• Examine the benefits of subsets
• Use aliases in subsets
• Filter subsets
• Differentiate between static subsets and dynamic subsets
• Add user-defined consolidations in subsets

Contribute Data

• Spread data to multiple cells at once
• Edit individual cells
• Exclude cells from being adjusted
• Describe the power of lookup cubes

Work with Spreadsheets

• Differentiate between a slice and a snapshot
• Use a classic slice and an Active Form
• Manage TM1 data through Excel
• Use TM1 worksheet functions

Create Dynamic Reports with Active Forms

• Create interactive reports and data input templates using Active Forms
• Customize Active Forms using new TM1 Functions
• Apply formatting to Active Forms

Organize and Distribute Results

• Use TM1 applications to organize reports
• Publish content to the Web
• Access content using TM1 Web

Present Data Using TM1 Web

• View and manipulate a TM1 Web Sheet
• Stack and swap dimensions in a cube view
• Create a new cube view
• Graph data in a cube view
• Use drill capabilities to focus the data
• Print and save cube view as an Excel file or PDF

Edit Subsets in TM1 Web

• Build a simple and complex subsets in TM1 Web
• Create custom consolidations in TM1 Web

Appendix A: Enhance Report Presentation (Optional)

• Use Action buttons to enhance functionality in Excel and TM1 Web reports
• Add worksheet controls to change the presentation of data

Appendix B: Introduction to Executive Viewer (Optional)

• Repeat the steps to start the TM1 server and start the Executive Viewer client to employ Executive Viewer functionality
• Locate data by connecting to a data source
• Create a view to analyze your data
• Organize members and dimensions within a view

Appendix C: Integrate with Cognos 8 Business Intelligence and Cognos 8 Planning (Optional)

• Describe how to use TM1 cubes within a Cognos 8 business intelligence (BI) environment
• Integrate IBM Cognos TM1 in Cognos 8 BI portals
• Describe how to use TM1 data in an IBM Cognos 8 Planning application
• Describe how to use IBM Cognos 8 Planning data in a TM1 application