TM1RPTROW function#
TM1RPTROW defines the dynamic row axis of an Active Form region - the rows that grow and shrink with the underlying subset, element list, or MDX set.
TM1RPTROW is part of the native TM1 Active Form family. It is normally generated by Planning Analytics for Excel rather than typed by hand.
Signature#
=TM1RPTROW(viewId, "Server:Dimension", subset, elementList, alias, expandAbove, mdxStatement, indentations, consolidationDrilling)
Arguments#
| # | Argument | Type | Required | Permitted values and notes |
|---|---|---|---|---|
| 1 | viewId |
String | Yes | The Active Form view id from TM1RPTVIEW. |
| 2 | Server:Dimension |
String | Yes | "server:dimension" for the row axis. |
| 3 | subset |
String | No | A named subset for the axis. |
| 4 | elementList |
Range | No | A cell range of element names. |
| 5 | alias |
String | No | An alias attribute to display. |
| 6 | expandAbove |
Boolean | No | Whether consolidations expand above their children. |
| 7 | mdxStatement |
String | No | An MDX set expression for the axis. |
| 8 | indentations |
Integer | No | Indent step per level. Defaults to 1. |
| 9 | consolidationDrilling |
Boolean | No | Defaults to on. |
viewId, server, and dimension are required. When more than one row source is supplied, the axis is chosen in this precedence: element list, then MDX, then subset, then the whole dimension.
What happens when an argument is wrong#
| Situation | Result |
|---|---|
| Fewer than two arguments | Hard error - missing parameters |
viewId, server, or dimension blank |
Hard error |
The cell defers to Active Form processing and briefly shows #VALUE! while the region expands; this is normal timing, not an error.
Related pages#
- IBM Planning Analytics functions - the function index and the shared error model.
- TM1RPTVIEW function - the Active Form anchor.
Feedback on this page
Comments, questions, requests, or something missing or unclear? Email us - the page you are on is filled in for you.
Email feedback on this pageOr write to support@reportworq.com directly.