Any suggestions? Export (0) Print
Expand All
Avg
IIf
Lag
Max
Min
Mtd
Qtd
Sum
Var
Wtd
Ytd
Collapse the table of content
Expand the table of content
Expand Minimize

NameToSet (MDX)

Updated: 17 July 2006

Returns a set that contains the member specified by a Multidimensional Expressions (MDX)–formatted string.


NameToSet(Member_Name) 

Member_Name

A valid string expression that represents the name of a member.

If the specified member name exists, the NameToSet function returns a set containing that member. Otherwise, the function returns an empty set.

ms146035.note(en-US,SQL.90).gifNote:
The specified member name must only be a member name; it cannot be a member expression. To use a member expression, see StrToSet (MDX).

Example

The following returns the default measure value for the specified member name.

SELECT NameToSet('[Date].[Calendar].[July 2001]') ON 0
FROM [Adventure Works]

Release History

17 July 2006

Changed content:
  • Updated syntax and arguments to improve clarity.
  • Added updated examples.

Community Additions

ADD
Show:
© 2016 Microsoft