MEMBERS function expects a hierarchy expression

MDX (Multi-Dimensional eXpressions) is a language that allows you to query OLAP(On-Line Analytical processing) cubes

MEMBERS function expects a hierarchy expression

Postby stephen » Tue Dec 02, 2008 6:44 am

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]
stephen
 
Posts: 507
Joined: Thu Feb 09, 2006 9:37 am
Location: Brisbane

Return to MDX

Who is online

Users browsing this forum: No registered users and 0 guests

cron