May 18, 2017 at 8:24 am
Mdx newbie here. I have the following Measures and Dimensions
Measure: Activites.Activitycount
Dimension1 : StartDate.Year-qtr-mon-date hierarchy
Dimension2: CloseDate.Year-qtr-mon-date hierarchy
I am trying to get a cumulative count on a measure across Two Time dimensions.
This is the data that I have from the cube. Activity Count is from Measure Activity
and Row lables from Dimension start date
| Row Labels | Activity count |
| 2011 | 10 |
| 2012 | 20 |
| 2013 | 30 |
| 2014 | 40 |
| 2015 | 50 |
I need a cumulative count measures that should have the following data and also a filter on 2 time dimensions
For example Opening Count for 2012 should bring all the ones that have a start date before 2012(start date of 2011) and the ones that were closed after 2012.
At month level: For example: Jan2016 month should have all the activities that were created prior to Jan2016(uptill Dec 2015) and the ones that were closed after Jan2016(Feb 2016 onwards)
| Row Labels | Activity count | Opening Count |
| 2011 | 10 | 10 |
| 2012 | 20 | 30 |
| 2013 | 30 | 60 |
| 2014 | 40 | 100 |
| 2015 | 50 | 150 |
How can I write an mdx query that counts cumilatively at all levels & has filter across 2 time dimensions
Year should sum all the previous years,
Month should sum all the previous months
Dates should sum all the previous dates.
May 18, 2017 at 11:29 am
bump for my query
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply