TabDim function for IBM Planning Analytics (TM1)
TabDim returns the dimension name in a cube based on an index.
In this video, TabDim will be used to obtain the dimensions from the Product Scorecard cube.
Where can the TabDim function be used?
Excel, Rules and TurboIntegrator
Which TM1 Server version is the TabDim function available for?
Version 11 and 12
What is the syntax for TabDim?
TabDim(TM1ServerName:Cube, Index)
- TM1ServerName = Name of the TM1 Server
- Cube = Name of the Cube
- Index = A number less than or equal to the number of Dimensions in the Cube
Relevant Functions
- DFrst = Returns the first element in a dimension
- DimIx = Returns an element’s index number in a dimension
- DimNm = Returns an element’s primary name based on an index in a dimension
- DimSiz = Returns the number of elements in a dimension
- DNext = Returns the next element based on the index in a dimension
- DType = Returns the element type in a dimension
- DNLev = Returns the number of levels in a dimension
- TabDim = Returns the dimension name in a cube based on an index