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 Wednesday, December 8, 2010 10:03 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, January 14, 2014 8:22 PM
Points: 2, Visits: 63
Comments posted to this topic are about the item Stairway to MDX - STEP 1: Getting Started with MDX
Post #1032008
Posted Wednesday, March 2, 2011 2:00 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, June 18, 2014 3:28 AM
Points: 1,044, Visits: 1,839
Brilliant Read!!!

Not many articles on MDX. Great Job!!


Regards/Raunak
Now a member of Linkedin

Please visit the all new Performance Point Forum
Please visit the all new Data Mining and Business Analytics Forum
Post #1071778
Posted Wednesday, March 2, 2011 3:10 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, July 17, 2014 6:52 AM
Points: 377, Visits: 3,059
MDX is something I have not had the opportunity to delve in, but wanted to know more about. This is a great introduction and I look forward to the rest of the series.
Post #1071795
Posted Wednesday, March 2, 2011 3:23 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 2:49 AM
Points: 1,179, Visits: 783
Great article, i am looking forward for the series
Post #1071799
Posted Wednesday, March 2, 2011 7:13 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, July 9, 2014 8:53 AM
Points: 58, Visits: 194
"MDX query can have up to 128 axes"… So I tried this:

SELECT {[Measures].[Internet Sales Amount],
[Measures].[Internet Order Count]} on axis(0)
, {[Date].[Fiscal Year].members} on axis (1)
, [Customer].[Country].members on axis(2)
FROM [Adventure Works]

And received an error: Results cannot be displayed for cellsets with more than two axes.
So, are there additional rules for more-than-2-axis queries? I'd like visualize such a query...

Thank you, -
Tatyana
Post #1071897
Posted Wednesday, March 2, 2011 7:30 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, July 26, 2013 11:38 AM
Points: 2, Visits: 34
This is a great introduction to MDX world.
Post #1071909
Posted Wednesday, March 2, 2011 7:35 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, June 18, 2014 3:28 AM
Points: 1,044, Visits: 1,839
yanaty999 (3/2/2011)
"MDX query can have up to 128 axes"… So I tried this:

SELECT {[Measures].[Internet Sales Amount],
[Measures].[Internet Order Count]} on axis(0)
, {[Date].[Fiscal Year].members} on axis (1)
, [Customer].[Country].members on axis(2)
FROM [Adventure Works]

And received an error: Results cannot be displayed for cellsets with more than two axes.
So, are there additional rules for more-than-2-axis queries? I'd like visualize such a query...

Thank you, -
Tatyana


Good observation. SSMS has a limitation. It cannot visualize cell sets beyond 2 axes. So, if the need arises, you will have a build your own application consuming the ADOMD.NET assemblies. This is the the only approach I can think of, until unless the MS itself starts offering a custom solution. All the best!!!


Regards/Raunak
Now a member of Linkedin

Please visit the all new Performance Point Forum
Please visit the all new Data Mining and Business Analytics Forum
Post #1071916
Posted Wednesday, March 2, 2011 7:46 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, July 26, 2013 11:38 AM
Points: 2, Visits: 34
I think what you are trying to do is getting [Internet Sales Amount] and [Internet Order Count] breaking down by all [Fiscal Year] and [Customer].[Country], so

Try this:

SELECT {[Measures].[Internet Sales Amount], [Measures].[Internet Order Count]} on axis 0,
{[Date].[Fiscal Year].members} * {[Customer].[Country].members} on axis 1
FROM [Adventure Works]

If this is not what you are trying to do let me know.
Post #1071932
Posted Wednesday, March 2, 2011 7:58 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, July 9, 2014 8:53 AM
Points: 58, Visits: 194
Thank you, Alvaro. Yes, your query gives me a result I wanted. I just thought that this could be done, as well, with the "pages" axis (mentioned in the article). Now I see, from the Raunak's answer to my question, that SSMS's limitations would not allow to explicitly use the third (and up) dimension... Oh well :)
Thank you!
Tatyana
Post #1071946
Posted Wednesday, March 2, 2011 8:40 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, May 16, 2011 7:07 AM
Points: 1, Visits: 22
Looking for next in the series. Nice introducton to MDX. It helps a lot
Post #1071985
« Prev Topic | Next Topic »

Add to briefcase 1234»»»

Permissions Expand / Collapse