DIMNM returns an element's primary name based on an index in a dimension.
Where can the DIMNM function be used?
Excel, Rules and TurboIntegrator
What is the DIMNM function?
DIMNM returns an element’s primary name based on an index in a dimension.
What is the syntax for DIMNM?
DIMNM(Dimension, Index)
Dimension = Dimension Name
Index = A value less than or equal to the number of elements in the dimension.
A demonstration on how to use DIMNM
In the System info cube, we will use Calendar Year to retrieve the name of the index number 15 in the dimension Year.
See how Cubewise can help you
We would love to show you how a set of applications could help you forecast, budget and plan better.
Book