Anybody know if Report Sharpshooter does this sort of thing...the OLAP module seems to suggest that it does something similar
Yep, all there: http://www.perpetuumsoft.com/Product.aspx?lang=en&pid=32&tid=features
Also, you can download a fully evaluation trial, there is a sample application that will let you see most of the functionalities: http://www.perpetuumsoft.com/Downloads.aspx?lang=en&pid=32
And it integrates with Report Sharp-Shooter... and you can use with your StrataFrame BOs.