Thursday, January 13, 2011

MDX: Cummulative Sum

Some sample query for cummulative sum in MDX


WITH 
  
SET [Set Of Months] AS
    
Descendants
    (
      [Date].[Calendar].[Calendar Year].&[2003]
     ,[Date].[Calendar].[Month]
     ,SELF
    )
  
MEMBER [Measures].[Incremental Sum] AS
    
Sum
    (
      
Head
      (
        [Set Of Months]
       ,
Rank
        (
          [Date].[Calendar].
CurrentMember
         ,[Set Of Months]
        )
      )
     ,[Measures].[Internet Sales Amount]
    ) 
SELECT 
  {
    [Measures].[Internet Sales Amount]
   ,[Measures].[Incremental Sum]
  } ON 0
 ,[Set Of Months] ON 1
FROM [Adventure Works];

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.

LinkWithin

Related Posts with Thumbnails