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