What’s cooler than 500 rows in Xcelsius? 50,000 rows in Xcelsius!

Sap Dashboards (Xcelsius) certainly has its limitations. I will be the last one to argue otherwise. However, i often run into misconceptions about what those are exactly. A good example if the 500 rows limit. By default, Xcelsius is preconfigured out-of-the-box to limit cell bindings to 500 rows in the excel model. However, you can change this initial setting to your heart content. Why was this low limit set to begin with? Well, there are many reasons why you would see degraded performance in flash in general, and Xcelsius in particular, as you cram more functionality and data into your .swf file. The larger and more complex your .swf is, the more work your client computer has to do in order to manipulate and render the functionality desired, and to keep things simple, a 500 rows limit on most component seemed reasonable initially. As more sophisticated business intelligence applications are being built using Xcelsius, this limitation seems out of touch.
In the example below, you can click the Cool hyperlink to fire a javascript function that initialized an array with 500 values and passes it to Xceslius grid component (a list view) via an EIC connection. Or, you can click the Cooler hyperlink to fire the same function, but this time construct  a 50,000 values array and pass it to Xcelsius via EIC.

Does this mean you can have limitless dashboards with tens of thousands of rows of data in them? No, it does not, this is just an illustration to make a point. Realistically, your grid components should not exceed the low thousands if you are expecting good performance, and of course,  many parameters will go into the sizing considerations such as the number and kind of components you are using, the complexity of functionality, as expressed in your model, etc. You can find the sample files here.

This entry was posted in Xcelsius and tagged , , . Bookmark the permalink.

2 Responses to What’s cooler than 500 rows in Xcelsius? 50,000 rows in Xcelsius!

  1. I downloaded the source code but it says it will only work with an older version of Xcelsius. Do you have a current version? I would like to learn more about Javacript and Xcelsius.

    • Ron Keler says:

      Hi Anthony, thanks for the comment and interest. This example was created using Xcelsius 2008, SP4. You should have no problem opening it in SAP Dashboards (the current version). What version are you using (look in Help->About)?

Leave a Reply

Your email address will not be published. Required fields are marked *