Using Mondrian’s CurrentDateMember to show current day’s data in MDX

Let’s say we have the following MDX query to show data for a particular date (in this case the quantity measure of the cube Electricity): WITH SET [~ROWS] AS {[Time].[Day].[2014-01-01]} SELECT NON EMPTY {[Measures].[Quantity]} ON COLUMNS, NON EMPTY [~ROWS] ON ROWS FROM [Electricity] Works OK: But what if we want the date to be dynamic,… Continue reading Using Mondrian’s CurrentDateMember to show current day’s data in MDX