ElementFirst

ElementFirst returns the first element of a specified dimension.

This function is valid in both rules and TurboIntegrator processes.

Syntax

ElementFirst(database_name:dimension, hierarchy)

Argument

Description

dimension

A valid dimension name.

hierarchy

The name of the hierarchy within the dimension.

Example

If the North America hierarchy of the Location dimension contains the ordered elements California, Oregon, and Washington, the example returns California.

ElementFirst("planning_sample:Location", "North America")