Summary Wizard (ASM): Change default settings dialog: Deletion tab

Use this tab to configure how you purge (remove) summary folders that are out-of-date. For example, to make more space available in the database.

For more information, see:

"Managing Summary Folders"

Delete specific summary folders if

Last queried more than _ days ago

Use this field to delete summary folders if they were last used by Discoverer end users more than the number of specified days. For example, delete summary folders not used for seven days.

Created more than _ days ago

Use this field to delete summary folders if they were created before a specified time. For example, delete summary folders created more than two weeks ago.

Average usage less than _ times per _ over the last _ _

Use these fields when you want to finely control which summary folders are purged. For example, delete summary folders used less than ten times per week over the last two weeks.

Always retain the following summaries

Use this check box to exclude particular summary folders from the purge. For example, to maintain important summary folders that you always need to use.

Summaries to be retained

This field displays folders that are excluded from the purge. Include folders in the purge by moving folders from the Summaries to be retained field to the Available summaries field.

Available summaries

This field displays all folders that are included in the purge. Select folders to be excluded from the purge by moving folders from the Available summaries field to the Summaries to be retained field.

Notes

  • You cannot move external summary folders from the Summaries to be retained field.

  • If you try to move an external summary folder from the Summaries to be retained field to the Available summaries field a warning message appears and the summary folder remains in the Summaries to be retained field. Discoverer does not delete external summary data as it does not own it. Also deleting the metadata associated with external summary tables would not yield any great space gain which is why it is not done.