Set data refresh options for a view

You can set data refresh options for a view directly from the Cube Viewer. These options determine which actions in a view will trigger a data refresh.

1. Open the Cube Viewer.
2. Click the Refresh data icon .
3. Set the data refresh option that you want to apply to the view.
   Select After each context change to refresh data after actions that change the structure of the view. This includes actions such as:

   • swapping rows and columns,
   • moving hierarchies between rows, columns, context, and the bench, or
   • expanding or collapsing members in the rows or columns.

   If you clear this option, you must manually refresh data after modifying the structure of a view.

   Defer on leaf data change controls whether direct edits in leaf cells trigger a data refresh. When the option is selected, data is updated when the view is refreshed (either explicitly or by an action that triggers a refresh), and not when data is changed in leaf cells. Clear this option to refresh view data whenever a leaf cell is modified. This option is off by default when you create a new view in a book.

   Data is always refreshed immediately in a view with any of the following actions:

   • data is entered in consolidated cells,
   • data is spread in leaf cells,
   • data is spread from the Spreading dialog, or
   • cells are updated from a date picker.