David Lai's Business Intelligence Blog

Xcelsius Dynamic Color Binding

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...

Simulating Excel Conditional Formatting in Xcelsius

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...

Alpha Numeric Sorter

Here is an Xcelsius Example that ranks your table based on whether you want to rank it numerically or alphabetically. [kml_flashembed publishmethod=”static” fversion=”8.0.0″ movie=”http://www.davidlai101.com/blog/media/blogs/bobj/Excel%20Ranker/Alphanumeric%20Sorter.swf” width=”500″ height=”200″ targetclass=”flashmovie”] [/kml_flashembed] Many...