DFRST
DFRST returns the first member of a specified dimension. The first member in a dimension is the member with an index number of 1.
The member with an index number of 1 might not be listed first in the tree. Index numbers are assigned to members when they are added to a dimension. For example, if members were added and then reordered, the first member listed in the tree might not have an index of 1.
To determine the index number of a member use the DIMIX function.
Syntax
DFRST(server:dimension)|
Argument |
Description |
Required/Optional |
|---|---|---|
|
server:dimension |
The name of the TM1® server and a dimension name. |
Required |
Example
In this example, the TM1 server name is GO_New_Stores. The function returns the first member in the Retailers dimension, All Retailers. The function returns All Retailers because this member has an index number of 1 in the Retailers dimension.
DFRST("GO_New_Stores:Retailers")