OLAP Cubes & Pivot Tables & Dimensions

[gambler21]

I've created an OLAP Cube utilizing an access db query. I am able to create the Pivot Table and add the dimensions that include Lead Location, Lead Source, Lead Type, Lead Rep, Lead Dates, Lead Name, Lead Address, and Lead Number, and I am able to create and move the dimensions to appropriate rows and columns, however when I try to include more than 4 dimension rows into the spreadsheet, the spreadsheet goes into terminal think mode and I eventually have to cancel that row. Anyone have any suggestions for adding more rows to a Pivot Table successfully?

 

[Flybridge]

That is also my experience, limited though it is. Some OLAP products physically stop you attempting to use more than 4 dimensions at once, so perhaps it is a limitation of OLAP?


'The world isn't round - it's bent!' Spike Milligan