TM1RptFilter function for IBM Planning Analytics (TM1)
TM1RptFilter is used to apply a filter to the Dynamic Report to sort the row based on a column. Used for Dynamic Reports (Active Form).
In the video, the TM1RptElLev will be used in a Dynamic Report to sort the values in descending order for Q1 from the Quarter dimension.
Where can the TM1RptFilter function be used?
Excel
Which TM1 Server version is the TM1RptFilter function available for?
Version 11 and 12
What is the syntax for TM1RptFilter?
TM1RPTFILTER(TM1RptView, Tuple, FilterFunction, FilterValue, SortOrder)
- TM1RptView = reference to the TM1RPTVIEW function from a Dynamic Report
- Tuple = the column to filter
- FilterFunction = one of these functions: TopCount, BottomCount, TopPercent, BottomPercent, TopSum, BottomSum or leave empty for all
- FilterValue = a numerical value (OPTIONAL)
SortOrder = one of these orders: asc (ascending), desc (descending)
Relevant Functions
- TM1RptElIsConsolidated = Returns a boolean value if an element is consolidated
- TM1RptElIsExpanded = Returns a boolean value if an element is expanded on the row set
- TM1RptElLev = Returns an element’s level relative to the root in the subset
- TM1RptRow = Returns the row set in a Dynamic Report
- TM1RptView = controls the definition of the report like zero suppression and the format area
- TM1RptTitle = Used to define the title dimension