wpf - High performance pivot grid for pre-aggregated data -

i have been tasked coming high performance front-end live activepivot back-end. have client-side service layer provides continuous stream (iobservable<t>) of pre-aggregated, pre-formatted data, metadata detailing dimensions , what-not in report. requirements can summarized as:

1. dynamically set row , column headers based on metadata in stream.
2. dynamically pass live data through appropriate row/column of control.
3. highlight changes data. eg. increased values may highlight temporarily in green, decreased values in red.
4. intercept user actions on row/column headers (ie. drill-downs) can instigate change in underlying mdx query.
5. intercept user actions (probably double-click) on data values can instigate drill-through query (the results of displayed in separate data grid).

all third party components appear geared around slicing , dicing disconnected (or updated) data sets. sacrifice performance achieve higher degree of flexibility don't need, , performance paramount scenario.

does know of wpf control performance-focussed , geared more towards viewing of pre-aggregated, pre-formatted data?

pivottable-like frontends allow slice , dice data exploration in general associated olap technology. of frontends target 1 specific server, using proprietary data model, , others implement standard: mdx queries on xmla transport.

but when olap technology designed 20 years ago, doing in real-time seemed unthinkable. 1 consequence xmla standard has no support updates in cell set. practically forbids because of static representation of cell sets , cell set axis.

activepivot can push real-time updates olap result set , exposes (proprietary) streaming api subscribe updates. activepivot live frontend in first place written leverage real-time updates, presenting them in familiar pivot table controls. in 2013 activepivot still olap server real-time support. explains why there isn't yet standard subscribe olap real-time updates. , means of 2013 , outside of activepivot live not find toolkit (wpf or not) has done whole job of enriching pivot table controls real-time updates. libraries know of have transposed static data representation of xmla in pivot table designs, making cumbersome or impossible update cells (think of microsoft excel pivot table instance).

under constraint of particular technology wpf, select general purpose ui toolkit, makes easy arrange , compose tables. there that's d.i.y. job.