Search code examples
mdxolapmondrianmsas

How to groupby and filter on the same dimension in MDX

I want to create a barchart with a bar for each month and some measure.

But i also want to filter on a range of day which might not completly overlap some of the month.

When that happen I would like the aggregate count for those month to only aggregat over the days that fall in my date range not get the aggregate for the whole month.

Is that possible with MDX and if it is how should the request look like?

Solution

  • Create a second time dimension, using a virtual dimension of the original dimension. Use one dimension in the WHERE and another in the SELECT.

    This often happens anyway if some people want 'Business Time' of quarters and periods, and others prefer months. Or if you have a financial year which runs April-April.