TM1RptView function for IBM Planning Analytics (TM1)
TM1RptView controls the definition of the report like zero suppression and the format area. Used for Dynamic Reports (Active Form).
In the video, the TM1RptView will be used in a Dynamic Report to suppress and un-suppress zeros on the row set.
Where can the TM1RptView function be used?
Excel
Which TM1 Server version is the TM1RptView function available for?
Version 11 and 12
What is the syntax for TM1RptView?
TM1RptView(ViewID, ZeroSuppression, TM1RptTitle1, TM1RptTitleN, TM1RptFmtRng, TM1RptFmtIDCol)
- ViewID = a ID that uniquely identifies the Dynamic report. The format is TM1ServerName:Cube:UniqueID
- ZeroSuppression = controls row zero suppression. 1 to suppress, 0 to un-suppress
- TM1RptTitle = TM1RptTitle function per title dimension.
- TM1RptFmtRngUniqueID = Dynamic report format area
- TM1RptFmtIDColUniqueID = ID of each row for the Dynamic Report format area
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
- TM1RptTitle = Used to define the title dimension