AT.NAME

Attribute tables are stored as separate files in the database directory. This function returns the file name of an attribute table for a specified dimension.

Syntax

AT.NAME(Database alias,Dimension,Attr_Tab_Id)

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

The Product dimension on the Best Practices sample database alias has an attribute table with the file name PRODUCT.D01 This function returns "PRODUCT.D01":

AT.NAME("Best Practices OLAP","Product",1)

The first two arguments for this function can 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.