 <p>I am assuming you have a <code>length</code> measure. If so, the below should work.</p> <pre><code>WITH MEMBER Measures.SumOfLengths AS SUM ( [DimDate].[Alldate].[Day].members, [Measures].[Length] ) SELECT Measures.SumOfLengths ON 0, [DimDate].[Alldate].[Day].members ON 1 FROM [YourCube] </code></pre>