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.
The voice in my head may not be real , but they have some good ideas !!!
Fail Fast, Fail Forward, Fail Often, Fail Better , Standup Every Time
Every problem has at least one solution. Only some solutions are harder to find.
Friday, June 22, 2007
Popular Posts
-
FS_CLONE Phase It is a stand-alone command used for file system cloning. Standard cloning (using adcfgclone.pl) cannot be used to synch...
-
[oracle@testebsop3app01 ~]$ perl /u01/install/APPS/fs1/EBSapps/comn/clone/bin/adcfgclone.pl appltop /u01/install/APPS/fs1/inst/apps/SATURN_...
-
PRVG-2031 : Owner of file "/u01/app/oracle/diag/crs/rac01/crs/lck" did not match the expected value on node "HOST1". [Ex...
-
Abort Phase If for some reason either the prepare or apply phase failed or gave problems, you can abort the patching cycle. After runnin...
-
As a green field expert in data science, you would be responsible for designing and implementing data science projects from scratch. This i...
-
Suddenly all production reports in BI Publisher failed with message " ORA-01017: invalid username/password; logon denied" The da...
-
EBS 12.2 ADOP Cycle Errors During Validation Cannot open XML file for load ADOP cycle will have validation errors in some cases. *****...
-
ADOP patching on a downtime mode with [ERROR] Patch service is not exist or running Please note , if you get ADOP issues on PROD ple...
-
If you are an EBS administrator the first thing some asks you to do a health check of an environment , you return to him with a Request ID o...
-
Oracle EBS 12.2 - ADOP ad_zd_prep.create_patch_service exceptions Please note , if you get ADOP issues on PROD please read the logs and ...