<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by Bill_Pearson
»
Stairway to MDX - STEP 1: Getting Started...
32 posts, Page 1 of 4
1
2
3
4
»
»»
Stairway to MDX - STEP 1: Getting Started with MDX
Rate Topic
Display Mode
Topic Options
Author
Message
Bill_Pearson
Bill_Pearson
Posted Wednesday, December 08, 2010 10:03 AM
Forum Newbie
Group: General Forum Members
Last Login: 2 days ago @ 6:46 AM
Points: 1,
Visits: 47
Comments posted to this topic are about the item
Stairway to MDX - STEP 1: Getting Started with MDX
Post #1032008
Raunak Jhawar
Raunak Jhawar
Posted Wednesday, March 02, 2011 2:00 AM
SSC Eights!
Group: General Forum Members
Last Login: Wednesday, May 15, 2013 11:25 PM
Points: 946,
Visits: 1,739
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
Dwayne Dibley
Dwayne Dibley
Posted Wednesday, March 02, 2011 3:10 AM
Old Hand
Group: General Forum Members
Last Login: Yesterday @ 6:56 AM
Points: 365,
Visits: 2,912
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
sharath.chalamgari
sharath.chalamgari
Posted Wednesday, March 02, 2011 3:23 AM
Ten Centuries
Group: General Forum Members
Last Login: Yesterday @ 5:37 AM
Points: 1,054,
Visits: 687
Great article, i am looking forward for the series
Post #1071799
yanaty999
yanaty999
Posted Wednesday, March 02, 2011 7:13 AM
Valued Member
Group: General Forum Members
Last Login: Thursday, June 06, 2013 8:42 AM
Points: 56,
Visits: 153
"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
Alvaro Reis
Alvaro Reis
Posted Wednesday, March 02, 2011 7:30 AM
Forum Newbie
Group: General Forum Members
Last Login: Tuesday, April 16, 2013 12:59 PM
Points: 2,
Visits: 33
This is a great introduction to MDX world.
Post #1071909
Raunak Jhawar
Raunak Jhawar
Posted Wednesday, March 02, 2011 7:35 AM
SSC Eights!
Group: General Forum Members
Last Login: Wednesday, May 15, 2013 11:25 PM
Points: 946,
Visits: 1,739
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
Alvaro Reis
Alvaro Reis
Posted Wednesday, March 02, 2011 7:46 AM
Forum Newbie
Group: General Forum Members
Last Login: Tuesday, April 16, 2013 12:59 PM
Points: 2,
Visits: 33
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
yanaty999
yanaty999
Posted Wednesday, March 02, 2011 7:58 AM
Valued Member
Group: General Forum Members
Last Login: Thursday, June 06, 2013 8:42 AM
Points: 56,
Visits: 153
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
nmrchalla
nmrchalla
Posted Wednesday, March 02, 2011 8:40 AM
Forum 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 »
32 posts, Page 1 of 4
1
2
3
4
»
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
