Excel Functions

TM1 Function – DFRST

Available In

Excel

Definition

DFRST returns the first element in a dimension.

Syntax

DFRST(TM1ServerName:Dimension)

TM1ServerName = Name of the TM1 Server
Dimension = Name of the Dimension

Example

Return the first element in the ‘Account’ dimension.

In the ‘Account’ dimension, ‘Net income %’ is the first element.

In Excel:

DFRST(“AdventureWorks:Account”)

‘Net Income %’ is returned.

Video Demo