What is most valuable?
Flexibility and 'integratability'.
How has it helped my organization?
Can integrate the reference services of a metadata repository. Saves a ton of maintenance and ensures Data Quality.
What needs improvement?
Performance, but they all have room for this. Nevertheless, performance is highly dependent on data architecture and design as well as server capability. Far less so on the reporting tool that can fetch results; set once and re-use over several 'reports'.
For how long have I used the solution?
I have been using the solution since 1998.
What was my experience with deployment of the solution?
Confessions ... this is hardware and networking and unix. All of the server based reporting products are complex to install and beyond my skills. Adapting these products to the foundational environments is always adventure-prone but most vendors provide substantial help in installing.
What do I think about the stability of the solution?
With most of these products, BO, too, instability arises often when resources are challenged. So, in general, planning for capacity processing is a good way to keep systems stable.
What do I think about the scalability of the solution?
BO has had 1000's of individuals in organizations running BO when they want to. Most toolsets address scalability.
Which solution did I use previously and why did I switch?
I am a consultant; even if I advise changing BI reporting toolsets, I do so reluctantly. It is more involved than at first glance, particularly if you have a user base. To date, I have not encountered a situation where I would advise changing BI toolsets that have some traction in the organization. At least not without a plan.
What about the implementation team?
Strongly recommend a vendor team for the initial period. Make sure they interface heavily with network, DB and DW folks.
What was our ROI?
ROI for the reporting product alone, as a component in a whole stack of things contributing to ROI, is in my view a minor contributor. How reports are developed and cast, the underlying data structures, data quality efforts, etc... these are the major contributors to ROI, not to mention the comprehension of the report viewer.
What's my experience with pricing, setup cost, and licensing?
This can vary from site to site. Depends greatly on folks at the company and on the licensing deal worked out.
What other advice do I have?
Category leaders have their strengths and weaknesses but as seen from the lens of the person using the tool. Some may want ease of use ... others a full-blown suite of DML tools. From this perspective, BO is as good as any of the other leading tools for reports.
If anything, BO is great at controlling the user's interface eg highly user friendly capable. It does not come out of the box that way, but a competent BO wizard can make that happen on balance easier than other products. Finally, BO supports conserving server resources better than most.
BI solutions are not about the tool. Any solution concerning the presentation of information has to focus on the business requirements and then a corresponding data foundation. Getting these is often a challenge at several levels and so I understand that there is this hope that maybe the toolset can make up for a lack of clear specifications.
Bottom Line: Get the data foundation in shape first prior to implementing a reporting tool.