SQL Server Analysis Services 2005/2008 articles,blogs,scripts,FAQs,tools,books
I have a measure with aggregation as Dis
User Rating: / 0
PoorBest 
Written by GSSV   
Thursday, 21 July 2011 10:09
I have a measure with aggregation as DistinctCount and a Date dimension with a hierarchy - Year->Quarter->Month->Date For any selected Date Level, we need to get the distinct count of the last date of the level. Say viewing the results at Year, it should consider only those of the Year last date and perform a distinct count A Month, should get distinct count of the last day . Please help me out. Thanks
 
This is a comment on "Time MDX Cheat Sheets"
 

XL Cubed