This is very important for us. Ours users build big queries and when they need to make several changes on it,
on each change of layout or filter aplied over any dimension we have repeated updates on the data grid. That takes time. Our sugestion is to create a "postpone update" option, where users can mark this option and then do all the layout changes and filters without updating the grid. After finishing that, users can then click a button to update the "grid". See Microsoft´s Excel Pivot Table example.