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 ?
You limit the data source (query or file) to return only the 3 years of data.
that WAS easy ! Thanks - again !