Our QVW file size is vary huge.And giving slow response time.Is has having too many complex aggr functions on chart level as well.
I am sharing performance document analyzer file for our application can you please suggest where should we go ahead to optimize the performances.
From summary tab, it shows you have 127MB of unused fields in the dashboard. You can remove those. Find the below.
Click the Objects tab, and sort the calc time. You will come to know which object is consuming more calc time. Eg
From the above information, go to the object id CH30, pivot table and check the expressions.
If you have many expressions, disable one by one and check which expression is consuming more calc time from the sheets tab, on the document properties.
All those fields has been dropped already can you please tell me is there any difference between dropping fields and commenting out or removing the fields the unused fields.
But after dropping fields also i do not know why fields are showing as a unused fields in document analyzer and such kind of 127 fields are there.
Do check if these fields are used in any expression variables as Document Analyzer only finds fields that are directly used in Dimensions or Expressions, and not fields indirectly used via expressions.