Page 1 of 1

MEMBERS function expects a hierarchy expression

PostPosted: Tue Dec 02, 2008 6:44 am
by 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]