anyone still using analysis services 2000? each year i add a new partition to our cubes for the new year. we partition our data by year into separate sql tables and build AS partitions on these tables. i have tables & partitions for 1999 - 2012. all have approx 250,000 rows each and process in about 1-2 minutes. the new 2012 table has only 3300 at the moment, and it takes over 1 hour to process! i have checked the base tables for indexes (same as previous years) and the partition setup in AS but everything seems identical.
EDIT: i have the same problem on both our test and production servers.
any ideas on where to start?
p.s. before you tell me to migrate to a newer version - it's a legacy system that has been planned to be phased out but the phase out date keeps slipping. hopefully, it's only got 1-2 years left.