It is such a pleasure to be the first SAP Mentor to kick off this new "Dear aBI" gives advice on Business Intelligence on the SCN Network. As a BusinessObjects reporting community evangelist, I was first humbled, but then excited about being asked to do this. I'm always amazed at how many questions we get from the community. The goal of this new column is to address the most common ‘important' ones. While the answers are subjective, the opinions represented here are not only from experience, but also from a number of reliable sources both within and outside of SAP BusinessObjects. Kudos to Jason Cao and everyone involved in getting this kicked off! It goes to show, once again the commitment that SAP BusinessObjects has to getting the correct information to their users. I encourage everyone to submit their questions, small or big and we will do our best to address them. Enjoy!
Dear BI Expert,
I'm trying to connect my Xcelsius dashboard to SAP BusinessObjects, which connection should I use QaaWS or Live Office?
From,
Chris in Miami
Dear Chris in Miami,
This has been an ongoing debate and while opinions may vary, based on experience we would recommend Query as a Web Service (aka QaaWS) over Live Office in terms of overall stability and limited scalability. If you need to use Crystal Reports or Web Intelligence documents as your data source then using Live Office is the best option. However, if you have the ability to get the data directly from the Universe we highly recommend using QaaWS. From a performance perspective when a query is called in QaaWS it hits the database directly, while Live Office puts the load on the BusinessObjects Enterprise reporting engine. In addition when using QaaWS the logic and calculations required for the dashboard is pushed to the DB either via SQL or DM/DW & ETL, while in Live Office this ‘heavy lifting' is done in the reporting documents. We have also seen more incidences of unstable behavior using the Live Office connectivity during the actual development process, but did not encounter the same issues with QaaWS. However, keep in mind that with both connections the key to good performance and scalability is keeping your data set to a minimum. To gain more details on this topic click here to see a webinar that I presented with Ryan Goodman of Centigon Solutions that compares each connection and explain when to use them.
If using WebI, one third party option worth mentioning is the Antivia XWIS.
Dear BI Expert,
Can you explain how the Xcelsius licensing works?
From,
Phil in Los Angeles
Dear Phil in Los Angeles,
With the release of Xcelsius Service Pack 3, SAP BusinessObjects made a few changes to the licensing structure of Xcelsius products:
Dear BI Expert,
I want to learn Xcelsius, where can I find more information on training?
From,
Paul in Boston
Dear Paul in Boston,
Depending on your budget there is a number of places to gain Xcelsius training. Below are my suggested resources in order of preference and developer level:
a. FREE Training
b. PAID TRAINING
Dear BI Expert,
How can I obtain Xcelsius on my iPhone or iPad?
From,
Michael in Chicago
Dear Michael in Chicago,
Due to the lack of support for Adobe flash on the iPhone, Xcelsius is not available for either the iPhone or the iPad (FleXcelsius Guru, Evan Delodder wrote a great article on this topic). However, a good alternative that many users enjoy, is using the iPhone app, RoamBI that allows for the visual display of charts on both the Iphone and Ipad. It also connects to BusinessObjects Webi Reports as well Excel spreadsheets and other data sources. To find out more, visit their website at http://RoamBI.com/.
To learn how to submit question(s) to one of our BI Experts, please visit the BI Advice Wiki.