MEMBERS function expects a hierarchy expression

[stephen]

This query

Code: Select all

select [Customer].[Contacts].members on columns from [Analysis Services Tutorial]

gives this error

The MEMBERS function expects a hierarchy expression for the argument. A member expression was used.

Solution Contacts was not part of the Customer hierarchy, whereas Email Address was.

Code: Select all

select [Customer].[Email Address].Members on columns from [Analysis Services Tutorial]