SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by Bill_Pearson / Sample query SMDX005 - 003 I get error / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 14:22:15 GMT20Sample query SMDX005 - 003 I get errorhttp://www.sqlservercentral.com/Forums/Topic1170347-2861-1.aspxI get the following error:The MEMBERS function expects a hierarchy expression for the argument. A member expression was used.when I try to run:SELECT { [Measures].[Reseller Order Quantity], [Measures].[Reseller Sales Amount] } ON AXIS(0), NON EMPTY { [Date].[Calendar].[Calendar Year].MEMBERS } ON AXIS(1)FROM [Adventure Works]I'm running SQL SERVER 2008 R2...Great tutorial...Thanks in advance!MarkATue, 06 Sep 2011 06:51:59 GMTMarkA-218060