Summary Wizard: Step 2 dialog

Use this dialog to choose how to create summary folders. For example, to use query statistics collected on Discoverer Plus users to determine which summaries to create.

For more information, see:

"Creating summary folders manually"

"Managing summary folders"

From items in the End User Layer

Use this radio button to create summary folders from an existing set of tables in the End User Layer.

Based on query performance statistics

Use this radio button to create summary folders based on Discoverer queries that were run previously. This powerful facility means that you do not have to choose the items yourself. Once you have created the summary folder based on previous queries, you can add items and combinations, tailoring it to your users' needs.

Based on an external summary table

Use this radio button to use external summary folders containing tables created with an application external to Discoverer. The column and item names may differ from those in Discoverer. With this option, you will register each external table and map its columns to items in the End User Layer. You can specify that Discoverer take over management of the summary folder, so that it can populate the table and continue to refresh its data.

• From items in the End User Layer (for more information, see, "How to create summary folders based on items in the EUL")

  Use this option to manually select combinations of EUL items that you want to include in a summary folder.

  You might select this option if, for example:

  • you have switched off the Collect Query Statistics privilege (for more information, see "How to specify the tasks a user or role (responsibility) can perform")

  • you want to manually select the combinations of EUL items that make up a summary folder

• Using query performance statistics (for more information, see "How to create summary folders based on users' queries")

  Use this option to choose from a selection of summary folder suggestions (based on queries that have been run) gathered by running query performance statistics. Query performance statistics are automatically generated when queries are run in Discoverer Plus if the Collect Query Statistics privilege is switched on for users (for more information, see "How to specify the tasks a user or role (responsibility) can perform").

  You might select this option if you know that you want to create one or more summary folders based upon specific queries, but you do not necessarily want Discoverer to create any other summary folders.

• Registering an external summary table (for more information, see "How to create summary folders based on external summary tables")

  Use this option when you want your summary folders to be based upon an external summary table. You might use this option if you have your own summary tables that you want