Disabling and Enabling Auto-Execution
By default, when you make any change to the pivot table, the Analyzer re-executes the query and redisplays the results. You can disable this auto-execution. To do so, clear the Auto-execute option on the toolbar. Later, to enable auto-execution, select the Auto-execute option.
Note:
If you disable auto-execution and save the pivot table, that change is saved as part of the pivot table definition and affects the behavior of any dashboards that use the pivot table. Therefore, you should be careful to make this change and save it only if you do not want the pivot table to run automatically in dashboards, though actions may still be invoked from the Analyzer with the current query described by the pivotTable object even if said pivotTable has not been executed. Be sure to include a refresh control in any widget that displays this pivot table. For more information, refer to this section on manual query editing.
