Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Analysis 2005 Time heirarchy using tail.filter etc

Status
Not open for further replies.

shandads

Programmer
Oct 20, 2004
6
0
0
GB
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]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top