Hi everyone!

I have a Process Date dimension which stores the date every time I
populate my tables, then its hierarchy is [Process
Date].[Year].[Quarter].[Month].[Day]. I need to display only the
data/count for the latest process date available for every level and
not the sum/total. How can I do that? Is that possible?

I hope you can help me.

Thanks in advance!

which AS version do you use?
AS2005 has a new aggregation which is the last value.

else, search for inventory analysis and semi additive measures to see how to
do this.

"kaye" <mkcadorado (AT) gmail (DOT) com> wrote

And if you are using AS2k you could look into using custom rollups.

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <#ZGSKXqiGHA.2188 (AT) TK2MSFTNGP04 (DOT) phx.gbl>, willgart (AT) hotmail (DOT) com
says...