OWC Pivot Table and 30K rows - low performance

  • Thread starter Mariusz Tymowicz
  • Start date
M

Mariusz Tymowicz

Hi all!
I'm using OWC Pivot Table embeded in web page and in .NET WinForms
app, in both cases connected to AS2005 (OLAP3).
When user drops "Dimension" with eg 30000 rows PivotTable need about
30 sec to display them.
My question is if there is any way to speed it up, or use some
functionality like 'paging' or so - to display only part of result in
one time. Know there is a way to display eg first 100 items, but it's
not solution for me, user needs to be able to browse all of them.

Thank you in advice.
Mark
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with a Pivot Table (when I don't want to) 0
OWC11 PivotTable - possible work in background ? 1
#N/A values when exporting PivotTable to Excel 0
Retrieve member values for filters in OWC pivot table 0
OWC 9 best performance than OWC 11 1
OWC 11 Pivot Table and SSAS 2005 Cube 3
OWC11 Pivot Table : Data provider didn't supply any further error 1
Pivot table in Access 2007 - is it the OWC, and is licensing the same? 6

Top