hehehe… I think that anything is possible when using standard BI Enterprise reporting tools and it is down to your own knowledge and use of PL SQL, etc. that will get you the results you want.
I’ve been playing with Hyperion (Brio) for quite a few years and whilst it does sometimes frustrate me in not being able to do some very simple things (trying to produce Totals and Averages and Mean Averages across data sources, etc.) it is “ok” if you want basic reporting. The GUI is intuitive but the “GIS” sections lack a lot of functionality.
With Business Objects you can at least add Universes (BOU’s) so, if you wanted to pull in external data or data from various sources, it makes it easier for you - and the outputs are a little easier to handle, too.