InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 03:45:23 GMT20http://www.sqlservercentral.com/Forums/Topic1032008-2861-1.aspxThis is great. Looking forward to finishing this series. I've been working my way through a book recently where the writing style lacks both the precision and brevity of this article, so I'm finding this very refreshing. Thank you!Sat, 11 May 2013 14:06:42 GMTben111http://www.sqlservercentral.com/Forums/Topic1032008-2861-1.aspxVery good. After learning to build, configure and deploy cubes this is an excellent next step.Mon, 01 Oct 2012 01:53:55 GMTRobin Sassonhttp://www.sqlservercentral.com/Forums/Topic1032008-2861-1.aspxAnother quite good lesson:http://www.learn-with-video-tutorials.com/mdx-video-tutorial-freeFri, 17 Aug 2012 01:44:04 GMTarturm_007http://www.sqlservercentral.com/Forums/Topic1032008-2861-1.aspxI 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.Mon, 30 Jul 2012 09:25:37 GMTDuranhttp://www.sqlservercentral.com/Forums/Topic1032008-2861-1.aspxHello 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.Fri, 27 Jul 2012 06:23:50 GMTdepolo81http://www.sqlservercentral.com/Forums/Topic1032008-2861-1.aspxThis gona be fun learning.... i will keep looking for this series.. Thanks [url=http://letslearnssis.blogspot.com][/url]Fri, 27 Jul 2012 05:07:30 GMTqutubhttp://www.sqlservercentral.com/Forums/Topic1032008-2861-1.aspxHello 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.Fri, 27 Jul 2012 04:31:24 GMTdepolo81http://www.sqlservercentral.com/Forums/Topic1032008-2861-1.aspxThanks man... u rock.[quote][b]Koen Verbeeck (11/7/2011)[/b][hr][quote][b]abhijeet.send2me (11/7/2011)[/b][hr]Thanks.... Got it. Could you please tell me how can we change this default measure, if we have to !!![/quote]By changing the property DefaultMeasure on the cube? It gives you a nice dropdown box where you can choose the measure that you want.[/quote]Tue, 08 Nov 2011 05:44:50 GMTabhijeet.send2mehttp://www.sqlservercentral.com/Forums/Topic1032008-2861-1.aspx[quote][b]abhijeet.send2me (11/7/2011)[/b][hr]Thanks.... Got it. Could you please tell me how can we change this default measure, if we have to !!![/quote]By changing the property DefaultMeasure on the cube? It gives you a nice dropdown box where you can choose the measure that you want.Mon, 07 Nov 2011 23:39:37 GMTKoen Verbeeckhttp://www.sqlservercentral.com/Forums/Topic1032008-2861-1.aspxThanks.... Got it. Could you please tell me how can we change this default measure, if we have to !!!Mon, 07 Nov 2011 09:28:01 GMTabhijeet.send2mehttp://www.sqlservercentral.com/Forums/Topic1032008-2861-1.aspxI'm starting to learn MDX, and this article is a great start.On to the rest of the articles of this stairway series!Mon, 07 Nov 2011 06:32:30 GMTKoen Verbeeckhttp://www.sqlservercentral.com/Forums/Topic1032008-2861-1.aspx[quote][b]abhijeet.send2me (11/2/2011)[/b][hr]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]andSELECT{[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 ?[/quote]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.Mon, 07 Nov 2011 06:31:37 GMTKoen Verbeeckhttp://www.sqlservercentral.com/Forums/Topic1032008-2861-1.aspxSELECT{[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]andSELECT{[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 ?Wed, 02 Nov 2011 07:47:12 GMTabhijeet.send2mehttp://www.sqlservercentral.com/Forums/Topic1032008-2861-1.aspxNewbie Question I was referenced this series by a post on the forums but after reading the highlights (not the article in full) I'm not sure this is the right starting point.I am familiar with BI in the buzz words and some terms but all of my DB experience has been on the relational model side and not in Data warehouses or Cubes and certainly not MDX. I inquired about the Date Warehouse/Model/Cube business because I thought it might provide a solution for reporting performance issues we have but now I'm not so sure. Part of my problem is that I believe many of the BI terms like Data MArt and Data Warehouse have been misused by others I have listened to and so I have the incorrect idea of what these are and how they work. Is there any non-BI guru overview of ANALYSIS SEVICES and when/why/how to use it and how it relates to the traditional relation database model?ThanksTue, 31 May 2011 13:15:01 GMTYSLGuruhttp://www.sqlservercentral.com/Forums/Topic1032008-2861-1.aspx[quote][b]Mhlewis (5/25/2011)[/b][hr]You should be able to limit the access to read only of the tables you need to build your cube.[/quote]But it will be necessary to give the NT AUTHORITY\NETWORK SERVICE access to the underlying database? Can't some other account be used for this?Wed, 25 May 2011 15:28:29 GMTpaulnhttp://www.sqlservercentral.com/Forums/Topic1032008-2861-1.aspxYou should be able to limit the access to read only of the tables you need to build your cube.Wed, 25 May 2011 14:37:53 GMTMWisehttp://www.sqlservercentral.com/Forums/Topic1032008-2861-1.aspxI'm having a problem with getting the cubes setup. I deployed the Adventure Works DW 2008 SE to my local machine and when I connect to the Analysis Server I can see the Adventure Works DW 2008R2 SE database. And I can drill down and see the Adventure Works cube, and drill further I see Measure Groups. But when I highlighted the AW cube and clicked New Query I get a message: "Error loading metadata. No cubes were found". So I clicked the Process and get an error 'The datasource, "Adventure Works DW', contains an ImpersonationMode that is not supported for processing operations."This is the same set of errors I was getting when I initially tried to deploy from BIDS. I found a post on here about this and changed the Deployment option to 'Do not process' and the Impersonation Information of the Data Source to 'Use the credentials of the current user'.What security settings do I need to process these cubes?*************************************************************************************Well, one of the errors from some setting on the Inheritance tab referred to NT Network Authority. So, I gave that account db_owner on the AWDW2008R2 and I was able to process the project in BIDS. And I have items in the Measure Group of the query &#119;indow.Now the question is whether I have to always give NT AUTHORITY\NETWORK SERVICE db_owner rights to the databases I want to participate in AS?Thanks.Wed, 25 May 2011 10:33:38 GMTpaulnhttp://www.sqlservercentral.com/Forums/Topic1032008-2861-1.aspxNice intro.. good to read.Thu, 03 Mar 2011 23:46:33 GMTAnipaulhttp://www.sqlservercentral.com/Forums/Topic1032008-2861-1.aspxJust about to cube a new warehouse, so this couldn't have come at a better time! Thanks!Thu, 03 Mar 2011 09:28:07 GMTamenjonathanhttp://www.sqlservercentral.com/Forums/Topic1032008-2861-1.aspxThanks for the series Bill.Thanks,Thomas LeBlancTheSmilingDBAWed, 02 Mar 2011 13:50:49 GMTThomas LeBlanchttp://www.sqlservercentral.com/Forums/Topic1032008-2861-1.aspxGreat article! I am looking forward to the future articles in the series. I wonder if power-pivot deals adequately with rendering axis beyond the second in excel. I worked with Proclarity back in 2005 and it had great rendering and building capability. I wrote a lot of MDX back then with functions, named sets, calculated members etc. However, being that I had to figure it out on my own I didn't do a great job of classifying it in my mind in a way that I could remember. I remember some of the functions being very counter intuitive and I am hopeful that this series will give me a better way to think about them.Wed, 02 Mar 2011 13:29:26 GMTToby Whitehttp://www.sqlservercentral.com/Forums/Topic1032008-2861-1.aspxI've relied on Mr. Pearson's Database Journal MDX and SSRS series for a while now, so I'm thrilled to see this series here - especially since it is targetted to 2008R2. About 90% of our reporting system uses SSRS to query cubes and I end up having to troubleshoot and clean up a lot of MDX that comes out of the GUI query designer in SSRS. I've love to see an article that takes on that topic.Thanks,MWiseWed, 02 Mar 2011 11:22:55 GMTMWisehttp://www.sqlservercentral.com/Forums/Topic1032008-2861-1.aspxLooking for next in the series. Nice introducton to MDX. It helps a lotWed, 02 Mar 2011 08:40:21 GMTnmrchallahttp://www.sqlservercentral.com/Forums/Topic1032008-2861-1.aspxThank 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!TatyanaWed, 02 Mar 2011 07:58:40 GMTyanaty999http://www.sqlservercentral.com/Forums/Topic1032008-2861-1.aspxI 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], soTry this:SELECT {[Measures].[Internet Sales Amount], [Measures].[Internet Order Count]} on axis 0,{[Date].[Fiscal Year].members} * {[Customer].[Country].members} on axis 1FROM [Adventure Works]If this is not what you are trying to do let me know.Wed, 02 Mar 2011 07:46:45 GMTAlvaro Reishttp://www.sqlservercentral.com/Forums/Topic1032008-2861-1.aspx[quote][b]yanaty999 (3/2/2011)[/b][hr]"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[/quote]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!!!Wed, 02 Mar 2011 07:35:33 GMTRaunak Jhawarhttp://www.sqlservercentral.com/Forums/Topic1032008-2861-1.aspxThis is a great introduction to MDX world.Wed, 02 Mar 2011 07:30:37 GMTAlvaro Reishttp://www.sqlservercentral.com/Forums/Topic1032008-2861-1.aspx"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, -TatyanaWed, 02 Mar 2011 07:13:44 GMTyanaty999http://www.sqlservercentral.com/Forums/Topic1032008-2861-1.aspxGreat article, i am looking forward for the seriesWed, 02 Mar 2011 03:23:45 GMTsharath.chalamgarihttp://www.sqlservercentral.com/Forums/Topic1032008-2861-1.aspxMDX 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.Wed, 02 Mar 2011 03:10:05 GMTDwayne Dibleyhttp://www.sqlservercentral.com/Forums/Topic1032008-2861-1.aspxBrilliant Read!!!Not many articles on MDX. Great Job!!:-)Wed, 02 Mar 2011 02:00:49 GMTRaunak Jhawarhttp://www.sqlservercentral.com/Forums/Topic1032008-2861-1.aspxComments posted to this topic are about the item [B]<A HREF="/articles/Stairway+Series/71867/">Stairway to MDX - STEP 1: Getting Started with MDX</A>[/B]Wed, 08 Dec 2010 10:03:08 GMTBill_Pearson