Skip to Content

how to improve the performance of Dashboards

hi all,

I am getting a performance issue in dashboard which is based on filters. Dashboard fetching total 10,000 records. The Connection i am using is live office with latest instance.

Can anybody tell me how to improve the performance of my dashboard.



Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Apr 26, 2012 at 07:35 AM

    First of all you are fetching too much data out of database. Do the following:

    1. too much of data in the spreadsheet. You are trying to bind 500 or more rows of data to xcelsius components. This makes your dashboard generation slow and at times fails to generate it. Because, Xcelsius is not design to hold too much data in the spread sheet. Try to lower the size of your data in your spread sheet. You can achieve this like adding prompt filters and ask the database the result each time you change the value of the filter.
    2. the number of components in your dashboard. Try to reduce the number of component in your dashboard.
    3. Complexity of your formulas you use in Excel for your dashboard. Xcelsius generates converts the whole Excel logic into Flex and stores it into the Flash file (.swf). As result, generation of your dashboard will take more time. Try to use less excel formulas if possible. Try to avoid using to much of VLOOKUP, HLOOKUP, SUMIF, and MATCH formulas.

    This is the only way you can do this.

    Check also the links below:

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 26, 2012 at 11:04 AM

    just reduce the number of rows of data.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.