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 of ''parent'', by definition, requires a hierarchy and SSAS 2005 supports multiple ...

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 'sum(periodstodate([Date].[Calendar].[Month], [Date].[Calendar].currentmember),[Measures].[Sales ...

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 is included in the v1.2 release that I put out just before Christmas. This all started off when ...