AT.FIELD

This function returns the name of the nth field of an attribute table where n is specified as an index number. An attribute table can have 254 fields defined.

Syntax

AT.FIELD(Database alias,Dimension,Attr_Tab_Id,Index)

Attr_Tab_Id is the number of the attribute table being examined (1, 2 or 3) and Index is the number of the field whose name is being requested.

Example

The Interco dimension on the Best Practices sample database alias has two attribute tables. The fields in the first attribute table are "Element Type", "Name" and "Order Position". This formula returns "Name":

AT.FIELD("Best Practices OLAP","Interco",1,2)

The first two arguments for this function may be strings or references to cells containing strings. If strings, they must be enclosed in quotes. The last two arguments must be numbers (in the case of Attr_Tab_Id, 1, 2 or 3) or references to cells containing numbers.

If a field or attribute table number which does not exist is entered, the function returns #Value.