Why did you not consider using the Office Web Components?

OWC Pivot tables would enable you to do the OLAP reports without building another OLAP database.

Using OWC, Fig 6 would be one pivot table with 1 chart that the users could manipulate themselves.

OWC would provide user interactivity for any report or chart

Did you want a server-side only solution? Or because OWC is "deprecated" on Office 2007?

I am writing because I use OWC extensively with both OLTP databases and DW designs.

Curious,

Leo