I'm looking at using the Pivot grid to allow some simple data analysis, attaching to an OLAP data source using msmdpump. One of the dimensions of the cube I am working with has rather a lot of rows (~15000) which is giving me a performance problem. Typically users would only want to compare 3 or 4 of these rows - but the dimension filter doesn't seem to handle such long lists of options. Similarly, expanding the whole grid with that dimension selected isn't really an option, as no one could sensibly use 15000 rows of data, even if they could be rendered in a timely manner.
Is there some way to just request a subset of a particular dimension from the cube, so that users could preselect the information for that particular dimension, allowing the Pivot Grid itself to deal with more sensible data sizes?