You are, indeed, correct - with the current implementation of RadPivotGrid
the query passed to the cube extracts the whole data that matches the set OlapDataProvider settings.
The expand/collapse state of the RadPivotGrid is responsible only for the UI representation of the data and is not included in the filtering of the data.
Currently the DataProvider can be configured through the UI only by using a RadPivotFieldList
(and it cannot be configured using a RadPivotGrid). We have a feature request logged about this:
After implementing the above feature - an expand/collapse filtering of the mdx query could be included as an additional filtering functionality.
I suggest logging it as a feature request in our Feedback Portal where you can track its progress and vote for it:
Do you need help with upgrading your AJAX, WPF or WinForms project? Check the Telerik API Analyzer
and share your thoughts.