You can create a data-mining project with SSAS. Use your cube as a datasource, there is an algorithm/model type called "Microsoft time series" which can do forecasting. It's way too involved for me to give instructions here, but it is fairly straight forward if you've done data mining projects in BIDS before.