5.9.6 Managing Materialized Views
Materialized views are available only for Viewsheets.
You can manage existing materialized views from the 'Materialized View' page under the 'Repository' node of the Server tab.
Figure 30. The Materialized View management page.

Select 'Backup Materialized View' to maintain one or more backups of the existing materialized views. In the event that a materialized view fails to generate, this allows you to restore a prior functional materialized view from back-up rather than regenerating the entire materialized view.
The number of successive materialized view versions to maintain as backups is specified by the mv.backup.dup property in the sree.properties file. (The default is 1.) When 'Backup Materialized View' is enabled, backups of existing materialized views are automatically created whenever the materialized views are regenerated, i.e., whenever the associated cycles are executed. You can also create a backup on-demand (see below).
To restore a materialized view to a backed-up version or to create a backup on-demand, follow the steps below:
1. Press the 'Edit Materialized View' button in the 'Available' column for the materialized view you wish to restore or backup.

This opens the 'Manage Materialized Views' dialog box.
2. To restore the selected materialized view to one of the backup versions, select the desired 'Backup MV' materialized view, and press 'Restore'.

This restores the selected backup materialized view to be the current working materialized view.
3. To create a new backup of the selected materialized view, select the desired 'Default MV' materialized view, and press 'Backup'.

You can make as many backups as allowed by the mv.backup.dup property in the sree.properties file.
4. Press the 'Close' button to exit the 'Manage Materialized Views' dialog box.
To delete a materialized view (for example, if changes have been made to the underlying database schemas), select the materialized view in the table and press the 'Delete' button below the table.
See Also
Creating a Materialized View, for information on materialized view creation.
Dashboard Design, for more information about creating and editing Viewsheets.
| << 5.9.5 Transformations and Faults | © 1996-2013 InetSoft Technology Corporation (v11.5) | 5.9.7 Distributing Materialized Views (Data Grid) >> |