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

Use this tab to configure how you purge (i.e. 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.

Available

This field displays all folders that are not excluded from the purge. Select folders for exclusion from the purge by moving folders from the Available field to the Selected field.

Selected

This field displays folders that are excluded from the purge. Remove folders from the exclusion by moving folders from the Selected field to the Available field.

Notes

• You cannot move external summary folders from the Selected field.

• If you try to move an external summary folder from the Selected field to the Available field a warning message appears and the summary folder remains in the Selected 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.