10 Strategies to improve your Flash Dashboard’s Performance

Here are 10 strategies you can use to improve your flash dashboard performance

1.Break the dashboard into multiple dashboards and link them together in a logical way. If the dashboards are prompted you can of course pass the prompt answers in the url.

2.Reduced the row count of detailed grids. Try using rank on one of the metrics and display only the top 10 rows via view filter qualification. Then provide a link to the detailed report which is a regular MicroStrategy grid report. This way the report results are already cached, users get a preview of the grid data, and if they want more info they can easily access it.

3.During development monitor dashboard xml size. You do this by installing a FireFox plugin called firebug. In the Console > Net window you will see all the components downloaded when rendering a page. Look for something called GET taskProc?taskID=docXMLResult… There are two and the second one usually corresponds to the actual data. You should see the size next to it, if not you can download the file directly and save it to your desktop.

4.Try to keep the xml size (file mentioned above) under 6-7mb. During our testing this seemed to be the optimal size beyond which dashboard rendering and selector performance degrades. We have implemented dashboards up to 12mb, but user expectation was set appropriately.

5.Narrowcast dashboards over 7mb as mht files.

6.Avoid large metric selectors when possible. Each metric in this type of selector corresponds to a chunk of xml that defines a precalculated grid view.

7.Use attribute selector over group by for paging.

8.Don’t go crazy with interactivity. The more selectors and widgets you add the worse your dashboard performance will be.

9.When narrowcasting very large dashboards using personalized page execution with segmentation objects to reduce the dashboard instance size. Services with dashboard instances over 200mb move very slowly in the slicing phase. Sizes above 200mb can cause narrowcast to crash.

10.All else failing, push hard for Interactive Mode. If designed properly it can look quite nice.