Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Sample query SMDX005 - 003 I get error Expand / Collapse
Author
Message
Posted Tuesday, September 6, 2011 6:51 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, June 5, 2014 8:18 AM
Points: 25, Visits: 118
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
Post #1170347
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse