You can use Dynamic Reports to create complex reports that combine the functionality of IBM® TM1® with Microsoft Excel features.
Dynamic Reports are implemented through a series of worksheet functions that define the components of a form, such as context members, row members, and display properties. When you convert an Exploration View to a Dynamic Report, the functions are created for you.
Dynamic Reports support features available in explorations and Quick Reports, such as selectable context members, stacked row and column dimensions, expandable/collapsible consolidations (rows only), zero suppression (rows only), and inserting rows and columns (with some restrictions).
You can use a filter by adding the TM1RPTFILTER function, for more information, see TM1RPTFILTER.
In addition, you can define dynamic formatting for the Dynamic Report by using standard Microsoft Excel format options directly in the worksheet.
Column dimensions are static in Dynamic Reports. You cannot expand or collapse consolidated column members in a Dynamic Report by clicking them. Although the column dimension members are set when you create the Dynamic Report, you can manually edit column members. When you enter a valid member name for a column member, the Dynamic Report returns values from the server.