When saveing / loading large views in XamPivotGrid, loading takes very, very long since it has to expand every member one by one. Even disconnecting the datasource from the control (setting grid's datasource to null) doesn't speed up the process. We have pretty large dimensions with 100+ members, so the average loading time is about 3 minutes per view!
And one more question: is it possible to disable the filter behavior where expanding a member in the filter also expands it in the grid? If you use a filter on a 2nd level hierarchy your expanded states get lost (all will be expanded / collapsed).
BR
Daniel
Hello Daniel,
Thank you for your post!
I have been looking into it and have created a small sample application in order to test the functionality you have described. Using the sample application I was not able to reproduce the issue.
I am attaching the sample application for your reference. Would you please modify it with the functionality you are using, so it reproduces the issue? This way I would be able to further investigate this matter for you.
Looking forward to hearing from you.
As I told you, there need to be many (100+) expandable members in the grid (see attached views). Sure they contain a large dataset, but loading it takes way too long in comparisson to building it manually. The problem seems to be that every member has to be expanded one by one, while an amount of members can be expanded at once manually.
We were able to reproduce the behaviour by utilizing multiple dimensions on one axis and expanding every available member (see attachment). Since our customers are using dimensions with more than 100 expandable items, having that many items on one axis is a common occurence.