DFRST function#
DFRST returns the first element (index 1) in a dimension - a starting point for walking a dimension in order.
DFRST is a native TM1 / Planning Analytics function.
Signature#
=DFRST("Server:Dimension")
Arguments#
| # | Argument | Type | Required | Permitted values and notes |
|---|---|---|---|---|
| 1 | Server:Dimension |
String | Yes | "server:dimension". |
DFRST takes exactly one argument. The default result is an empty string.
What happens when an argument is wrong#
For the shared error model and the Calc Mode effect, see how Reportworq handles errors.
| Situation | Result |
|---|---|
| More than one argument | Hard error |
| No argument | Warning, blank |
| Dimension not found, or it has no elements | Warning, blank |
Examples#
=DFRST("PlanTM1:Period")
Related pages#
- IBM Planning Analytics functions - the function index and the shared error model.
- DNEXT function - the next element after a given one.
Feedback on this page
Comments, questions, requests, or something missing or unclear? Email us - the page you are on is filled in for you.
Email feedback on this pageOr write to support@reportworq.com directly.