External reviews
External reviews are not included in the AWS star rating for the product.
Good software but starting to lag behind the industry leaders
cost of the licensing
Faster and more accurate decision making
An easy way for someone to pull data who is not very familiar with writing complicated queries.
Implementing custom Data Warehousing and ad-hoc mining solution for Telco
SAP BO - Top rated BI system in a multinational organization
Good Tool for Reporting
powerful reporting tool but with poor UI and dynamics
The universes are best part you can think of for building any reporting framework.
even if you do not have separate reporting database, universes are like building your virtual reporting DB(if you can afford reporting load on your application database).
we use if a lot for reporting on all enterprise applications and this tool helps a lot on analytics.
the other supporting tools like BODS etc. helps build a better reporting environment.
the end user data massaging is pretty slow and bulky.
end user data analytics and business decisions and taken based on this
goes well with other ETL tools etc.
if you are considering rich end user experience than features, then you need to think once again.
Old BI paradigm
Using Xcelsius dashboard instead of Qlikview
When I first started presenting Xcelsius dashboards back in 2006, I said that it should carry a warning sign stating “May Cause Xtreme Xcitement”!
Despite all the advances in technology and tools over the last decade that statement not only remains true today, but maybe should be changed to “Will Cause Xtreme Xcitement”.
In the last month, I have both seen and heard stories from companies singing the praises of Xcelsius and hailing it as the savior of BI user adoption in their organizations.
A company specializing in reporting and analysis of employee business travel was looking for a client facing BI application that would help sell their solution. The client showed me their current solution running in Qlikview bemoaning how rigid, limiting and unexciting it was to use. They then showed me an example of something they found on the web that was an animated PowerPoint dashboard much closer to what they were looking for. Of course, I recognized it as an Xcelsius dashboard embedded in PowerPoint immediately. It had been developed over seven years ago, but it still sizzled. So, we mocked up a new prototype in Xcelsius for the client and to say they loved it would be an understatement. The VP of Marketing came up with the best quote of the day when he said, “It’s alive!”
A multi-national vehicle leasing company developed a super cool Xcelsius dashboard for improving their vendor management with built-in location intelligence using the GMaps plug-in and the InfoBurst XML Data Caching for high data volume performance. They presented it at their annual sales meeting last month and it stole the show. The excitement generated was so contagious, the VP and Director responsible spent the evening at the bar designing the next dashboard together! (I can’t wait to see that one!).
A new finance director of a global software company needed a way to provide better visibility to their financial statements and reports. She remembered using Xcelsius many years ago and said it really helped then. We put a prototype together for her in a day and everyone loved it, so they are buying it next week.
So why is Xcelsius so amazing and still slaying the BI data visualization competition everywhere? There are dozens of reasons from its ease of use, animations, ability to embed in everything, fast prototyping to its “what if” scenarios and cool components. But it goes deeper than all these features which you can also find in other BI visualization tools. The real secret to the success of Xcelsius is that it was initially designed and developed by computer gamers. To develop a winning computer game, you need to engage your audience visually, make it cool and fun to use and have limitless possibilities. You can find all these elements in Xcelsius dashboards allowing you to create killer BI applications.
That is why Xcelsius dashboards is still the best show in town. Xcelsius lives!
Update Nov 2015 : Lots of activity around Xcelsius HTML5 for deployment on mobile and on desktop with dCode add-on (www.getdcode.com). Now that Xcelsius generates HTML5 output, I see it being around for many, many more years
Update April 2016 : Xcelsius continues to thrive with many organizations using and deploying it for the first time in 2016. SAP provided updates to it with latest BI 4.2 release including full support for Excel 2013
Update Sept. 2016 : Xcelsius HTML5 definitely seems to be the dashboard solution of choice and many new add-on HTML5 components are becoming available including D3 charts, flat components and query drag and drop discover.
Update Sept 2018 : Adobe announced end of life for Flash for Dec 31, 2020 and SAP announced it would no longer support Xcelsius after this date since the development client uses Flash. While some Xcelsius users are looking for a viable alternative solution, others vow to continue to use the tool regardless. There are some new Xcelsius compatible solutions in development so let's see what materializes in the coming months.
Update Feb 2019 : Xcelsius still heavily in use. Some companies looking to replace with Tableau or PowerBI but just not the same. Web Intelligence dashboards may be a viable alternative for simple dashboards .
Update July 2019 : SAP has announced it will no longer support Xcelsius after Dec. 31, 2020 to coincide with Adobe no longer supporting Flash in the browser. However, most Xcelsius users have been generating HTML5 dashboards for a number of years now and are continuing to do so and their Xcelsius HTML5 dashboards should not be affected. SAP has no equivalent follow-on product and is recommending customers move to SAC (cloud only) and rewrite their dashboards - this will require programming skills . An alternative to Xcelsius, called Squirrel, that requires no training for an existing Xcelsius developer and has a built-in XLF migration utility is due for beta release by InfoSol in October and will be GA in December.
Update Dec 2019 : Squirrel has been in beta for the last few weeks with multiple organizations and is scheduled for general release on Dec 31. Initial feedback is very positive with Xcelsius users who require no re-training to use it. They have been able to both migrate or recreate existing Xcelsius dashboards. This is great news for the Xcelsius community who now have another option when Flash goes away and SAP stops supporting Xcelsius in 2021.
Update May 2020 : Squirrel is now at version 1.3 with multiple Xcelsius customers having converted their dashboards and running with the Squirrel HTML5 versions in production. This appears to be a very viable path forward for those customers left with Xcelsius Flash dashboards that will probably no longer work starting in 2021.
Update Nov 2020 : Squirrel 1.6 which has a cloud based version and allows you to embed dashboards in PPT was just released last week. More and more Xcelsius customers have now successfully moved to Squirrel and companies like Salesforce are using it too. Xcelsius has about a month to go before Adobe and SAP stop all support.
Update June 2022 : Squirrel365 has now replaced hundreds of Xcelsius dashboards and has become the de facto follow-on solution for Xcelsius
Update May 2024 : Squirrel 365 can now be embedded in BusinessObjects Web Intelligence, Tableau and PowerBI bringing "What If" scenarios and write back capability to these traditional BI solutions
Disclaimer: My company is partners with several vendors including SAP BO.
Once you are stable on a BusinessObjects release, it is worth staying there for a while
It is true that there are often challenges when upgrading between releases of BusinessObjects but this has always been the case as it has been for all the other BI and software application vendors too.
A few rules of thumb for BusinessObjects software are:
1. Never upgrade to an x.0 release - always wait for at least the x.1 release and even the first or second service pack of that release
2. Never attempt to perform a release upgrade if you have not done one before. Get training and experience first or use a reputable BO Consulting company
3. Experiment with the new release on a sandbox environment to become familiar with the changes and find any major issues before attempting a migration to production
Once you are stable on a BusinessObjects release, it is worth staying there for a while.
Update April 2014 : BusinessObjects BI 4.1 has been out for 8 months now and is looking like a stable release. Expect to see a lot of activity moving to this release over the next year.
Update September 2014 : BI 4.1 is now at Service Pack 4 (SP4) which corrected multiple issues in earlier service packs (SP2 and SP3). As more customers move to BI 4.1. more experience is gained and the platform improves. Main features attracting customers to BI 4.1 are improvements in Web Intelligence, Mobile Dashboard support and support of Desktop Intelligence.
Update February 2015 : BI 4.1 is now at Service Pack 6 (SP6). Both SP5 and 6 have been stable. Most BI 4.0 customers are also migrating to BI 4.1 and many more XI 3.1 customers are also migrating since XI 3.1 goes into a maintenance only support mode ( no more service packs or fix packs) after Dec. 31, 2015. The next major release BI 4.2 is currently scheduled for end of the year.
Update December 2015 : BI 4.1 SP7 has just been released. BI 4.2 is in Customer User Validation phase and will not be released until 2016. The jury is still out regarding if the quality of software updates has improved but new QA processes have been implemented by the SAP BusinessObjects development and support teams this year.
Update May 2016 : BI 4.2 SP2 was released at the end of March. There are quite a few new features including to the Upgrade Management Tool (UMT) which is used for migrating content from previous releases. It is now possible to handle incremental updates and moving certain types of content instead of all. There is also a new mechanism that allows part of the update to be performed while the system is still running. There is also a new Recycle bin feature for public folders in case you accidently delete a report. Organizations still running BusinessObjects XI 3.1 are now looking to go straight to BI 4.2.
Update October 2016 : BI 4.2 SP03 is now the latest version released at end of August. It has a lot of new features for a service pack including additional new functionality for Web Intelligence like cascading prompts for input controls, references and further enhancements to the new discussions. The Administrators cockpit has also been further enhanced to provide more options. So far, stability looks good.
Update April 2017 : SP03 has proven to be a relatively stable service pack that many BO customers have updated to. The next service pack, SP04 is now in beta and scheduled to be released in May. Again, it promises to have a bunch of new functionality for Web Intelligence including full parity between the Java and dhtml clients, an optional new UI and many new graphics
Update September 2017 : SP04 has now been available since May and there were additional quite a few code changes . The first release release had multiple issues. Some were addressed in the two subsequent Fix Packs that have been released. The general feeling was that it was not as stable as SP03. However SP04 was the first version that included SQL Server 2016 support so many customers wanted to install it.
Update February 2018 : SP05 was released in December and there were further enhancements particularly to the new optional HTML5 Fiori portal that can now be used for consuming BO reports. This first version has some issues around installation/upgrade but too early to judge its overall stability yet.
Update July 2018 : Like all the previous BI 4.2 Service Packs, SP05 had multiple issues when first released and really did not completely stabilize until Fix Pack 200 (after Fix Pack 100). It is now at Fix Pack 400 and SP06 is in beta testing and should be released soon.
Update December 2018 : SP06 is now the current BI 4.2 Service Pack update released late July. Like all the other service packs there were some initial issues and after a couple of fix pack updates, it now is quite stable. Like its predecessors it has a lot of additional functionality especially with the new Fiori HTML5 UI and Web Intelligence (more new charts like funnels, pyramids, intra-document links and more). Nice enhancements to BO Administrators Cockpit for usage/performance monitoring. Now BI 4.3 has been announced for release at end of 2019, the next service packs may be more maintenance fixes than new functionality.
Update June 2019 : SP07 was released a couple of months ago. Unlike previous BI 4.2 Service Packs this had a very small amount of new functionality and was mainly a maintenance update. Again the first version had a few issues but a fix pack has been released and customers are upgrading to it. The remaining 4.2 service packs are also supposed to be primarily maintenance updates and fixes as new functionality will be focused in the eagerly awaited BI 4.3 release now likely to be released in early 2020.
Update December 2019 : BI 4.2 SP07 remains the current release. There have been issues with some of the Fix Packs and it is best to go with the most current. The BI 4.3 open beta is due to start this month but GA is not expected until mid 2020 now. There should also be an SP08 update to BI 4.2 coming in early 2020.
Update April 2020 : BI 4.2 SP08 was released a few weeks back and despite it being primarily a maintenance release, SAP has included some interesting new features like a direct connector to Snowflake for Webi. Some early bugs in SP08 have been reported and the first fix patch 100 has just been released. There is still much anticipation for BI 4.3, the next major release due out this Summer.
Update September 2020 : BI 4.3 SP0 was released in June and has a radically different HTML6 UI that will take some getting use to. There are a lot of other new features including Webi as a data source allowing you to use universes on top of a Webi report. a few brave souls may try out an SP0 release but most will wait till at least SP2 due out mid 2021. BI 4.2 will continue as the dominant release for at least the next couple of years with SP9 coming out later this year.
Update September 2022 : BI 4.3 SP02 is now the current release with SP03 due for release in December. BusinessObjects BI 4.2 will go into Priority 1 support mode for 2 years starting Jan 1, 2023. In addition, SAP has announced the next major release after BI 4.3 which has been code-named BI 2024 and is die for release at end of 2024/beginning of 2025. This release like all previous BI 4 releases will run both on-premise and in the cloud. This effectively means the BusinessObjects roadmap is solid for at least the next 10 years which is a testimony to both the popularity and success of the product.
Update March 2024 : BI 4.3 SP04 is now the current release but since it has only been out a couple of months, not too many people are moving it to it yet. SP03 is now at patch level 900 and there have been some issues over the last year. Again, a lot of new functionality (and therefore new code) was delivered with both SP03 and SP04. The most significant was the new Data Tab mode in Web Intelligence which allows merging and transformation of data sources. You can join sources toigether with Left Join, Inner Join, Outer Join and Append. You can also profile your data and see disticts and nulls and apply simple transforms using a Replace option.