MDX Hierarchy query

Question

I work with Pentaho BI and I am preparing data for simple dashboard. I have records with two level date dimension (year and month). When I do query from saiku:

WITH SET [~ROWS] AS
Hierarchize({{[Date].[Year].Members}, {[Date].[Month].Members}})
SELECT
NON EMPTY {[Measures].[Count]} ON COLUMNS, 
NON EMPTY [~ROWS] ON ROWS
FROM [data]

Pentaho create a sum for every first month, every second month... (1-12) and sum for each year. I need a sum for every year+month pair. How do I have to edit query?

Actual chart:

Target chart:

Answer 1

I assume you use Pentaho CDE to create a dashboard.

Set up Banded Mode property of MDX query to Classic (instead of Compact).