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

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Analysis Services » Wy do I see a Reseller Sales Amount in mx...

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

Rate Topic

Display Mode

Topic Options

Author

Message

HeavyDunkin

Posted Saturday, November 05, 2011 8:21 AM

Forum 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

stevefromOZ

Posted Saturday, November 05, 2011 11:27 AM

SSCommitted

Group: Moderators
Last Login: Today @ 10:57 AM
Points: 1,763, Visits: 3,190

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

HeavyDunkin

Posted Saturday, November 05, 2011 8:47 PM

Forum 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 »

Permissions