Use the Summaries tab to manage summary folders in the EUL grouped by business area. From here you can:
create new summary folders
edit summary folders
refresh summary folders
delete summary folders
examine summary folders properties
validate summary folders
For more information, see:
Use the list to select a summary folder.
To see a list of menu options available for a summary folder, right click the cube icon that represents the summary folder. Discoverer represents summary folders as follows:
|Summary folder||How the summary folder is represented in Discoverer|
|valid summary folder.||a cube icon with a clock face|
|valid external summary folder||a cube icon|
|broken summary folder||a cube icon with a yellow warning triangle|
If Discoverer displays the message 'This user requires Create Any Materialized View privilege' when you try to refresh a summary folder, you do not have the necessary privileges to refresh summary folders. To grant the necessary privileges, follow these steps:
Log out of Discoverer Administrator.
Start Oracle SQL*Plus, and connect using the database administrator user name and password.
Run the following SQL script:
Restart Discoverer Administrator
A summary folder is considered broken when Discoverer cannot use the materialized view, summary table or detail tables. To find out more about why a summary folder is broken, use the View | Validate Summaries menu option. You might want to edit a broken summary folder to investigate its composition and remove any broken folders.