The EvDES (Description) function returns the description of a specified member. If the same member name is used in more than one dimension, you must specify the fully qualified member ID, which includes the dimension name. Use the following syntax: Dimension:Member.
Syntax
EvDES(MemberID,AppName)
MemberID
— The member ID for which you want to return a description.
AppName
— The name of the application. This is required if the corresponding dimension does not exist in the active application.
Example
The entries EvDES(A2) and EvDES(HC) return Headcount, when cell A2 contains the member ID HC.
EvDES(JPY,RATE) returns Japanese Yen, when Japanese Yen is the description of the member JPY in the Rate application.