Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a document which takes several seconds to update so each time I make a change I have to wait.
Is there a way to stop updating while I am arrangeing tables , colors and so on and, when finish, recover normal updating again?.
Thanks.
My suggestion is to make a selection, so that the current data set is limited to a minimum. Then go to File > Reduce Data > Keep Possible Values. This remove the non-selected data until you reload the application next time.
A reduced data set should keep calculation times to a minimum, since there is less data to calculate.
If the calculation time is a permanent issue I would recommend evaluating if the data model has any flaws, or maybe you perform static calculations that could be pre-calculated into the data model during reload.
A common issue causing large calculation times, is that key fields are used in expressions and dimensions. This can easily lead to larger memory expansions than required. Avoid using key fields in calculations and sheet objects.
The final thing to check for is synthetic keys in the data model. These commonly also can leads to unexpected memory expansion, leading to lager calculations times.
This is not normal behaviour, probably you have used somewhere in your expression or conditions the function Now()
Check it, if so change it with Today()
Hope it helps
I did not use 'Now' it is just a very complex document whith many calculations I think.
Thanks.
Working on reduced application could be an option. That should take less update time. File Menu-> Reduce Data
Are you in Web Mode? If so, extension objects tend to refresh everytime something moves.
If not in web mode and one chart is causing the issues, simply detach the chart.
Chart Properties-->General-->Detached.
reduce your data.. this helps your loading time issue while developing
i.e in script try with 100 or 1000 records as below
first 1000
load *
table1.qvd;
thanks
Sri1
Hi,
Do some selection in your document and reduce the size of chart.
So that it reduce calculation time.
Then make your changes.
Regards,
My suggestion is to make a selection, so that the current data set is limited to a minimum. Then go to File > Reduce Data > Keep Possible Values. This remove the non-selected data until you reload the application next time.
A reduced data set should keep calculation times to a minimum, since there is less data to calculate.
If the calculation time is a permanent issue I would recommend evaluating if the data model has any flaws, or maybe you perform static calculations that could be pre-calculated into the data model during reload.
A common issue causing large calculation times, is that key fields are used in expressions and dimensions. This can easily lead to larger memory expansions than required. Avoid using key fields in calculations and sheet objects.
The final thing to check for is synthetic keys in the data model. These commonly also can leads to unexpected memory expansion, leading to lager calculations times.
I think the problem is that I have many variables (100 or so) in many expressions.
Thanks