DIMNM
DIMNM returns the member of a dimension that corresponds to the index
argument.
Syntax
DIMNM(server:dimension, index, [Alias])|
Argument |
Description |
Required/Optional |
|---|---|---|
|
server:dimension |
The name of the TM1® server and a dimension name. |
Required |
|
index |
A value less than or equal to the number of members in the dimension. The functions returns a blank cell if you enter 0 or if you enter a value greater than the number of members in the dimension. |
Required |
Example
In this example, the TM1 server name is GO_New_Stores. The
function returns the name of the member with an index of 7 in the Products dimension. If the Tents
member has an index number of 7, for example, the function returns Tents.
DIMNM("GO_New_Stores:Products",7)