AT.FIELDCOUNT

This function returns the number of fields of an attribute table for a given dimension. An attribute table can have 254 fields defined.

Syntax

AT.FIELDCOUNT(Database alias,Dimension,Attr_Tab_Id)

Attr_Tab_Id is the number of the attribute table being examined (1, 2 or 3).

Example

The Product dimension on the Best Practices sample database alias has three attribute tables and there are three fields in the first attribute table. This returns 3:

AT.FIELDCOUNT("Best Practices OLAP","[Product]",1)

The first two arguments may be strings or references to cells containing strings. Strings must be enclosed in quotes. The last argument must be a number from 1 to 3 or a reference to a cell containing a number from 1 to 3.