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 «««1234»»

Stairway to MDX - STEP 1: Getting Started with MDX Expand / Collapse
Author
Message
Posted Monday, November 7, 2011 6:31 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 12:52 PM
Points: 13,636, Visits: 11,509
abhijeet.send2me (11/2/2011)
SELECT
{[Date].[Calendar].[Calendar Quarter].&[2007]&[1],
[Date].[Calendar].[Calendar Quarter].&[2007]&[2] } ON AXIS (0),
[Reseller].[Reseller Type].[All Resellers] ON AXIS (1)
FROM [Adventure Works]
where [Measures].[Reseller Sales Amount]

and

SELECT
{[Date].[Calendar].[Calendar Quarter].&[2007]&[1],
[Date].[Calendar].[Calendar Quarter].&[2007]&[2] } ON AXIS (0),
[Reseller].[Reseller Type].[All Resellers] ON AXIS (1)
FROM [Adventure Works]

give me same result. Can somebody explain why ?


If you open the AdventureWorks cube in BIDS, and select the properties of the cube (in the Cube Structure tab), you'll notice that Reseller Sales Amount is chosen as the default measure of the cube. This means that this measure is taken if no measure is selected in the query.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1201385
Posted Monday, November 7, 2011 6:32 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 12:52 PM
Points: 13,636, Visits: 11,509
I'm starting to learn MDX, and this article is a great start.
On to the rest of the articles of this stairway series!




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1201386
Posted Monday, November 7, 2011 9:28 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Sunday, August 17, 2014 7:56 AM
Points: 122, Visits: 94
Thanks.... Got it.
Could you please tell me how can we change this default measure, if we have to !!!
Post #1201534
Posted Monday, November 7, 2011 11:39 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 12:52 PM
Points: 13,636, Visits: 11,509
abhijeet.send2me (11/7/2011)
Thanks.... Got it.
Could you please tell me how can we change this default measure, if we have to !!!


By changing the property DefaultMeasure on the cube? It gives you a nice dropdown box where you can choose the measure that you want.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1201815
Posted Tuesday, November 8, 2011 5:44 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Sunday, August 17, 2014 7:56 AM
Points: 122, Visits: 94
Thanks man... u rock.
Koen Verbeeck (11/7/2011)
abhijeet.send2me (11/7/2011)
Thanks.... Got it.
Could you please tell me how can we change this default measure, if we have to !!!


By changing the property DefaultMeasure on the cube? It gives you a nice dropdown box where you can choose the measure that you want.
Post #1201971
Posted Friday, July 27, 2012 4:31 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, July 27, 2014 10:02 AM
Points: 3, Visits: 7
Hello all!
I'm really proud to join this forum.
I really like the BI topics, and lately, i read several books of stacia Misner.
Can somebody advise me how to contact her?
Thanks in advance.
Post #1336370
Posted Friday, July 27, 2012 5:07 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, August 5, 2013 4:50 AM
Points: 74, Visits: 53
This gona be fun learning.... i will keep looking for this series.. Thanks

[url=http://letslearnssis.blogspot.com][/url]
Post #1336395
Posted Friday, July 27, 2012 6:23 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, July 27, 2014 10:02 AM
Points: 3, Visits: 7
Hello all!
Please where can i find a copy of the book "SQL Server 2008 Reporting Services step by step" of stacia Misner?
I can't buy it at amazon. If somebody can do it for me, i'll appreciate.
Even if i can have a copy in pdf format, i'll be proud of it.
Thanks in advance.
Post #1336439
Posted Monday, July 30, 2012 9:25 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Sunday, December 7, 2014 10:21 PM
Points: 423, Visits: 1,374
I enjoyed it too, but could someone please explain what the following represents, please?

&[1] and the &[2} at the end of the Calender Quarter parts, I'm not sure what they do.

Regards,
D.
Post #1337335
Posted Friday, August 17, 2012 1:44 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, December 10, 2013 11:07 AM
Points: 4, Visits: 19
Another quite good lesson:
http://www.learn-with-video-tutorials.com/mdx-video-tutorial-free
Post #1346374
« Prev Topic | Next Topic »

Add to briefcase «««1234»»

Permissions Expand / Collapse