Hi

I have a table in SQL with a date field in it.
I use that field in MSAS to build up the time hierachy in MSAS to give me my
months/quarters/years/etc.

I use the normal MSAS windows GUI to do this.

I, however, have dates posted for 1st Jan 2005 and forward.

What I want to do is the following ...
Build the time hierachy as I, but limit the end date to the current days
date and not use the dates going forward?

Any suggestions

Graville

Probably the easiest way would be to put a view on your underlying fact
table and time dimension that only displays that data for the current
year and prior years. Either that or call out to the VBA Now() function
and filter the dimension on that.

Steve