Excel Functions
TM1 Function – TABDIM
Available In
Excel
Definition
TABDIM returns the dimension name in a cube based on an index.
Syntax
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.
Example
Obtain the dimensions from the Product Scorecard cube.
In Excel, set up a column for the index.
Define the TM1ServerName and Cube.
Use the formula TABDIM($A$1, A3)
e.g. TABDIM(“AdventureWorks:Product Scorecard”, 1)
The first dimension, Version, is returned.
Copy the formula down to get the remaining dimensions.