Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

MDX rolling measure Expand / Collapse
Author
Message
Posted Wednesday, May 29, 2013 9:27 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, April 03, 2014 8:54 PM
Points: 46, Visits: 117
hi,

I am trying to achieve a rolling measure in my cube which is populating a measure based upon the below data


status_id event_date type_id
17 2011-01-10 2
33 2011-01-12 2
14 2011-01-13 2
12 2011-01-15 2
6 2011-01-22 2

Currently I am using a calculated member

Sum(NULL:[Event Date].[Date].Currentmember * [status].[Status ID] * [type].[Type ID],[Measures].[status id cnt])

Which brings data like this

10/01/2012 11/01/2012 12/01/2012 13/01/2012 14/01/2012 15/01/2012
17 1 1 1 1 1 1
33 1 1 1 1
14 1 1 1
12 1


My desired result is

10/01/2012 11/01/2012 12/01/2012 13/01/2012 14/01/2012 15/01/2012
17 1 1
33 1
14 1 1
12 1


I feel I am pretty close
Can you please help me achieve my desired result?




Post #1458022
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse