Recently for one of my clients, I had to figure out a way to synchronize the selection of multiple scorecard components. The tables needed to be separated but at the same time we needed to make sure that when hover over a row on one table, that the other tables would have the same row highlighted.

The easiest way to accomplish this is to have a separator column to separate each table, and then overlay a background or rectangle on the blank column. However the rectangle/background looks very ugly as what I have shown on the video.

Please watch the video for a detailed example on how to accomplish the synchronization trick with multiple scorecards.

I’ve also outlined the steps to accomplish this if you click on “More”

Not all corporations want their employees to access dashboards through Infoview as some may want to access dashboards through a 3rd party website or portal such as Sharepoint. On top of that, users generally don’t want a login pop-up to appear whenever dashboard data is first refreshed.

So we’ll need some sort of hidden login mechanism that bypasses the pop-up and allows data to be refreshed on the dashboard.

Thanks to Ryan Goodman for de-mystifying the CELogonToken @ http://ryangoodman.net/blog/index.php/2008/01/21/xcelsius_single_sign_on_with_celogontoke
and thanks to William Sees for posting his code in the SDN network @ http://forums.sdn.sap.com/thread.jspa?threadID=1544768&tstart=30

In this article we will go step by step through the solution on how to retrieve a Business Objects Logon token and insert it into the CELogonToken Flash variable.

The Push Button is a powerful new feature in Xcelsius SP3 that allows developers to transfer source data from an arbitrary sized cell block to a destination cell block of the same size. This gives us a triggering type mechanism where we needed to jump through hoops in order to accomplish before.

I’ve attached a video and the example xlf source file which shows how to use the push button as a default/reset button.

If you have any additional examples that you would like to share, please post them on the comments section below.

Please download the source file here

Dynamic Color Binding is a great new feature in Xcelsius SP3 that allows developers to dynamically bind colors. This gives developers total flexibility on dynamically customizing their coloring schema during run time.

I’ve attached a video which shows a couple examples on using dynamic color binding.

If you have any additional examples that you would like to share, please post them on the comments section.

Conditional formatting in Excel is a feature that is very commonly used and very useful in displaying how well a set of values in a table are doing. Unfortunately we can not transfer the dynamic nature of conditional formatting from Excel to Xcelsius if we were to just insert the table selector object. Basically if the initial binding color of a cell was “Green”, it would stay green even though it were to change to “Red” when the value changes.

Please view my video on how to simply accomplish this using a grid component in Xcelsius

Please visit my post on “MyXcelsius” for a more advanced example of conditional formatting in Xcelsius involving dynamic sliders and charts.

You can download the source file for the example here