I have the MDX below in Proclarity which is designed to show only non empty day records from the latest non-empty month backwards . In 2000 this works fine displaying all weekdays to currentdate . However in 2005 the current month values are aggregated under one figure ?
SELECT filter(descendants( tail(filter( {[Time].[Year - Quarter - Month - Date].[Month].members} ,NOT isempty([Time].[Year - Quarter - Month - Date].currentmember)) ,6) ,[Day of Month]) ,NOT isempty([time].[Year - Quarter - Month - Date].currentmember))
ON columns ,
NON EMPTY { [Measures].[Payment Due] } ON ROWS
FROM [ar]
SELECT filter(descendants( tail(filter( {[Time].[Year - Quarter - Month - Date].[Month].members} ,NOT isempty([Time].[Year - Quarter - Month - Date].currentmember)) ,6) ,[Day of Month]) ,NOT isempty([time].[Year - Quarter - Month - Date].currentmember))
ON columns ,
NON EMPTY { [Measures].[Payment Due] } ON ROWS
FROM [ar]