I need to show to the customer all the dataset records that makes the value of a datacell.
In the demo this is done in the grid event PivotGrid1FocusedCell when DetailPanel.Visible is true. But this procedure doesn't take care of Dimension filters, also it only work is original dataset is available.
if I try to build an sql statement using dimension filters too, that sql statement could be to big to execute if there are large amount of dimension items.
Is there any other way to find all the original record values that makes the value of a datacell?