November 5, 2011 at 8:21 am
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!
November 5, 2011 at 11:27 am
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.
November 5, 2011 at 8:47 pm
Thanks, Steve!
(feeling a bit ashamed, this must be basics stuff...)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply