TABDIM
TABDIM returns the dimension name that corresponds to a given index argument.
Syntax
TABDIM(server:cube, index)|
Argument |
Description |
Required/Optional |
|---|---|---|
|
server:cube |
The name of the TM1® server and a cube name. |
Required |
|
index |
A positive value less than or equal to the total number of dimensions in the cube. The functions returns a blank cell if you enter 0 or if you enter a value greater than the number of dimensions in the cube. |
Required |
Example
In this example, the TM1 server name is GO_New_Stores and
the cube name is Base Sales Forecast. The Base Sales Forecast cube has the following dimensions:
Country and Region, Retailers, Existing Stores Revenue, Store Type, Budget version, and Month. The
function returns Store Type, the fourth dimension in the Base Sales Forecast cube with an index
number of 4.
TABDIM("GO_New_Stores:Base Sales Forecast",4)