Explore TM1 data

Create, explore, and share views and reports using TM1® data. You can also use TM1 functions, sets, and modify TM1 data for your reports.

Exploration Views and lists
Use Exploration Views and lists to quickly change how you view performance measures and to show detailed information from your database in rows and columns.
Quick Reports
You use Quick Reports to work with IBM® TM1 data in Microsoft Excel in a more dynamic way.
Dynamic Reports
You can use Dynamic Reports to create complex reports that combine the functionality of IBM TM1 with Microsoft Excel features.
Create a Custom Report
You can create reports by using TM1 worksheet functions to populate the cells of the report.
Universal Reports
You can use Universal Reports to create hierarchy aware and parameterized reports, which can dynamically execute formulas and queries against the TM1 Server.
Using data cell formulas in non-formula based reports
You can use formulas in your Exploration Views and Quick Reports.
Sets
Sets are a group of members within a dimension. You can create and edit sets through the Set editor to limit the number of members that you see in a view.
Modify TM1 data
You can modify data in reports that use an IBM Planning Analytics data source.
IBM TM1 functions
You can add formulas that use IBM Cognos® functions to reports. You can also convert Exploration Views that use TM1 data to formulas. For advanced analysis, you can create reports that use formulas to populate the cells of a worksheet.
MDX Function Support
All TM1 supported Microsoft-defined and TM1 specific functions are listed in this section.
Drill through cells to see detailed data
A TM1 modeler can define drill processes and drill assignment rules for a data source. If the TM1 cube, view, or relational table that you are working on contains drill processes or drill assignment rules, you can drill through certain cells to detailed data.
Formula failure behavior
Formula failures in Planning Analytics for Microsoft Excel display as #VALUE, which can be an ambiguous Excel error indicator. In Planning Analytics for Microsoft Excel 2.0.89, the formula failure behavior was improved to simplify error identification.

Parent topic: Planning Analytics for Microsoft Excel