IBM Cognos Express: Analyze Data with Xcelerator (V10.1) SPVC

Customize Cube Views

• Understand the solution a model represents
• View cube data from different perspectives
• Use aliases to display alternate element names
• Filter subsets to view only specific elements
• Differentiate between status & dynamic subsets
• Add user-defined consolidations in subsets

Enter and Spread Data

• Store private data in sandboxes
• Edit individual cells
• Spread data to multiple cells at once
• Exclude cells from being adjusted
• Enter data quickly using shortcuts

Work with Spreadsheets

• Differentiate between a slice and a snapshot
• Manage TM1 data through Microsoft Excel
• Use TM1 worksheet functions
• Create reports in Microsoft Excel and PDF formats

Create Dynamic Reports with Active Forms

• Create interactive reports and data input templates using Active Forms
• Customize Active Forms using TM1 Functions
• Apply formatting to Active Forms
• Add Action buttons to enhance functionality

Explore Data and Edit Subsets in TM1 Web

• Create a new cube view
• Work with a TM1 cube view on the Web
• Build simple and complex subsets in TM1 Web
• Create a new server and organize the model