I have created a local cube from a SQL data warehouse table using the both the Excel only method and Analysis Services. When dragging and dropping "Row Items" dimensions the cube preforms fine until I get the 4th dimension in the row area and then the Query takes FOREVER to process, if it finishes at all. The table the cube is created off is not that large only 8500 records and my machine is pretty quick 2.53 P4, 512MB RAM. The table has one clustered index on it based off 5 columns. Now I'm just going in circles and hopefully overlooking something stupid. Anyone have an idea?