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

Wy do I see a Reseller Sales Amount in mx query on AW cube? Expand / Collapse
Author
Message
Posted Saturday, November 5, 2011 8:21 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, December 10, 2011 4:33 PM
Points: 2, Visits: 6
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!
Post #1201038
Posted Saturday, November 5, 2011 11:27 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: Moderators
Last Login: Wednesday, August 6, 2014 8:12 AM
Points: 1,815, Visits: 3,456
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.
Post #1201068
Posted Saturday, November 5, 2011 8:47 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, December 10, 2011 4:33 PM
Points: 2, Visits: 6
Thanks, Steve!
(feeling a bit ashamed, this must be basics stuff...)
Post #1201104
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse