TM1RPTVIEW function#
TM1RPTVIEW anchors an Active Form report region. It carries the view reference, the zero-suppression flag, the title members, and the format ranges for the region.
TM1RPTVIEW is part of the native TM1 Active Form family. These functions are normally generated by Planning Analytics for Excel when you build an Active Form, rather than typed by hand; Reportworq evaluates them so an Active Form workbook runs as a report.
Signature#
=TM1RPTVIEW("Server:Cube:ID", zeroSuppression, title1, title2, ... , formatRange, formatIdRange)
Arguments#
| # | Argument | Type | Required | Permitted values and notes |
|---|---|---|---|---|
| 1 | Server:Cube:ID |
String | Yes | A three-part server:cube:id. All three parts are required. |
| 2 | zeroSuppression |
Boolean | Yes | Whether the region suppresses zero rows. |
| 3..N | title members and format ranges | mixed | No | Title member unique names and the region's format ranges, as generated by the Active Form. |
The function returns the view id.
What happens when an argument is wrong#
| Situation | Result |
|---|---|
The first argument is not a three-part server:cube:id |
Hard error - missing parameters |
| Server, cube, or id part is blank | Hard error |
| The region's data named range cannot be found | Hard error |
Related pages#
- IBM Planning Analytics functions - the function index and the shared error model.
- TM1RPTROW function - the dynamic row axis of an Active Form.
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.