I have been running OLAP reports in Excel at an acceptable speed. Up
until now I have only needed up to four dimensions. My latest report has
seven dimensions of which all are non-numeric and cannot be converted to
Measures. I have had reports with 2 dimensions and 60 measures and they
have run no problem. I have tried stripping the code down in my SQL view
as well and it seems to be just the actual number of dimensions that I
add is the problem. Does anyone know what I can do to fit more than four
dimensions in a report.

Any help would be greatly appreciated.


--
Posted via http://dbforums.com

If the dimensions that you are adding to the Excel Pivot Table are in
the foreground (ie. on rows or columns), then the resulting number of
cross-join combinations can create memory/performance problems. Since
Excel doesn't permit customizing the MDX query itself, one thing to
check is any caclulated measures that are included in the report: make
sure that Non Empty Behavior Property is set, if possible.

- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

A significant are is the number of levels in a dimension, number of
items in each level as well as the number of dimensions themselves.


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!