Oracle® Fusion Middleware Administrator's Guide for Oracle Business Intelligence Discoverer 11g Release 1 (11.1.1) Part Number B32519-01 |
|
|
View PDF |
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"
How do you want to create this summary folder?
From items in the End User Layer
Use this option to create summary folders from an existing set of folders in the End User Layer (for more information, see "How to specify the tasks a user or role (responsibility) can perform").
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
Based on query performance statistics
Use this option 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. After you create the summary folder based on previous queries, you can add items and combinations, tailoring it to your users' needs (for more information, see "How to create summary folders based on users' queries").
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.
Based on an external summary table
Use this option to use external summary folders containing tables created with an application external to Discoverer. The column and item names might 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 (for more information, see "How to create summary folders based on external summary tables").