DFrst function for IBM Planning Analytics (TM1)
DFrst returns the first element in a dimension.
In the video, DFrst will be used to return the first element in the Account dimension.
Where can the DFrst function be used?
Excel
Which TM1 Server version is the DFrst function available for?
Version 11 and 12
What is the syntax for DFrst?
DFrst(TM1ServerName:Dimension)
- TM1ServerName = Name of the TM1 Server
- Dimension = Name of the Dimension
Relevant Functions
- DFrst = Returns the first element in a dimension
- DimIx = Returns an element’s index number in a dimension
- DimNm = Returns an element’s primary name based on an index in a dimension
- DimSiz = Returns the number of elements in a dimension
- DNext = Returns the next element based on the index in a dimension
- DNLev = Returns the number of levels in a dimension
- DType = Returns the element type in a dimension