TM1RptFilter function for IBM Planning Analytics (TM1)
Where can the TM1RptFilter function be used?
Which TM1 Server version is the TM1RptFilter function available for?
What is the syntax for TM1RptFilter?
- 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
- TM1RptFilter = Apply a filter to the Dynamic report to sort the row based on a column
- 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
