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.

Video Demo