how to improve the performance of Dashboards

[former_member182342]

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.

Regards,

Anish

[former_member184594 · Accepted solution]

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:

http://www.infosol.com/mwg-internal/de5fs23hu73ds/progress?id=pGFn93+2tc

http://www.sdn.sap.com/mwg-internal/de5fs23hu73ds/progress?id=7UzTQYbahB&dl

[Former Member]

just reduce the number of rows of data.

[former_member182342]

Hi,

Thanks for ur reply.

Regards,

Anish