Understanding Data Caching in Pivot Tables and Charts
By default, the data is refreshed after 60 minutes of inactivity. To better understand when the data is refreshed, see the following scenarios:
-
Creating and modifying pivot tables and charts in an existing workbook
-
Saving and re-opening a workbook before 60 minutes have elapsed
-
Saving and re-opening a workbook before 60 minutes have elapsed
Creating and modifying pivot tables and charts in an existing workbook
After you set the layout of a new pivot table or chart, click the Refresh icon 
to apply the changes and update the results. If you make changes to a pivot table directly from the Pivot Table Viewer, the results are automatically displayed.
When you create or modify your pivot tables and charts, SuiteAnalytics Workbook creates a backend query. This backend query definition retrieves the results for the defined pivot tables and charts, and enables you to see the results in the Viewer. If there are pivot tables and charts that share the same backend query definition, the data used for the refresh can vary:
-
If the backend query was refreshed less than 60 minutes ago from either the pivot or chart tab, the data from the cache is used for the refresh.
-
If the backend query was refreshed more than 60 minutes ago from either the pivot or chart tab, the most current data is used for the refresh.
Note that some changes in pivot tables and charts require loading real-time data. For example, adding a field to Rows, Columns, or Measures.
You can verify the time of the last refresh in the upper-right corner of the pivot table or chart viewer.
Saving and re-opening a workbook before 60 minutes have elapsed
When you re-open a saved workbook before 60 minutes have elapsed and open a pivot table or chart, by default the Viewer displays cached data. The time of the last refresh appears in the upper-right corner of the Viewer. To retrieve the most current data, click the Refresh icon.
Saving and re-opening a workbook after 60 minutes have elapsed
When you re-open a saved workbook after 60 minutes have elapsed, the cached data has expired. Consequently, when you open a pivot table or chart, the Viewer automatically displays the most current results.
Working with the Analytics Portlet
The pivot tables and charts in the Analytics portlet display the same data as their corresponding workbooks. However, you can retrieve the most current results by clicking the Refresh icon .
For more information about how to clear the cache manually, see Clearing the Cache for Pivot Tables and Charts.