Tuesday, June 12, 2012

MDX Date Range Query

Date Range

WITH SET [MyRange] AS 
'{[Time].[2009].&[5].[22].[26] : [Time].[2009].&[6].[26].[24]}' 
MEMBER [Time].[Range] AS 'Aggregate([MyRange],[Measures].CurrentMember)' 

select {[Measures].[Sends],[Measures].[Views], [Measures].[Clicks]} on columns, 
{[Zone Id].&[142]} 
on rows
from [All Communication Analysis] where ([Time].[Range]) 

No comments:

Post a Comment

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