VIEW function#
VIEW assembles a server:cube:viewId reference string, used to bind a block of DBRW formulas to a defined cube view.
VIEW is a native TM1 / Planning Analytics function.
Signature#
=VIEW("Server:Cube:ViewID", ...)
Arguments#
| # | Argument | Type | Required | Permitted values and notes |
|---|---|---|---|---|
| 1 | Server:Cube[:ViewID] |
String | Yes | Parsed into server, cube, and view id; the function returns them re-joined with colons. |
| 2..N | extra | any | No | Accepted but not used to build the returned string. |
VIEW is documented as taking three arguments.
What happens when an argument is wrong#
| Situation | Result |
|---|---|
| Fewer than three arguments | Warning, the cell returns blank |
| A blank or missing first argument | Warning, blank |
| An Excel error value in the first argument | Hard error, the cell shows #VALUE! |
Examples#
=VIEW("PlanTM1:Sales:Q1Plan")
Related pages#
- IBM Planning Analytics functions - the function index and the shared error model.
- DBRW function - retrieve a cube cell value.
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.