Been using BO since 2010 - mixed response of success
High level points from our experience:
Ad-hoc reporting capabilities are hit and miss:
For lite needs such as simple quires, summary level, what happened last month- it's pretty good.
For transactional level data we see universes that spin up for 3-10 minutes and then time out.
Robustness of the universe doesn't allow us to do the types of detailed analysis that we would like to be able to perform.
Static reporting works really well. We have reports that are scheduled and reports that are distributed via email. We also have a self service que- works well, well tested, great for our customers
Dashboarding- we have leveraged the Excelisus product- we have 25 dashboards- includes simple graphs, more detailed analysis with limited drill through (can do drill throigh back in the BO report). What's really missing is the ability to do any clickthrough in the dashboard itself. It's parameter driven and a little clunky (unlike products such as Tableau). It doesn't give users (at least the way we implemented it) the flexibilty to interact with all the graphs around the dashboard
Overall: It's great if you have a static customer base that has standard expectations who knows what they want and need to perform, but if they're trying to do self guided analysis, it's not a robust enough environment
We're upgrading to 4.x and also moving from a unix platform to a linux one. We're looking to see some savings and performance improvement. We're also looking to take advantage of the new dashboarding capabilities in 4.