HIDDENTEXT

Returns the hidden text of a member value.

Syntax

HIDDENTEXT(member)

• member - the member value, from which the hidden text should be returned - Value type: member

Remarks

• See the description of the function CREATEMEMBER to get more information about member value types.

Examples

In this example, the memberTable has been created by the function CREATEMEMBER, based on the tables displayTexts and hiddenTexts. Then the function HIDDENTEXT can be used later to extract the hidden texts from memberTable.

In this example, the HIDDENTEXT function returns the unique texts from dimension elements coming from Analysis Services.