I have a cube with 12 dimensions and 2 fact tables. I've processed all the dimensions successfully, but when the fact tables start processing it gets stuck. There is only large table that feeds this cube. All the dimensions and fact tables are queries in the data source view based on the same table. The total number of rows is 15,000,000. The process gets through all the records on the first fact table and then starts to build in the indexes. It makes it through 88 or 89 indexes and then just stops. It doesn't freeze, just doesn't do anything else for hours. It says "Finished building aggregations and indexes for the 'Fact Account' partition." but still only says 88 of 89 and never goes on to the next fact table. Any thoughts would be appreciated.
This is running on a windows 2008 r2 box with sql server 2008 r2. It is the only thing on the box processing. Both the source database and the ssas are on the same server.