Oracle Discoverer Administrator Administration Guide 10g (9.0.4) Part Number B10270-01 |
|
This chapter explains how to use Discoverer Administrator's EUL status workbooks and contains the following topics:
EUL status workbooks are Discoverer workbooks that provide useful reports for managing and documenting Discoverer End User Layers (EULs). The EUL status workbooks query information from folders in the Discoverer EUL V5 business area. You can analyze EUL status workbooks in Discoverer Plus or Discoverer Viewer.
You can give any Discoverer user access to the EUL status workbooks. However, the EUL status workbooks are intended primarily for administrative purposes.
The following EUL status workbooks are supplied with Discoverer:
Instructions explaining how to use each workbook are contained within individual worksheets.
Although the EUL status workbooks are supplied with Discoverer, they are not installed by default. How to install the workbooks depends on the type of EUL as follows:
The EUL status workbooks are installed into the <ORACLE_HOME>\discoverer directory.
Having installed the EUL status workbooks, you can:
Note that you can only run the EUL status workbooks against Oracle databases.
You can edit the workbooks or the Discoverer EUL V5 business area to suit your requirements. You can also create your own EUL status workbooks.
The Discoverer EUL V5 business area is similar to any other business area in the EUL. The folders within Discoverer EUL V5 business area include:
You can use the folders in the Discoverer EUL V5 business area to build your own workbooks to analyze and document the structure of your Discoverer business areas.
Note that certain folders in the Discoverer EUL V5 require the EUL owner to have SELECT access to the DBA_JOBS_RUNNING database table. For more information, see "Notes on EUL status workbooks and the table DBA_JOBS_RUNNING".
If you want to modify the supplied EUL status workbooks, we recommend you save a copy with a different name and modify the copy. Otherwise, any changes you make could be lost because the supplied EUL status workbooks are replaced with each new version of Discoverer.
Follow these steps if you are running Discoverer against a standard EUL.
Note: You must have an EUL installed (for more information, see Chapter 3, "Creating and maintaining End User Layers").
To install the standard EUL status workbooks:
For example, if SQL*Plus is already running, you might type the following at the command prompt:
SQL> connect jchan/tiger
Where jchan is the EUL owner and tiger is the EUL owner password.
For example you might type the following at the command prompt:
SQL> start d:\<ORACLE_ HOME>\discoverer\util\eul5.sql
Where <ORACLE_HOME> is where Discoverer Administrator is installed.
The eul5.sql file creates some custom PL/SQL functions required by the Discoverer EUL V5 business area.
The selected SQL file eul5.eex appears in the Import file list.
The default settings are acceptable.
This dialog enables you to start the import and monitor its status as each EUL object is processed.
When the import is complete, the 'Import Successful' message is displayed.
Having imported the EUL status workbooks you can now open them using Discoverer Plus or Discoverer Viewer.
EUL4_GET_ANALYZED
EUL4_GET_COMPLEX_FOLDER
EUL4_GET_HEIRLVL
EUL4_GET_HIERORD
EUL4_GET_ITEM
EUL4_GET_ITEM_NAME
EUL4_GET_OBJECT
EUL4_GET_OBJECT_NAME
EUL4_GET_SIMPLE_FOLDER
Hint: For more information about how to remove PL/SQL functions, see the appropriate steps contained in "How to uninstall the Discoverer EUL V5 business area").
Follow these steps if you are running Discoverer against an Oracle Applications EUL.
Note: You must have an Oracle Applications EUL installed (for more information, see Chapter 16, "Using Discoverer with Oracle Applications").
To install the Oracle Applications EUL status workbooks:
For example, if SQL*Plus is already running, you might type the following at the command prompt:
SQL> connect jchan/tiger
Where jchan is the EUL owner and tiger is the EUL owner password.
For example you might type the following at the command prompt:
SQL> start d:\<ORACLE_ HOME>\discoverer\util\eul5_apps.sql
Where <ORACLE_HOME> is where Discoverer Administrator is installed.
The eul5_apps.sql file creates some custom PL/SQL functions required by the Discoverer V5 EUL business area.
You are prompted for the username of the Oracle Applications FNDNAM schema.
Note: Only enter the FNDNAM schema's username. Do not enter a password
You are prompted to check the username you entered.
If the name is not correct, re-run the script.
The selected SQL file eul5.eex appears in the Import file list.
The default settings are acceptable.
This dialog enables you to start the import and monitor its status as each EUL object is processed.
When the import is complete, the 'Import Successful' message is displayed.
Having imported the EUL status workbooks you can now open them using Discoverer Plus or Discoverer Viewer.
To run the EUL status workbooks with an Oracle Applications EUL in Discoverer Plus, you must connect as an Oracle Applications User or Responsibility. You cannot run the EUL status workbooks as the EUL owner.
To run Oracle Applications EUL status workbooks:
For more information about granting access to business areas, see Chapter 6, "Controlling access to information".
To uninstall the Discoverer EUL V5 business area:
Note: If the EUL status workbooks are installed in an Oracle Applications EUL, you cannot connect to Discoverer Plus as the EUL Owner to delete the workbooks. Instead, use the Discoverer Administrator command line interface to delete the workbook by typing the following at the command prompt:
<ORACLE_HOME1>\bin\dis51adm.exe /connect <eulowner>/<eulowner @ password>@<database> /delete /workbook "<workbook name>"
where "<workbook name>" is either "EUL Data Definition" or "Query Statistics".
You can now remove the PL/SQL functions associated with the Discoverer EUL V5 business area.
EUL5_GET_ANALYZED
EUL5_GET_APPS_USERRESP
EUL5_GET_COMPLEX_FOLDER
EUL5_GET_HEIRLVL
EUL5_GET_HIERORD
EUL5_GET_ISITAPPS_EUL
EUL5_GET_ITEM
EUL5_GET_ITEM_NAME
EUL5_GET_OBJECT
EUL5_GET_OBJECT_NAME
EUL5_GET_SIMPLE_FOLDER
You have now successfully removed the EUL status workbooks.
The EUL Data Definition workbook provides reports on the objects contained in the EUL. You would use the EUL Data Definition workbook to learn more about how EUL objects are configured. The workbook consists of the following worksheets:
The Query Statistics workbook displays statistical information about the queries that end users have run. You would use the Query Statistics workbook to learn more about the nature of end user queries. The workbook consists of the following worksheets:
Certain folders (specifically the EUL5_DBA_JOBS_RUNNING folder) in the Discoverer EUL V5 business area require the EUL owner to have SELECT access to the DBA_JOBS_RUNNING database table. Without SELECT access to this table, the ORA-01031 message regarding insufficient privileges is displayed.
To grant SELECT access to DBA_JOBS_RUNNING:
For example, if SQL*Plus is already running, you might type the following at the command prompt:
SQL> connect dba_user/dba_password
Where dba_user
is a user with the dba privilege and dba_pw is the password.
SQL> grant select on dba_jobs_running to <EUL owner>; SQL> commit;
To confirm that the EUL owner has select access to the DBA_JOBS_RUNNING database table:
For example, if SQL*Plus is already running, you might type the following at the command prompt:
SQL> connect jchan/tiger
Where jchan is the EUL owner and tiger is the EUL owner password.
SQL> desc DBA_JOBS_RUNNING
If the EUL owner has select access to DBA_JOBS_RUNNING, a list of columns in the table is displayed. Otherwise, a message indicating the object does not exist is displayed.
|
![]() Copyright © 1996, 2003 Oracle Corporation. All Rights Reserved. |
|