reduce Load on charts

[#1]

My application takes 4 minutes to get reloaded,

applications contains 15 sheets in every sheet have 10 charts, whn i surf through the report it takes time to get the data refreshed in the chart

how can i minimise the load,

m using SUM in maximum expressions..

hw can i reduce the load...

Any suggestions.

[Anonymous]

HI

You can reduce the data in your application..

Select any one data in any field eg. Select 2007 in the year field, then go to file --> Reduce Data---> Keep Possible values.

Thus the application is limited to the selcected data alone.

Now reloading will be quick compared to the old one..

Hope it helps u

Regards

Revathy

[#3]

Thks Revathy,

reloading is not a problem, the user whn surf through the sheets, it takes max time to get loaded with data in the chart

[#4]

Are you trying to show case all the charts in the screen at the same time.

Regards,

Nitin Jain

[#5]

Yes thts the requirement and moreovr all charts contain 7 to 8 expressions wherein have used SUM so groupimg is causing the problem, hw cn i reduce the load..........

[sushil353]

Hi,

there are many things which are related to the performance of the report.

1. is your qvw file is big in size as compare to the RAM you have in your system or server?

2. are you using too many conditions in your chart to calculate the expressions.?

3. do u have unneccessory field in your data model which are not at all required for the analysis.?

4. is there any data modelling issues like circular loop, synthetic keys etc...

5. are u using too many text objects in your application ..

take care while creating app or data model it is going to affect your app performance.

HTH

Sushil

[#7]

Any more suggestions please.....

[#8]

Hey Guyz,

m still stuck at it, please give me some suggestions......

[suniljain]

It may be issue of data model and complex expression used in chart . other than that I do not think any factor resoponsilbe if your dashboard refreshed in 4 minutes.

Regards;

Sunil

[#10]

Hey Sunil,

Do variables causing problem,

as many variables have been used for calender operations.