Browse by Tags

• adssug
• Analysis Services
• ASSP
• Attribute Relationships
• best practices
• cumulative updates
• Discover
• dmv
• hotfixes
• Many to Many
• performance
• query
• Reporting Services
• sql
• SQL Server
• ssas
• tsql
• tuning

• Infinite Drill-through in a single SSRS report

  Grant Paisley of Angry Koala and Report Surfer put me onto this a while back, and I have to admit I’m a bit of a fan. The idea comes from the fact the way that SQL Server Reporting Services (both 2005 and 2008) handles parameters with Analysis Services, Read More... Posted Monday, December 21, 2009 8:18 PM from Rob Farley | (Comments Off) Filed under: sql, adssug, Reporting Services, ssas, mdx

• For Analysis Services users, you should be aware of this fix

  If you are using SQL Server 2005 or 2008 Analysis Services, and have been keeping up to date with hotfixes cumulative updates, you may have been adversely affected by a previous round (and your users might not have even noticed). Essentially you can get...( Read More... Posted Sunday, November 15, 2009 1:08 AM from Aaron Bertrand | (Comments Off) Filed under: Analysis Services, mdx, cumulative updates, hotfixes

• SSAS: T-SQL Equivalent for a Many-to-Many relationship

  This question came a while ago now in this SSAS forum thread: What is wrong in my query and I thought it was something that may interest other people. Basically it boiled down to trying to find a T-SQL equivalent to the following MDX which is querying Read More... Posted Sunday, May 03, 2009 9:47 PM from Darren Gosbell [MVP] - Random Procrastination | (Comments Off) Filed under: sql, Analysis Services, SQL Server, mdx, Many to Many

• SSAS: There is no such thing as an Attribute in MDX!

  In MDX in SSAS the term "attribute" occasionally gets used interchangeably with "hierarchy" and "level", but it's not technically accurate. In SSAS, MDX has concepts of Dimensions, Hierarchies and Levels, but not Attributes. Attributes and Attribute Relationships Read More... Posted Sunday, March 15, 2009 10:04 PM from Darren Gosbell [MVP] - Random Procrastination | (Comments Off) Filed under: Analysis Services, mdx

• MDX equivalent of a filtered GROUP BY in SQL

  Does that title make sense? I don't know if it does, but I can't think of another description for this problem. If anyone can think of a better title I would love to hear it. It's hard to explain in words so let's jump into some code examples. Consider Read More... Posted Wednesday, January 28, 2009 5:54 AM from Darren Gosbell [MVP] - Random Procrastination | (Comments Off) Filed under: Analysis Services, mdx, Attribute Relationships

• MDX ratio of "current parent" issue

  Every now and then on the SSAS MSDN forum , the issue of doing a generic "ratio to parent" calculation comes up. Unfortunately there are a number of problems with the premise of giving users a generic "ratio to parent" measure. The first is that the concept Read More... Posted Saturday, July 26, 2008 10:18 AM from Darren Gosbell [MVP] - Random Procrastination | (Comments Off) Filed under: Analysis Services, mdx

• A Rose by any other name - MDX Formatting

  A little while ago Jamie posted about how he formats SQL code which happens to be quite similar to the way I do it. But this then lead me to think about the equivalent formatting for MDX. So if I get MDX like the following: with member measures.ptd as Read More... Posted Sunday, June 15, 2008 10:52 PM from Darren Gosbell [MVP] - Random Procrastination | (Comments Off) Filed under: Analysis Services, mdx

• Building a better DMV

  Following along on my recent theme of exploring the metadata rowsets and the new Dynamic Management Views (DMV) in SSAS 2008. I have added a new DMV function to the Analysis Services Stored Procedure project ( www.codeplex.com/ASStoredProcedures ) which Read More... Posted Wednesday, January 30, 2008 9:45 PM from Darren Gosbell [MVP] - Random Procrastination | (Comments Off) Filed under: Analysis Services, dmv, mdx, ASSP, Discover

• Another Best Practices article: Identifying and Resolving MDX Query Performance Bottlenecks

  Best Practices are good enough to follow, but simply do not read and digest. Try to implement them within your environment to keep up the performance. Similary there are many things involved within the SQL Server 2005 Analysis Services such as MDX queries, Read More... Posted Wednesday, September 05, 2007 7:34 PM from SSQA.net | (Comments Off) Filed under: SQL Server, performance, query, tsql, ssas, tuning, best practices, mdx