A common request that I have seen with my clients, is the ability to enter comments into a dashboard and then view those comments when they re-open the dashboard in the future.

Unfortunately Xcelsius does not have a native mechanism to send data back to the database, as a dashboard’s main purpose to read data and not write back to the database.  However, I do see the value in being able to persist comments so that we can go back later and be able to look at documentation on why certain things happened, etc.

In this article I will give step by step instructions on how to use web services and Xcelsius to accomplish the task of inserting comments.  However you will have to write your own web service code

Thanks to everyone who attended my presentation on BI Web Services at SAP Inside Track Vancouver 2011!

A replay of the presentation can be found at the following link => http://bit.ly/rkBU1p

I’ve also attached the powerpoint presentation that you can download here

I’ve been getting a lot of emails lately on how to setup opendocument (opendoc), so I’d like to post this tutorial on how to do so which works for Business Objects XI 3.1.

Unfortunately my previous tutorial at http://davidlai101.com/blog/2008/11/04/all-you-need-to-know-about-opendoc/ only works with Business Objects XI R2

Please note that the tutorial was taken from SAP BusinessObjects Dashboards 4.0 Cookbook so if you are interested in more useful Xcelsius recipes, be sure to purchase a copy

If you only need the Excel Template for setting up OpenDocument calls, you can download it here

If you are interested in getting detailed information on OpenDocument Parameters please download the official SAP OpenDocument documentation here

Otherwise continue reading for the Tutorial

I’ve been given the opportunity to share my experiences with BI Web Services and how to build more efficient dashboards using BI Web Services in the upcoming SAP Inside Track Vancouver 2011.  Please mark your calendars for September 27, 2011 2:30pm -> 3:20pm PST!

In this presentation you’ll learn about BI Web Services and how it provides a hybrid of QaaWS and Live Office.  As well as some new powerful features that were not available before. We’ll also discuss some limitations and work arounds to prepare you for the road ahead.

For those who are attending, there will be a set of door prizes which include copies of my book SAP BusinessObjects Dashboards 4.0 Cookbook

For those who cannot physically attend, there will be a remote access link found in the wiki link below.

For more information on the event, please visit http://wiki.sdn.sap.com/wiki/display/events/SAP+Inside+Track+Vancouver+2011

Hope to see everyone there!

I’ve had several comments on my “Xcelsius Dynamic Color Binding” post regarding issues where their dynamic colors were not changing.

Well I did a quick test and yes there is a bug! So I wanted to warn everyone including SAP about this new bug.