TDIM.NAME

Returns the name of a dimension in a specified cube.

Syntax

TDIM.NAME(Database alias,Cube,Index)

The cube COST has eight dimensions. This formula returns LEVEL - the fourth dimension in the cube:

TDIM.NAME("Best Practices OLAP","COST",4)

The first two arguments can be strings or references to cells containing strings. If strings, they must be enclosed in quotes. The last argument must be an integer.

If a cube that is not available is entered, the function returns a #Value error. If an index number is entered that is greater than the number of dimensions in the cube, a #Value error will be returned.