Cube Refresh based on Time Dimesion

[damzI]

So I have created a Time Dimension in my cube based on a query that provides the current date in the MMYYYY format. This date will change every month and refresh the cube. However I am also looking to have only 3 years of rolling months in my cube. How can I set up the time dimension to filter on the 3 years of rolling dates ?

[bobznkazoo]

You limit the data source (query or file) to return only the 3 years of data.

[damzI]

that WAS easy ! Thanks - again !