We use the InfoView web based interface to host the enterprise reports. The Crystal Reports is a good standard reporting product from any single data source. WEBI allows us to use multiple data sources to produce one WEBI document that can have many reports. If the Universes are designed with cross data source linking in mind, the Webi documents can be used as a great tool to relate data from multiple data sources and environments.
Improvements to My Organization
Our reports are no longer just a static product. Our users can actually interact with the reports. Because of this, we can generate a single enterprise wide report and the users can simply navigate to see only what is pertinent to them. Prior to this, the developers maintained a lot of “one off” reports. Basically the same report for different departments.
Room for Improvement
Business objects service packs are as notoriously bad as Microsoft new products. Full of bugs, they fix one thing but break others.
Use of Solution
SAP Business Objects Universes and WEBI - we have been using it for 3 years. It was a progression from Crystal Reports which I have been using for 14 years.
Once you get your security strategy built correctly, things go fairly smooth.
Once installed we have had to go back to Business Objects to get patches. Part of this is our own fault for going to Unix and Tomcat servers (to save licensing costs). On a Windows Environment this seems to work better. SQL Server ODBCs on the Tomcat servers are troublesome. Once it gets set, things go pretty well.
The scalability seems good. We have a large data repository. With over 23,000 users and 3,000 report. The reports are about 50/50 between WEBI and Crystal Reports
Customer Service and Technical Support
Customer Service: Customer Service from SAP is good. Not stellar and not horrendously bad. I give them 6.5 out of 10.Technical Support: Depending on who you get. Some of their Technical support people are super great, others seem pretty novice about their product.
We have been a Crystal report shop for a long time as it is a product supported by or primary data vendor. We have also tried to go to SQL Server Reporting Service but found it too limited. We have one product now using Cognos Elite. I find it very comparable but more clunky to use.
Complex if you are not using Windows Servers. There are a huge number of options that allow you to make detrimental choices that you may not be aware of. Not much different than any other enterprise wide reporting system.
Pricing, Setup Cost and Licensing
Other Solutions Considered
We did evaluate other options, but the fact that we were already invested in the Crystal Reports and our major vendor was supporting the Business Objects platform, we really saw the most benefit going with them.
Use Windows Servers if you can afford the licensing. If not be prepared to battle ODBCs, fonts, memory issues, and more. In the end, Cognos, Informatica, Business Objects, SQL Reporting Services require someone to know and understand the database structure. Good database structure results in good performance if the developers know what they are doing. If your databases are poor, you just amplify the problems with these kind of tools. These all simply provide an interface where someone has to define the table and data relationships. Finding the right person to do that is the key. Give them the tool that best suits the needs of the company.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Feb 19 2014