Sample query SMDX005 - 003 I get error

• MarkA-218060

  SSC Veteran

  Points: 241

  More actions

  September 6, 2011 at 6:51 am

  #244270

  I 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!

  MarkA