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)
ON AXIS (0),
ON AXIS (1)
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!