Hi all,

I have 2 dimensions, one called "Product", the other one is "Advertiser".
They each contain resp. 13.000+ and 3.000+ elements.

I'm using the pivottable in Excel. When i put one of the dimensions in the
grid, it takes 2 or 3 seconds, which is good. But when i place the
Advertisers, and next to that the products in the grid, it takes mor than 3
minutes to load.

I'm using a MOLAP storage, at 25% (+/- 230 aggregations), and i've also trie
usage-based optimisation, but none of that made any great difference.

Is there a way to enhance this, or do i have to reduce my dimension sizes ?

Thanks in advance!

there is many point to verify.

how many cells are retrieved in Excel?
does your AS server works (CPU usage) during this time?
do you display a measure or calculated measure?
Do you really need to display a so huge amount of data?
Do you use the pivottable or the Microsoft Excel add-in (separate download
on the MS site)?
its AS2000 or 2005?

"Koen" <Koen (AT) discussions (DOT) microsoft.com> wrote

Hi,

Thanks for your reply. To answer your questions :
- In excel, i only have 1 columns, and 175 000 records
- The AS server works a, but it's CPU isn't very high, and it doens't last
to long (in contrast : the cpu of the client is working very hard)
- i display a measure
- yes, i really do need to display so much, it depends on the combination
Advertiser-Product
- i use the standard excel pivottable. i also have the tool installed, but i
only use that one for layoing the base of an mdx)
- It is AS2000

A detail: when i query the facttable, i get the same resultset in only
seconds!

Kind regards, Koen

"Jéjé" wrote:

the pivottable in excel is not efficient.
if you use the pivottable outside excel (using the OWC (office web
component)) the performance will be better.
there is nothing to do.
maybe you have to change autofit options or formatting options..

using the new Excel add-in the performance will be better. but 175K is big,
its greater then the supported number of rows!!!

"Koen" <Koen (AT) discussions (DOT) microsoft.com> wrote