TM1 Function for Excel, DFRST

DFRST returns the first element in a dimension.

Where can the DFRST function be used?

Excel

What is the DFRST function?

DFRST returns the first element in a dimension.

What is the syntax for DFRST?

DFRST(TM1ServerName:Dimension)
TM1ServerName = Name of the TM1 Server
Dimension = Name of the Dimensionย 

A demonstration on how to use DFRST

Return the first element in the Account dimension.