Friday, June 22, 2007

Discoverer : Summary Management

Summary Management
The Summary Management feature in Discoverer uses native features in the Oracle DBMS, and is therefore only available when running against the Oracle database. This feature uses the same highly scalable and reliable processing procedures within the kernel as the workbook scheduling capability and the setup for both features is similar. These procedures use standard packages in the DBMS called "DBMS_JOB".

Privileges
The user ID that you intend to use to create the Summary Folders must have the following database privileges:
CREATE TABLE
CREATE VIEW
CREATE PROCEDURE
SELECT ON V_$PARAMETER
ANALYZE ANY (ASM)
CREATE/DROP/ALTER ANY MATERIALIZED VIEW (8.1.6+)
GLOBAL QUERY REWRITE

We will be looking on the following

* Defining Privileges Required
* Open a Business Area and Access Summary Wizard
* Running the Wizard to have Discoverer recommendation and best summaries.
* Running the Wizard to have Discoverer Administration to it him/her self.



Defining Privileges Required



Open a Business Area and Access Summary Wizard



Running the Wizard to have Discoverer recommendation and Best Summaries














Running the Wizard to have Discoverer Administration to it him/her self





Summary : Ran Summary Wizard with two options. One with Oracle Discoverer Recommendation and Implementing the Best Practise. Other option with Self Management which an Administrator can perform on his/her own.

Popular Posts