We purchased Olap grid recently and later realized it has limitations with loading more than 100K records. So based on your suggestions, we decided to use Active Analysis but even this control also throws same out-of-memory exception.
- I’ve used UnBoundDatasource to load a DataTable of just 4000 records to PivotTable.
- In the initial load, I’ve loaded all Dimension fields to Rows shelf
- When I try to drag & drop a Measure field to Data shelf, it is throwing memory exception.
Can you give us some suggestions? Please see the attached snapshot for more details.
Similar issue i’ve posted in Olap grid forum: