Xcelsius and Business Intelligence Web Services (BIWS)- Part 2

As a follow up to my blog on BIWS, I created two videos to show you the concepts of creating and consuming BI Web Services. The demonstrations were done using BI 4.0.

In this first video, I create a web service and demonstrate how to validate it from an already developed Web Intelligence report.

In this second video, I create a simple dashboard using SAP BusinessObjects Dashboards 4.0 that connects, consumes, and filters the data via the web service connection.

The demos were built using the efashion universe, so if you have that around, you can follow along.

Scott Strool is a Senior BI Consultant for Benchmarkers Business Intelligence, where he helps customers obtain their BI visions. He presented at the 2010 SAP BusinessObjects User Conference in Orlando, FL, and has led many dashboard initiatives. You may follow him on twitter at @scott_strool.

Tags: , , , , , , , , , ,

12 Responses to “Xcelsius and Business Intelligence Web Services (BIWS)- Part 2”

  1. Yuv says:

    where is the video? it is blank for me in IE, Firefox and Safari.

  2. Mico Yuk says:

    You might be behind a firewall.


  3. Scott Strool says:

    You can also go to the XcelsiusGurus channel on YouTube to see the videos.

  4. Chandran says:

    Simple, clear and Good…. Thanks Scott for the video.

  5. Bhargava says:

    Hi Scott,

    Thanks a lot for a nice demo.
    Can i know the advantage of using this over Liveoffice and Qaaws.

    thanks in advance,

    Bhargava Bommidi.

  6. Scott Strool says:

    Hi Bhargava,

    The biggest advantage over Qaaws is being able to read from a cached instance of the webi report.
    The biggest advantage over Liveoffice is not need to setup liveoffice objects and the whole bit of maintenance.

  7. Abhi says:

    Hi Scott,

    Very comprehensive video. Great job!

    I have been observing a trend that when you go over more than 3 or 4 connections using BIWS, the data retrieval process tends to get very slow and we start seeing similar response time as Qaaws. As a result you tend to lose the advantage of having data cached in the WebI report. Have you come across this situation? I’m using XI 3 SP 3 and Xcelsius 2008 SP4.

    Furthermore, if the number of columns changes in a cross tab report, BIWS doesn’t know how to handle that? For instance, if there are just 3 columns of data for a particular value of filter while we have mapped 5 columns of data in Xcelsius, it inserts the data from row #2 in column 4 and column 5 of row 1. Any luck with this issue?


  8. Keith says:

    Hi Scott,

    We just moved from using LiveOffice connections to read from the saved data within the report. A batch job runs at night to open the report, refresh, and save the new data.

    Our new BIWS connections, on the other hand, looks at the latest instance of the report. So, my question is… are we able to run BIWS off of the saved data and leverage the existing batch system or do we need to use the scheduling tool?


  9. Ron says:

    Hi Scott,

    Thanks very much for the videos, had a quick question.

    Is there anyway we could schedule the report and use that report to pull the latest data using the BIWS method? This would help us to avoid the database query refresh time (huge query) and also to avoid the authentication in Live Office method.

    Thanks in Advance,


  10. David Lai says:

    Hi Ron,
    Yes there is.

    Just put “1″ on the “getFromLatestDocumentInstance” parameter.


  11. Subhasis says:

    Hi Scott,

    How will the end user access the latest universe with modified data, i.e if the customer wants to view the dashboard on the current universe data rather than the old data.


  12. Poornima says:

    I would like to know what other operators can be used to filter the data other than equal. I have a requirement to do an in list /All operations. In List, In , INLIST – none of these seem to be working.


Leave a Reply