InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 09:59:03 GMT20http://www.sqlservercentral.com/Forums/Topic1201038-17-1.aspxThanks, Steve!(feeling a bit ashamed, this must be basics stuff...)Sat, 05 Nov 2011 20:47:19 GMTHeavyDunkinhttp://www.sqlservercentral.com/Forums/Topic1201038-17-1.aspxI'd say it's the default measure. Believe there's ways to see this in the properties but you can also prove it using the following:[code="other"]selectMeasures.DefaultMember on 0from[Adventure Works][/code]Sat, 05 Nov 2011 11:27:16 GMTstevefromOZhttp://www.sqlservercentral.com/Forums/Topic1201038-17-1.aspxHello,New here, sorry to bother you with what almost certainly is a stupid question. Mayby I should post in the newbies section, though I am no newbie to SQL Server nor T-SQL. However: I am starting with MDX and trying to grasp the basic mechanism behind it. So here's my problem. I run this very simple query against the AdventureWorks cube (the demo from codeplex)SELECT{[Date].[Calendar].[Calendar Quarter].&[2002]&[1], [Date].[Calendar].[Calendar Quarter].&[2002]&[2]} ON AXIS (0),[Employee].[Employee Department] ON AXIS (1)FROM [Adventure Works]This gives me the [b][Reseller Sales Amount] [/b]by Quarter and Employee department. Why is that? I did not specify any slicer axis...If I add a whereclause, say WHERE [Measures].[Internet Sales Amount], I get the Internet Sales Amount, but leave it away and I get the reseler sales amount again.I searched for a while here and there, but found no clue...Admitted, I am a total beginner at MDX and I know I should just go on with the tutorials and probably things will get clearer for me, maybe I am a little impatient, but I like to understand it in some basic conceptual way before I go on...Thanks in advance!Sat, 05 Nov 2011 08:21:57 GMTHeavyDunkin