NameToSet

Analysis Services

Analysis Services

NameToSet

Returns a set containing a single member based on a string expression containing a member name.

Syntax

NameToSet(«Member Name»)

Remarks

If the member name specified in «Member Name» exists, a set containing that member is returned. Otherwise, the NameToSet function returns an empty set.

Example

The following function returns a set containing the [Quarter 1] member of the Time dimension:

NameToSet("[Time].[Quarter 1]")