Filtering Data works slowly

[rsdhavle]

In the dashboard Navigation and other objects are running fine however filtering is working very slow. It is taking almost 40 seconds for any particular filter when i click on any list box where as dashboard loads in 7 seconds.

[Gysbert_Wassenaar]

Try analyzing the document with Document Analyzer V3.2 Update to see which parts are impacting performance.

[rsdhavle]

We have already setup analyzer V3.1..in that i can see some data elements taking memory..is there any way we can see if any particular expression is causing this or handling data elements will help in our case?

[Gysbert_Wassenaar]

Yes. Test the expressions individually to see what each contributes to the calculation cost.

[rsdhavle]

Thanks i am getting idea about calculation cost for each expression. Putting any particular expression into variable will help?

[Gysbert_Wassenaar]

That depends. It will still need to be calculated. But it may make a difference if it doesn't need to be calculated at the row level, but can be calculated at the document level.