TABDIM function#
TABDIM returns the name of the dimension at a given position in a cube.
TABDIM is a native TM1 / Planning Analytics function.
Signature#
=TABDIM("Server:Cube", index)
Arguments#
| # | Argument | Type | Required | Permitted values and notes |
|---|---|---|---|---|
| 1 | Server:Cube |
String | Yes | "server:cube". |
| 2 | index |
Integer | Yes | The dimension position, 1-based. Must be a whole number of at least 1. |
TABDIM takes exactly two arguments.
What happens when an argument is wrong#
For the shared error model and the Calc Mode effect, see how Reportworq handles errors.
| Situation | Result |
|---|---|
| More than two arguments | Hard error |
| Fewer than two arguments | Warning, the cell returns blank |
| A missing (empty) index | Warning, blank |
| A blank-string index | Hard error |
| An index that cannot be parsed to a number | Hard error |
index less than 1 |
Warning, blank |
index greater than the cube's dimension count |
Warning, blank |
| The cube is not found | Warning, blank |
Examples#
=TABDIM("PlanTM1:Sales", 1)
Related pages#
- IBM Planning Analytics functions - the function index and the shared error model.
- DIMSIZ function - the number of elements in a dimension.
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.