I have a cube with time dimension on SQL Server 2000-MSAS, I think it is using Server time, because when I edit the cube I do not see any Time dimension table. When I browse the data in the cube, I only see data of 2 years 08 and 09, but there are data in the fact table of other years like 07. 06, 05 etc. I need to show data from these years also. How to do that, there are years tables in the data source which have entries for 07,06.... Can you indicate where do I make changes to show these years.

Thanks

Roy