BI Web Services presentation from SAP Inside Track 2011 now available for download!

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 => I’ve also attached the powerpoint presentation that you can download here  
October 3rd, 2011 by David Lai 

SAP Crystal Dashboard and Presentation Design (Xcelsius) Cookbook Coming Soon!

I hope that everyone has had a great start to 2011! 2010 was a huge year but 2011 looks to be even bigger! I’m very pleased to announce that the Xcelsius Cookbook, which Xavier Hacking and I have been working very hard on, is scheduled to be released in it’s final format on May 2011. The book will be structured like a cookbook where we will go through step by step on accomplishing different...

February 7th, 2011 by David Lai 

Using Filtered Rows instead of VLOOKUP

This article talks about using the filtered rows technique instead of a VLOOKUP. Not until Xcelsius 2008 came out, were we able to filter on multiple rows of data that matched 1 entry. So in order to accomplish this we would either have to use VLOOKUP or INDEX MATCH. Using this technique was very cumbersome and although filtered rows has been available for a while, I have been on a couple engagements...

July 2nd, 2010 by David Lai 

Xcelsius Canvas Container

In this article I’ve attached a video that talks about the new Canvas Container feature in Xcelsius 2008 SP3. I found that the Canvas container is very easy to use and provides the same functionality as the group method but allows the flexibility of moving objects in and out of the canvas very easily. I totally recommend that Xcelsius developers use the Canvas container method to group objects...

March 26th, 2010 by David Lai 

Xcelsius 2008 Refresh on Load

One of the major issues I’ve encountered with Xcelsius 2008 was refreshing too many Live Office components on load from the Data Manager. This would cause the browser to crash when loading the swf. I’m not sure if it’s a bug but a workaround I discovered was to use a Reporting Services Button to perform the refresh on load. You can find the button in the Web Connectivity components...

October 9th, 2008 by David Lai