Hey folks,
Well, I've finally got some real data into my pivot grid... And it's slow.
My data (and this is a very small sample) is 30K rows, without about 15 properties/dimensions each.
The trouble happens when I drag over a properties that has about 1000 unique values. Specifically, when I drag it into the vertical dimension (and it has about 1000 unique values), and I have a date property across the top (that has about 50 unique values). Then every time I drill down into the date hierarchy, it takes about 60 seconds to refresh the grid.
Excel pivot tables will work with the same data without any delays at all, so I am wondering if I'm doing anything wrong (code attached).
As a separate (but possibly related) issue, right now I don't have any scrollbars showing up around the component when the number of unique values doesn't fit on the screen... Is this part of the problem? In any case, I'd like to know how to get scroll bars to show up.
Thanks,-Jesse
Hi
The basecube.xml is missing in zip file you have attached.
Todor
Sorry -- it was too big. This is a truncated version, so it won't really demonstrate the performance issue as well, but it should allow you to get the code working, and you can copy and paste additional <row> elements according to the pattern you see to reproduce the performance issue.
Then simply drag in itemNumber over as a vertical dimension, and date as a horizontal, and start expanding and collapsing dates... You should see the issue.
Thanks!