This MDX query returns 3 columns from the Time dimension using ADOMD but only 2 in SSAS
Select Non Empty {[Meter].[Meter].[Meter]} *{[Measures].[Consumption], [Measures].[Peak demand]} on columns, { [Time].[Time].[Month].&[2018]&[12] * [Time].[Day of month].Children} on rows FROM [EnergyReports]