Wy do I see a Reseller Sales Amount in mx query on AW cube?

• HeavyDunkin

  Grasshopper

  Points: 22

  More actions

  November 5, 2011 at 8:21 am

  #148821

  Hello,

  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 [Reseller Sales Amount] 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!

• stevefromOZ

  SSC-Forever

  Points: 43646

  More actions

  November 5, 2011 at 11:27 am

  #1403649

  I'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:

  select

  Measures.DefaultMember on 0

  from

  [Adventure Works]

  Steve.

• HeavyDunkin

  Grasshopper

  Points: 22

  More actions

  November 5, 2011 at 8:47 pm

  #1403678

  Thanks, Steve!

  (feeling a bit ashamed, this must be basics stuff...)