About Warehouse Builder Browser
'); dbms_lob.writeappend(clob_loc, 5, 'Displays information about the Warehouse Builder '); dbms_lob.writeappend(clob_loc, 58, 'Browser such as the Build and Version numbers.
'); dbms_lob.writeappend(clob_loc, 5, ''); dbms_lob.close(clob_loc); --text document 'us/admn_crt_dblnk.html' insert into wmp_text_docs (doc_name, doc_value,language) values ('admn_crt_dblnk.html', empty_clob() ,'us'); select doc_value into clob_loc from wmp_text_docs where doc_name = 'admn_crt_dblnk.html'; dbms_lob.open(clob_loc, dbms_lob.lob_readwrite); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 7, ' '); dbms_lob.writeappend(clob_loc, 39, '
Creating Database Links
'); dbms_lob.writeappend(clob_loc, 5, 'To create a database link:
'); dbms_lob.writeappend(clob_loc, 13, ''); dbms_lob.writeappend(clob_loc, 91, '4. Specify the remote database information.1. Select Create Database Link from the Administer '); dbms_lob.writeappend(clob_loc, 79, ' Database Links page which is linkable from the Register Repository page.
'); dbms_lob.writeappend(clob_loc, 41, ' 2. Specify the database link name.
'); dbms_lob.writeappend(clob_loc, 46, ' 3. Specify the OWB repository user name and '); dbms_lob.writeappend(clob_loc, 16, ' password.
'); dbms_lob.writeappend(clob_loc, 98, '
Administering Database Links
'); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 5, 'Use the Administer Database Links '); dbms_lob.writeappend(clob_loc, 65, 'page to edit, drop, or view information about database links. If '); dbms_lob.writeappend(clob_loc, 52, 'you need to create database links, select Create '); dbms_lob.writeappend(clob_loc, 66, 'Database Link. To edit '); dbms_lob.writeappend(clob_loc, 62, 'a database link, select edit and use the Edit Database '); dbms_lob.writeappend(clob_loc, 47, 'Link page. For more information, see Editing '); dbms_lob.writeappend(clob_loc, 67, 'a Database Link.
'); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 60, 'To view information about '); dbms_lob.writeappend(clob_loc, 31, 'database links:
'); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 5, ''); dbms_lob.writeappend(clob_loc, 66, ''); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 74, 'NOTE: The View Database '); dbms_lob.writeappend(clob_loc, 64, ' Link page does not allow you to edit the link. Use the Edit '); dbms_lob.writeappend(clob_loc, 75, ' Database Link page to make changes and updates to the link.
'); dbms_lob.writeappend(clob_loc, 14, '
To drop a database link:
'); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 5, ''); dbms_lob.writeappend(clob_loc, 64, ''); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 5, 'NOTE: Once you drop a '); dbms_lob.writeappend(clob_loc, 65, ' database link it is permanently destroyed. You must recreate '); dbms_lob.writeappend(clob_loc, 53, ' the link if you want to use it again.
'); dbms_lob.writeappend(clob_loc, 14, '
Loading Preferences
'); dbms_lob.writeappend(clob_loc, 5, 'Use the Load Preferences page to load preferences '); dbms_lob.writeappend(clob_loc, 88, 'directly into an upgraded Warehouse Builder Browser from an existing Schema.
'); dbms_lob.writeappend(clob_loc, 87, 'To load preferences from an existing schema:
'); dbms_lob.writeappend(clob_loc, 13, ''); dbms_lob.writeappend(clob_loc, 39, ''); dbms_lob.writeappend(clob_loc, 5, '1. Type '); dbms_lob.writeappend(clob_loc, 41, 'in the following information:
'); dbms_lob.writeappend(clob_loc, 5, ''); dbms_lob.writeappend(clob_loc, 58, '
'); dbms_lob.writeappend(clob_loc, 88, '- Schema Name
'); dbms_lob.writeappend(clob_loc, 62, '- Schema Password
'); dbms_lob.writeappend(clob_loc, 55, '- Hostname
'); dbms_lob.writeappend(clob_loc, 63, '- Host Port Number
'); dbms_lob.writeappend(clob_loc, 59, '- Database SID
'); dbms_lob.writeappend(clob_loc, 6, '2. Click OK to load the preferences.
'); dbms_lob.writeappend(clob_loc, 14, '
Warehouse Builder Administration
'); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 5, 'Use the Warehouse Builder '); dbms_lob.writeappend(clob_loc, 64, 'Administration page to access the Administration functions. The '); dbms_lob.writeappend(clob_loc, 66, 'Administration functions can only be accessed if the current user '); dbms_lob.writeappend(clob_loc, 47, 'has Full Administrator privileges.
'); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 61, 'Click the following links for '); dbms_lob.writeappend(clob_loc, 56, 'specific information about these functions:
'); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 5, 'The following table describes some '); dbms_lob.writeappend(clob_loc, 58, 'of the action links available on this portlet.
'); dbms_lob.writeappend(clob_loc, 19, '| Action '); dbms_lob.writeappend(clob_loc, 29, ' Link | '); dbms_lob.writeappend(clob_loc, 96, 'Description | '); dbms_lob.writeappend(clob_loc, 10, '
| Help | '); dbms_lob.writeappend(clob_loc, 74, 'Displays '); dbms_lob.writeappend(clob_loc, 54, ' the online help for this portlet. | '); dbms_lob.writeappend(clob_loc, 10, '
| About | '); dbms_lob.writeappend(clob_loc, 74, 'Displays '); dbms_lob.writeappend(clob_loc, 69, ' information about the Warehouse Builder Browser. | '); dbms_lob.writeappend(clob_loc, 10, '
| Full '); dbms_lob.writeappend(clob_loc, 25, ' Page | '); dbms_lob.writeappend(clob_loc, 74, 'Displays '); dbms_lob.writeappend(clob_loc, 53, ' the Navigator in full page mode. | '); dbms_lob.writeappend(clob_loc, 10, '
'); dbms_lob.writeappend(clob_loc, 8, ' '); dbms_lob.writeappend(clob_loc, 8, ' '); dbms_lob.close(clob_loc); --text document 'us/admn_mng_di.html' insert into wmp_text_docs (doc_name, doc_value,language) values ('admn_mng_di.html', empty_clob() ,'us'); select doc_value into clob_loc from wmp_text_docs where doc_name = 'admn_mng_di.html'; dbms_lob.open(clob_loc, dbms_lob.lob_readwrite); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 7, ' '); dbms_lob.writeappend(clob_loc, 45, '
Managing the Dependency Index
'); dbms_lob.writeappend(clob_loc, 5, 'Use the Manage Dependency '); dbms_lob.writeappend(clob_loc, 105, 'Index page to specify when to refresh the Dependency Index. The Dependency Index is used when displaying '); dbms_lob.writeappend(clob_loc, 79, 'Lineage and Impact Analysis diagrams. In order for the diagrams to display the '); dbms_lob.writeappend(clob_loc, 79, 'most current information, the index must be synchronized regularly.
'); dbms_lob.writeappend(clob_loc, 76, 'Choose dependency index '); dbms_lob.writeappend(clob_loc, 87, 'refresh frequency by choosing one of the options below for each repository.
'); dbms_lob.writeappend(clob_loc, 32, '| Option | '); dbms_lob.writeappend(clob_loc, 105, 'Description | '); dbms_lob.writeappend(clob_loc, 8, '
| Refresh on demand | '); dbms_lob.writeappend(clob_loc, 100, 'With ');
dbms_lob.writeappend(clob_loc, 52, ' this option, you must activate the refresh ');
dbms_lob.writeappend(clob_loc, 77, 'dependency index link to refresh the index. The refresh dependency index ');
dbms_lob.writeappend(clob_loc, 55, ' link is located on Navigator page that lists all ');
dbms_lob.writeappend(clob_loc, 81, ' accessible repositories. The dependency index will not be refreshed unless ');
dbms_lob.writeappend(clob_loc, 44, ' this action link is activated. ');
dbms_lob.writeappend(clob_loc, 75, ' This is the best '); dbms_lob.writeappend(clob_loc, 75, ' option when using a repository that changes infrequently. '); dbms_lob.writeappend(clob_loc, 10, ' | ');
dbms_lob.writeappend(clob_loc, 8, '
| Refresh on first diagram request of the '); dbms_lob.writeappend(clob_loc, 26, ' session | '); dbms_lob.writeappend(clob_loc, 107, 'This option ');
dbms_lob.writeappend(clob_loc, 93, ' refreshes the dependency index when the first Lineage or Impact Analysis diagram for a ');
dbms_lob.writeappend(clob_loc, 43, 'repository is run during a session. ');
dbms_lob.writeappend(clob_loc, 75, ' This is the best '); dbms_lob.writeappend(clob_loc, 81, ' option if you want current information, but are not concerned with updates '); dbms_lob.writeappend(clob_loc, 48, ' that occur during the session. '); dbms_lob.writeappend(clob_loc, 10, ' | ');
dbms_lob.writeappend(clob_loc, 8, '
| Refresh on every diagram '); dbms_lob.writeappend(clob_loc, 27, ' request | '); dbms_lob.writeappend(clob_loc, 107, 'This option ');
dbms_lob.writeappend(clob_loc, 43, ' refreshes the dependency index every ');
dbms_lob.writeappend(clob_loc, 63, 'time a Lineage or Impact Analysis diagram is requested. ');
dbms_lob.writeappend(clob_loc, 75, ' This is the best '); dbms_lob.writeappend(clob_loc, 78, ' option if you want to display your diagrams and reports with the latest '); dbms_lob.writeappend(clob_loc, 48, ' information in the repository. '); dbms_lob.writeappend(clob_loc, 10, ' | ');
dbms_lob.writeappend(clob_loc, 8, '
'); dbms_lob.close(clob_loc); --text document 'us/admn_mng_prf.html' insert into wmp_text_docs (doc_name, doc_value,language) values ('admn_mng_prf.html', empty_clob() ,'us'); select doc_value into clob_loc from wmp_text_docs where doc_name = 'admn_mng_prf.html'; dbms_lob.open(clob_loc, dbms_lob.lob_readwrite); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 7, ' '); dbms_lob.writeappend(clob_loc, 36, '
Managing Preferences
'); dbms_lob.writeappend(clob_loc, 5, 'Use the Manage Preferences page to save and load Warehouse Builder Browser preferences. This lets you retain your preferences when you upgrade to a new version of Warehouse Builder Browser. ');
dbms_lob.writeappend(clob_loc, 92, 'Using the save and load features, you can copy schema preferences across schemas.
');
dbms_lob.writeappend(clob_loc, 49, 'The preferences you can save include:
Saving Preferences
'); dbms_lob.writeappend(clob_loc, 73, 'To save preferences to a file:
'); dbms_lob.writeappend(clob_loc, 81, '1. Select Save Preferences from the Manage '); dbms_lob.writeappend(clob_loc, 29, 'Preferences page.
'); dbms_lob.writeappend(clob_loc, 81, 'The preferences display in a separate window in a '); dbms_lob.writeappend(clob_loc, 34, 'condensed text format.
'); dbms_lob.writeappend(clob_loc, 81, '2. From the browser menu bar, select File, '); dbms_lob.writeappend(clob_loc, 53, 'and then Save As to save the file.
'); dbms_lob.writeappend(clob_loc, 78, 'This file can be loaded into Warehouse Builder '); dbms_lob.writeappend(clob_loc, 36, 'Browser using SQL* Plus.
'); dbms_lob.writeappend(clob_loc, 69, 'Loading Preferences
'); dbms_lob.writeappend(clob_loc, 50, 'Click the Load '); dbms_lob.writeappend(clob_loc, 33, 'Preferences link to load the '); dbms_lob.writeappend(clob_loc, 81, 'preferences directly into an upgraded Warehouse Builder Browser from an existing '); dbms_lob.writeappend(clob_loc, 20, 'Schema.
'); dbms_lob.writeappend(clob_loc, 5, ''); dbms_lob.close(clob_loc); --text document 'us/admn_port.html' insert into wmp_text_docs (doc_name, doc_value,language) values ('admn_port.html', empty_clob() ,'us'); select doc_value into clob_loc from wmp_text_docs where doc_name = 'admn_port.html'; dbms_lob.open(clob_loc, dbms_lob.lob_readwrite); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 7, ' '); dbms_lob.writeappend(clob_loc, 56, '
The Warehouse Builder Administration Portlet allows you '); dbms_lob.writeappend(clob_loc, 71, 'to access the Administration features directly from your Oracle Portal '); dbms_lob.writeappend(clob_loc, 57, 'home page. Select from the following options:
'); dbms_lob.writeappend(clob_loc, 5, 'The following table describes some of the action '); dbms_lob.writeappend(clob_loc, 44, 'links available on this portlet.
'); dbms_lob.writeappend(clob_loc, 19, '| Action '); dbms_lob.writeappend(clob_loc, 29, ' Link | '); dbms_lob.writeappend(clob_loc, 107, 'Description | '); dbms_lob.writeappend(clob_loc, 10, '
| Help | '); dbms_lob.writeappend(clob_loc, 85, 'Displays '); dbms_lob.writeappend(clob_loc, 54, ' the online help for this portlet. | '); dbms_lob.writeappend(clob_loc, 10, '
| About | '); dbms_lob.writeappend(clob_loc, 85, 'Displays '); dbms_lob.writeappend(clob_loc, 69, ' information about the Warehouse Builder Browser. | '); dbms_lob.writeappend(clob_loc, 10, '
| Full '); dbms_lob.writeappend(clob_loc, 25, ' Page | '); dbms_lob.writeappend(clob_loc, 85, 'Displays '); dbms_lob.writeappend(clob_loc, 53, ' the Navigator in full page mode. | '); dbms_lob.writeappend(clob_loc, 10, '
Purging Stale User Information
'); dbms_lob.writeappend(clob_loc, 5, 'Use the Purge Stale User Information action link to remove information '); dbms_lob.writeappend(clob_loc, 76, 'relating to users who have been deleted from the single sign-on repository. '); dbms_lob.writeappend(clob_loc, 69, 'This information remains within the Warehouse Builder Browser system '); dbms_lob.writeappend(clob_loc, 78, 'repository until it is removed using this operation. There is no confirmation '); dbms_lob.writeappend(clob_loc, 91, 'page. The stale information is purged when the Administration page re-displays.
'); dbms_lob.writeappend(clob_loc, 5, 'Registering a Repository
'); dbms_lob.writeappend(clob_loc, 5, 'Fill in the following fields to register a repository:
'); dbms_lob.writeappend(clob_loc, 31, '| Field Name | '); dbms_lob.writeappend(clob_loc, 105, 'Description | '); dbms_lob.writeappend(clob_loc, 8, '
| Name | '); dbms_lob.writeappend(clob_loc, 83, 'The name '); dbms_lob.writeappend(clob_loc, 45, ' the repository will be known as within '); dbms_lob.writeappend(clob_loc, 92, 'the Warehouse Builder Browser system. For example, this name is displayed in the navigation '); dbms_lob.writeappend(clob_loc, 19, 'pages. | '); dbms_lob.writeappend(clob_loc, 8, '
| Host Name | '); dbms_lob.writeappend(clob_loc, 112, 'The name of the computer on which the '); dbms_lob.writeappend(clob_loc, 74, 'repository is stored. This name must be identical to the name used within '); dbms_lob.writeappend(clob_loc, 79, 'the Warehouse Builder client or else it will not be possible to invoke reports '); dbms_lob.writeappend(clob_loc, 49, 'for this repository from the client. | '); dbms_lob.writeappend(clob_loc, 8, '
| Database SID | '); dbms_lob.writeappend(clob_loc, 112, 'The SID of the database in which the '); dbms_lob.writeappend(clob_loc, 74, 'repository is stored. This name must be identical to the name used within '); dbms_lob.writeappend(clob_loc, 79, 'the Warehouse Builder client or else it will not be possible to invoke reports '); dbms_lob.writeappend(clob_loc, 30, 'from that client. | '); dbms_lob.writeappend(clob_loc, 8, '
| OWB Repository Schema | '); dbms_lob.writeappend(clob_loc, 107, 'The name of the schema in which '); dbms_lob.writeappend(clob_loc, 71, 'the repository is stored. This name must be identical to the name used '); dbms_lob.writeappend(clob_loc, 78, 'within the Warehouse Builder client or else it will not be possible to invoke '); dbms_lob.writeappend(clob_loc, 38, 'reports from that client. | '); dbms_lob.writeappend(clob_loc, 8, '
| Database Link | '); dbms_lob.writeappend(clob_loc, 111, 'The name of the database link which '); dbms_lob.writeappend(clob_loc, 73, 'should be used to access the repository. The link must already have been '); dbms_lob.writeappend(clob_loc, 81, 'created, using SQL*Plus for example. This field must be specified and must refer '); dbms_lob.writeappend(clob_loc, 88, 'to a valid link even if the repository is on the same database as the Warehouse Builder '); dbms_lob.writeappend(clob_loc, 34, ' Browser system. | '); dbms_lob.writeappend(clob_loc, 8, '
| Description | '); dbms_lob.writeappend(clob_loc, 117, 'The descriptive text which appears within '); dbms_lob.writeappend(clob_loc, 77, 'the navigation pages for this repository. (4000 character limit) | '); dbms_lob.writeappend(clob_loc, 8, '
Registering Custom Reports
'); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 5, 'Use the Register a Custom Report '); dbms_lob.writeappend(clob_loc, 66, 'page to define a Custom Report. A Custom Report is an application '); dbms_lob.writeappend(clob_loc, 54, 'component created using the Oracle Portal facilities. '); dbms_lob.writeappend(clob_loc, 66, 'Registration of the report provides the Warehouse Builder Browser '); dbms_lob.writeappend(clob_loc, 62, 'system with the information required to invoke the report. In '); dbms_lob.writeappend(clob_loc, 64, 'order for the report to be available, you must assign it to one '); dbms_lob.writeappend(clob_loc, 61, 'or more roles after registration. For more information about '); dbms_lob.writeappend(clob_loc, 66, 'assigning roles, see Granting and Revoking Role Access.
'); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 63, 'Fill in the following fields to '); dbms_lob.writeappend(clob_loc, 37, 'register a Custom Report:
'); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 32, '| Field Name | '); dbms_lob.writeappend(clob_loc, 83, 'Description | '); dbms_lob.writeappend(clob_loc, 10, '
| Display Name | '); dbms_lob.writeappend(clob_loc, 64, 'The name of '); dbms_lob.writeappend(clob_loc, 71, ' the report which is seen in the reports list page. | '); dbms_lob.writeappend(clob_loc, 10, '
| Type Name | '); dbms_lob.writeappend(clob_loc, 64, 'The name of '); dbms_lob.writeappend(clob_loc, 62, ' the data type reported on by this report. | '); dbms_lob.writeappend(clob_loc, 10, '
| Package | '); dbms_lob.writeappend(clob_loc, 66, 'The full name '); dbms_lob.writeappend(clob_loc, 72, ' of the PL/SQL package which implements this report. | '); dbms_lob.writeappend(clob_loc, 10, '
| Repository | '); dbms_lob.writeappend(clob_loc, 64, 'The name of '); dbms_lob.writeappend(clob_loc, 78, ' the repository containing target objects for this report. | '); dbms_lob.writeappend(clob_loc, 10, '
'); dbms_lob.writeappend(clob_loc, 8, ' '); dbms_lob.writeappend(clob_loc, 8, ' '); dbms_lob.close(clob_loc); --text document 'us/fav_cst.html' insert into wmp_text_docs (doc_name, doc_value,language) values ('fav_cst.html', empty_clob() ,'us'); select doc_value into clob_loc from wmp_text_docs where doc_name = 'fav_cst.html'; dbms_lob.open(clob_loc, dbms_lob.lob_readwrite); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 7, ' '); dbms_lob.writeappend(clob_loc, 37, '
Customizing Favorites
'); dbms_lob.writeappend(clob_loc, 5, 'Use the Customize Warehouse Builder Favorites '); dbms_lob.writeappend(clob_loc, 62, 'page to change the way your Favorites appear on the Favorites '); dbms_lob.writeappend(clob_loc, 17, 'Page.
'); dbms_lob.writeappend(clob_loc, 57, 'Select Favorites
'); dbms_lob.writeappend(clob_loc, 79, 'Use the drop down lists to select a Repository, Role, or '); dbms_lob.writeappend(clob_loc, 79, 'Type of Favorite that you want to have displayed on your Favorites pages. This '); dbms_lob.writeappend(clob_loc, 81, 'is a filter for the type of items that display in your Favorites. This is useful '); dbms_lob.writeappend(clob_loc, 85, 'if you do not want to set the filter each time you open a Favorites page.
'); dbms_lob.writeappend(clob_loc, 55, 'Edit Favorites
'); dbms_lob.writeappend(clob_loc, 78, 'Use the Edit Favorites link to edit the descriptions of '); dbms_lob.writeappend(clob_loc, 58, 'your Favorites, and to delete Favorites.
'); dbms_lob.writeappend(clob_loc, 57, 'Display Settings
'); dbms_lob.writeappend(clob_loc, 79, 'Use the display settings options to specify how you want '); dbms_lob.writeappend(clob_loc, 38, 'the page to display.
'); dbms_lob.writeappend(clob_loc, 31, '| Type | '); dbms_lob.writeappend(clob_loc, 74, 'Option | '); dbms_lob.writeappend(clob_loc, 79, 'Description | '); dbms_lob.writeappend(clob_loc, 8, '
| Display | '); dbms_lob.writeappend(clob_loc, 69, 'Show All | '); dbms_lob.writeappend(clob_loc, 52, 'The '); dbms_lob.writeappend(clob_loc, 76, 'Navigation List and the Reports List will contain all entries that you have '); dbms_lob.writeappend(clob_loc, 19, 'added. | '); dbms_lob.writeappend(clob_loc, 8, '
| Limit List To n Favorites | '); dbms_lob.writeappend(clob_loc, 52, 'You '); dbms_lob.writeappend(clob_loc, 78, 'can choose the maximum number of rows you wish to see in the tables. If there '); dbms_lob.writeappend(clob_loc, 78, 'are more items than can be shown, you will see Next and Previous buttons that '); dbms_lob.writeappend(clob_loc, 52, 'you can use to see the remaining items. | '); dbms_lob.writeappend(clob_loc, 8, '|
| Show Description | '); dbms_lob.writeappend(clob_loc, 67, 'Yes/No | '); dbms_lob.writeappend(clob_loc, 52, 'You '); dbms_lob.writeappend(clob_loc, 66, 'can stop the description column from being displayed. | '); dbms_lob.writeappend(clob_loc, 8, '
| Show Path | '); dbms_lob.writeappend(clob_loc, 67, 'Yes/No | '); dbms_lob.writeappend(clob_loc, 52, 'You '); dbms_lob.writeappend(clob_loc, 78, 'can stop the path column from being displayed. The path can be quite long and '); dbms_lob.writeappend(clob_loc, 36, 'can clutter the screen. | '); dbms_lob.writeappend(clob_loc, 8, '
Editing Favorites
'); dbms_lob.writeappend(clob_loc, 5, 'To edit your favorites page, select one of the '); dbms_lob.writeappend(clob_loc, 35, 'following action links:
'); dbms_lob.writeappend(clob_loc, 32, '| Action Link | '); dbms_lob.writeappend(clob_loc, 79, 'Description | '); dbms_lob.writeappend(clob_loc, 8, '
| Edit | '); dbms_lob.writeappend(clob_loc, 87, 'The edit action link allows you '); dbms_lob.writeappend(clob_loc, 74, 'to change the description for this Favorite. The description appears as a '); dbms_lob.writeappend(clob_loc, 42, 'column in the Favorites list. | '); dbms_lob.writeappend(clob_loc, 8, '
| Delete From Favorites | '); dbms_lob.writeappend(clob_loc, 88, 'The delete from favorites action '); dbms_lob.writeappend(clob_loc, 11, ' link '); dbms_lob.writeappend(clob_loc, 78, 'removes this entry from the Favorites table. It does not remove the item from '); dbms_lob.writeappend(clob_loc, 46, 'the Warehouse Builder Repository. | '); dbms_lob.writeappend(clob_loc, 8, '
Warehouse Builder Favorites
'); dbms_lob.writeappend(clob_loc, 5, 'The Navigation pages consist of the following parts: '); dbms_lob.writeappend(clob_loc, 5, '
| The Title | '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 80, 'The title '); dbms_lob.writeappend(clob_loc, 53, ' describes the type of page displayed. For example, '); dbms_lob.writeappend(clob_loc, 80, 'in this case you are looking at a Warehouse Builder Favorites page. | '); dbms_lob.writeappend(clob_loc, 6, '
| The Home Link | '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 129, 'This link takes you to your default home page. | '); dbms_lob.writeappend(clob_loc, 6, '
| The Date | '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 138, 'The date shows you when the page was displayed. This is only useful '); dbms_lob.writeappend(clob_loc, 76, 'if you print the page, otherwise it is always the current date. | '); dbms_lob.writeappend(clob_loc, 6, '
| Customize | '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 138, 'Select this link to go to the Customize Warehouse Builder Favorites ');
dbms_lob.writeappend(clob_loc, 44, 'Pages page and customize your page display. ');
dbms_lob.writeappend(clob_loc, 76, ' For details about customizing your page, see Customizing Your Favorites '); dbms_lob.writeappend(clob_loc, 18, 'Page. | ');
dbms_lob.writeappend(clob_loc, 6, '
| Logout | '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 128, 'Select this link to log out of Oracle Portal. | '); dbms_lob.writeappend(clob_loc, 6, '
| Type | '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 148, 'The Type of the item together with an icon representing the type. | '); dbms_lob.writeappend(clob_loc, 6, '
| Name | '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 137, 'The name of the Item. Selecting the name will take you straight to '); dbms_lob.writeappend(clob_loc, 54, 'the Navigation content page of that item. | '); dbms_lob.writeappend(clob_loc, 6, '
| Path | '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 142, 'The Path shows the fully qualified name of the item (as it would appear '); dbms_lob.writeappend(clob_loc, 80, 'in the Path field on the Navigator page). If you find the Page is to cluttered, '); dbms_lob.writeappend(clob_loc, 88, 'then this column can be removed using the Favorites Customize Options Page. | '); dbms_lob.writeappend(clob_loc, 6, '
| Actions | '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 139, 'These Actions allow you to jump to the specific tab in the Navigator '); dbms_lob.writeappend(clob_loc, 27, 'for that item. | '); dbms_lob.writeappend(clob_loc, 6, '
| Description | '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 140, 'You can create a description to a favorite in the Favorites Customize '); dbms_lob.writeappend(clob_loc, 36, 'Page. It displays here. | '); dbms_lob.writeappend(clob_loc, 6, '
'); dbms_lob.writeappend(clob_loc, 29, ' '); dbms_lob.writeappend(clob_loc, 41, 'The table contains these columns: '); dbms_lob.writeappend(clob_loc, 5, '
'); dbms_lob.writeappend(clob_loc, 32, '| Type | '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 122, 'The Type of the item together with an icon representing the type. | '); dbms_lob.writeappend(clob_loc, 6, '
| Name | '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 111, 'The name of the Item. Selecting the name will take you straight to '); dbms_lob.writeappend(clob_loc, 54, 'the Navigation content page of that item. | '); dbms_lob.writeappend(clob_loc, 6, '
| Report | '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 113, 'The name of the Report. Selecting the report name takes you straight '); dbms_lob.writeappend(clob_loc, 27, 'to the report. | '); dbms_lob.writeappend(clob_loc, 6, '
| Path | '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 116, 'The Path shows the fully qualified name of the item (as it would appear '); dbms_lob.writeappend(clob_loc, 80, 'in the Path field on the Navigator page). If you find the Page is to cluttered, '); dbms_lob.writeappend(clob_loc, 78, 'then this column can be removed using the Favorites Options Page. | '); dbms_lob.writeappend(clob_loc, 6, '
| Description | '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 114, 'You can create a description to a favorite in the Favorites Customize '); dbms_lob.writeappend(clob_loc, 36, 'Page. It displays here. | '); dbms_lob.writeappend(clob_loc, 6, '
'); dbms_lob.writeappend(clob_loc, 10, '
Warehouse Builder Favorites Portlet
'); dbms_lob.writeappend(clob_loc, 5, 'Use the Warehouse Builder Favorites Portlet to '); dbms_lob.writeappend(clob_loc, 108, 'access your favorite Navigator pages and Reports directly from your Oracle Portal home page. When you '); dbms_lob.writeappend(clob_loc, 81, 'install this portlet, it does not contain any default favorites. You must select '); dbms_lob.writeappend(clob_loc, 78, 'Navigator pages and Reports as favorites using the Add to My Favorites '); dbms_lob.writeappend(clob_loc, 82, 'links on the Warehouse Builder Navigator. You can also click the Full Page '); dbms_lob.writeappend(clob_loc, 56, 'link to display Favorites in full page mode.
'); dbms_lob.writeappend(clob_loc, 5, 'The following table describes some of the action '); dbms_lob.writeappend(clob_loc, 44, 'links available on this portlet.
'); dbms_lob.writeappend(clob_loc, 19, '| Action '); dbms_lob.writeappend(clob_loc, 29, ' Link | '); dbms_lob.writeappend(clob_loc, 107, 'Description | '); dbms_lob.writeappend(clob_loc, 10, '
| Customize | '); dbms_lob.writeappend(clob_loc, 83, 'Allows '); dbms_lob.writeappend(clob_loc, 59, ' you to customize your display options. | '); dbms_lob.writeappend(clob_loc, 10, '
| Help | '); dbms_lob.writeappend(clob_loc, 85, 'Displays '); dbms_lob.writeappend(clob_loc, 54, ' the online help for this portlet. | '); dbms_lob.writeappend(clob_loc, 10, '
| About | '); dbms_lob.writeappend(clob_loc, 85, 'Displays '); dbms_lob.writeappend(clob_loc, 69, ' information about the Warehouse Builder Browser. | '); dbms_lob.writeappend(clob_loc, 10, '
| Full '); dbms_lob.writeappend(clob_loc, 25, ' Page | '); dbms_lob.writeappend(clob_loc, 85, 'Displays '); dbms_lob.writeappend(clob_loc, 53, ' the Navigator in full page mode. | '); dbms_lob.writeappend(clob_loc, 10, '
Use the Warehouse Builder Launcher Portlet to:
'); dbms_lob.writeappend(clob_loc, 5, 'Adding Links to the Navigator
'); dbms_lob.writeappend(clob_loc, 5, 'Use the Add Link page to add links to other portals, files, or external '); dbms_lob.writeappend(clob_loc, 24, 'URLs. If you are adding '); dbms_lob.writeappend(clob_loc, 79, 'files, you must first make sure that the file exists in a portal content area. '); dbms_lob.writeappend(clob_loc, 71, 'For more information, see the Oracle Portal documentation.
'); dbms_lob.writeappend(clob_loc, 92, 'To add a link, provide the following information:
'); dbms_lob.writeappend(clob_loc, 31, '| Field | '); dbms_lob.writeappend(clob_loc, 79, 'Description | '); dbms_lob.writeappend(clob_loc, 8, '
| Display Name | '); dbms_lob.writeappend(clob_loc, 88, 'Create a name for the link. | '); dbms_lob.writeappend(clob_loc, 8, '
| URL | '); dbms_lob.writeappend(clob_loc, 86, ' For an external website, provide the ');
dbms_lob.writeappend(clob_loc, 27, 'complete URL. ');
dbms_lob.writeappend(clob_loc, 98, ' For files that are in a Oracle Portal content area, use the '); dbms_lob.writeappend(clob_loc, 75, 'right-click Copy Shortcut to copy the location of the file. Then use Paste '); dbms_lob.writeappend(clob_loc, 64, 'into this field to define the location of the file. | ');
dbms_lob.writeappend(clob_loc, 8, '
| Description | '); dbms_lob.writeappend(clob_loc, 76, 'Create a short description '); dbms_lob.writeappend(clob_loc, 26, 'of this link. | '); dbms_lob.writeappend(clob_loc, 8, '
Navigator Contents Tab
'); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 5, 'The Contents tab lists items ');
dbms_lob.writeappend(clob_loc, 64, 'contained in the current item. For example, if the current item ');
dbms_lob.writeappend(clob_loc, 64, 'was a table, then the Contents tab would list its columns, keys ');
dbms_lob.writeappend(clob_loc, 65, 'and foreign keys. Use this tab to drill down into the Repository ');
dbms_lob.writeappend(clob_loc, 66, 'using contents on an item in the list. The following table ');
dbms_lob.writeappend(clob_loc, 47, 'describes the Contents tab column values.
');
dbms_lob.writeappend(clob_loc, 18, '
| Column '); dbms_lob.writeappend(clob_loc, 29, ' Name | '); dbms_lob.writeappend(clob_loc, 96, 'Description | '); dbms_lob.writeappend(clob_loc, 10, '
| Physical '); dbms_lob.writeappend(clob_loc, 25, ' Name | '); dbms_lob.writeappend(clob_loc, 69, 'The '); dbms_lob.writeappend(clob_loc, 47, ' physical name of the item. | '); dbms_lob.writeappend(clob_loc, 10, '
| Type | '); dbms_lob.writeappend(clob_loc, 68, 'An '); dbms_lob.writeappend(clob_loc, 63, ' icon showing a graphical representation of the of item '); dbms_lob.writeappend(clob_loc, 49, ' type and the item type name. | '); dbms_lob.writeappend(clob_loc, 10, '
| Actions | '); dbms_lob.writeappend(clob_loc, 71, 'There ');
dbms_lob.writeappend(clob_loc, 59, ' are two types of actions: generic actions and item ');
dbms_lob.writeappend(clob_loc, 66, ' specific actions. Generic actions are available for every ');
dbms_lob.writeappend(clob_loc, 63, ' item and are intended to help navigate the repository. ');
dbms_lob.writeappend(clob_loc, 64, ' Item specific actions are only available for particular ');
dbms_lob.writeappend(clob_loc, 64, ' items or item types and either perform tasks or link to ');
dbms_lob.writeappend(clob_loc, 72, ' external data. Generic '); dbms_lob.writeappend(clob_loc, 32, ' Actions: '); dbms_lob.writeappend(clob_loc, 13, '
Note: You can also '); dbms_lob.writeappend(clob_loc, 65, ' use contents to select a new item and then switch '); dbms_lob.writeappend(clob_loc, 67, ' tabs when the screen has refreshed. The properties, '); dbms_lob.writeappend(clob_loc, 63, ' related, reports and links action '); dbms_lob.writeappend(clob_loc, 40, ' links are shortcuts. '); dbms_lob.writeappend(clob_loc, 80, 'Item Specific Actions: '); dbms_lob.writeappend(clob_loc, 13, '
| ');
dbms_lob.writeappend(clob_loc, 10, '
The other tabs in the Navigator allow you to navigate and view the properties, related items, reports, and '); dbms_lob.writeappend(clob_loc, 61, 'links that are applicable to the current object.
'); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 5, 'Use the Customize Display Options page to set up '); dbms_lob.writeappend(clob_loc, 78, 'the Navigator. There are two sets of options for you to set.
'); dbms_lob.writeappend(clob_loc, 64, 'Role Selection
'); dbms_lob.writeappend(clob_loc, 72, 'Select the role you want to use with the '); dbms_lob.writeappend(clob_loc, 67, 'Navigator. These roles are defined in the following table. Use the '); dbms_lob.writeappend(clob_loc, 97, 'Administration pages to assign access to roles. The default is Warehouse User.
'); dbms_lob.writeappend(clob_loc, 31, '| Role | '); dbms_lob.writeappend(clob_loc, 79, 'Description | '); dbms_lob.writeappend(clob_loc, 8, '
| Warehouse Developer | '); dbms_lob.writeappend(clob_loc, 81, 'User that uses Warehouse Builder '); dbms_lob.writeappend(clob_loc, 43, ' to create the warehouse. | '); dbms_lob.writeappend(clob_loc, 8, '
| QA User | '); dbms_lob.writeappend(clob_loc, 79, 'User that tests the quality of '); dbms_lob.writeappend(clob_loc, 55, ' the warehouse before it is deployed. | '); dbms_lob.writeappend(clob_loc, 8, '
| Warehouse User | '); dbms_lob.writeappend(clob_loc, 76, 'User that uses the deployed '); dbms_lob.writeappend(clob_loc, 67, ' Warehouse to understand the underlying metadata. | '); dbms_lob.writeappend(clob_loc, 8, '
'); dbms_lob.writeappend(clob_loc, 15, ''); dbms_lob.writeappend(clob_loc, 67, ''); dbms_lob.writeappend(clob_loc, 17, ''); dbms_lob.writeappend(clob_loc, 14, ''); dbms_lob.writeappend(clob_loc, 19, ''); dbms_lob.writeappend(clob_loc, 16, ''); dbms_lob.writeappend(clob_loc, 21, ''); dbms_lob.writeappend(clob_loc, 18, ''); dbms_lob.writeappend(clob_loc, 22, ''); dbms_lob.writeappend(clob_loc, 20, '
Display Selection
'); dbms_lob.writeappend(clob_loc, 80, 'Specify how many items you want displayed within '); dbms_lob.writeappend(clob_loc, 56, 'the portlet. The default is Show All.
'); dbms_lob.writeappend(clob_loc, 5, 'Customizing Links in the Navigator
'); dbms_lob.writeappend(clob_loc, 5, 'Use the Customize Warehouse Builder Links page to '); dbms_lob.writeappend(clob_loc, 53, 'edit to the links you have set up.
'); dbms_lob.writeappend(clob_loc, 31, '| Action Link | '); dbms_lob.writeappend(clob_loc, 79, 'Description | '); dbms_lob.writeappend(clob_loc, 12, ' '); dbms_lob.writeappend(clob_loc, 8, '
| Edit | '); dbms_lob.writeappend(clob_loc, 76, 'The edit action link '); dbms_lob.writeappend(clob_loc, 81, ' allows you to make changes to this information about the link. | '); dbms_lob.writeappend(clob_loc, 12, ' '); dbms_lob.writeappend(clob_loc, 8, '
| Delete | '); dbms_lob.writeappend(clob_loc, 78, 'The delete action link '); dbms_lob.writeappend(clob_loc, 68, ' removes this link from the Existing Links table. | '); dbms_lob.writeappend(clob_loc, 12, ' '); dbms_lob.writeappend(clob_loc, 8, '
NOTE: Links cannot be added to the root of '); dbms_lob.writeappend(clob_loc, 85, 'the Navigator. The root of the Navigator list all available repositories.
'); dbms_lob.writeappend(clob_loc, 5, 'Lineage and Impact Analysis '); dbms_lob.writeappend(clob_loc, 19, 'Reports
'); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 5, '
');
dbms_lob.writeappend(clob_loc, 80, 'Overview
');
dbms_lob.writeappend(clob_loc, 70, 'Repeated ');
dbms_lob.writeappend(clob_loc, 52, 'Objects
');
dbms_lob.writeappend(clob_loc, 69, 'Display ');
dbms_lob.writeappend(clob_loc, 52, 'Options
');
dbms_lob.writeappend(clob_loc, 84, 'Navigation
This report allows the Lineage or '); dbms_lob.writeappend(clob_loc, 70, 'Impact Analysis of an object to be displayed graphically.
'); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 59, 'The Lineage of an object is ');
dbms_lob.writeappend(clob_loc, 61, 'defined by the various transformation steps that are applied ');
dbms_lob.writeappend(clob_loc, 64, 'before it is given a value. The Impact Analysis of an object is ');
dbms_lob.writeappend(clob_loc, 59, 'defined by the various transformation steps its value goes ');
dbms_lob.writeappend(clob_loc, 58, 'through as the data is transformed and used by subsequent ');
dbms_lob.writeappend(clob_loc, 14, 'objects.
');
dbms_lob.writeappend(clob_loc, 19, '
An object may sometimes appear ');
dbms_lob.writeappend(clob_loc, 66, 'twice on a diagram. Where this happens, the Lineage/ Impact ');
dbms_lob.writeappend(clob_loc, 63, 'Analysis is displayed for the first occurrence only. All ');
dbms_lob.writeappend(clob_loc, 66, 'subsequent occurrences of the object have their names prefixed by ');
dbms_lob.writeappend(clob_loc, 63, 'an asterix (*) to indicate that they are expanded elsewhere on ');
dbms_lob.writeappend(clob_loc, 18, 'the diagram.
');
dbms_lob.writeappend(clob_loc, 19, '
The diagram has two display ');
dbms_lob.writeappend(clob_loc, 66, 'options - zoom and depth. The values that you set for these ');
dbms_lob.writeappend(clob_loc, 63, 'options are maintained for your login session, and so the next ');
dbms_lob.writeappend(clob_loc, 58, 'diagram that you generate will use the same settings.
');
dbms_lob.writeappend(clob_loc, 19, '
| Zoom | '); dbms_lob.writeappend(clob_loc, 66, 'Select a zoom '); dbms_lob.writeappend(clob_loc, 65, ' value from the Zoom drop down list to redraw the diagram '); dbms_lob.writeappend(clob_loc, 55, ' using the chosen scale percentage. | '); dbms_lob.writeappend(clob_loc, 10, '
| '); dbms_lob.writeappend(clob_loc, 36, ' | '); dbms_lob.writeappend(clob_loc, 10, ' |
| Depth | '); dbms_lob.writeappend(clob_loc, 61, 'Select a '); dbms_lob.writeappend(clob_loc, 61, ' depth value from the Depth drop down to restrict the '); dbms_lob.writeappend(clob_loc, 66, ' number of levels that are displayed in the diagram. '); dbms_lob.writeappend(clob_loc, 65, ' This is particularly useful if you have a large diagram, '); dbms_lob.writeappend(clob_loc, 64, ' but are only concerned with the first few levels. '); dbms_lob.writeappend(clob_loc, 64, ' When the diagram is redrawn, any levels below the '); dbms_lob.writeappend(clob_loc, 65, ' chosen depth are hidden. Objects that have further '); dbms_lob.writeappend(clob_loc, 64, ' hidden dependents have ellipsis (...) following them to '); dbms_lob.writeappend(clob_loc, 63, ' indicate that they have dependents. A warning is '); dbms_lob.writeappend(clob_loc, 65, ' also given that the diagram is not complete. | '); dbms_lob.writeappend(clob_loc, 10, '
Actions may be performed by ');
dbms_lob.writeappend(clob_loc, 42, 'clicking on an object image or name.
');
dbms_lob.writeappend(clob_loc, 19, '
| Navigator '); dbms_lob.writeappend(clob_loc, 29, ' Page | '); dbms_lob.writeappend(clob_loc, 61, 'Click an '); dbms_lob.writeappend(clob_loc, 48, ' object''s name to display it''s Navigator page | '); dbms_lob.writeappend(clob_loc, 10, '
| '); dbms_lob.writeappend(clob_loc, 36, ' | '); dbms_lob.writeappend(clob_loc, 10, ' |
| Refocus '); dbms_lob.writeappend(clob_loc, 32, ' Diagram | '); dbms_lob.writeappend(clob_loc, 61, 'Click an '); dbms_lob.writeappend(clob_loc, 66, ' object''s image to redraw the diagram to show the Lineage/ '); dbms_lob.writeappend(clob_loc, 61, ' Impact Analysis for the selected object. | '); dbms_lob.writeappend(clob_loc, 10, '
');
dbms_lob.writeappend(clob_loc, 5, '
');
dbms_lob.writeappend(clob_loc, 5, '
');
dbms_lob.writeappend(clob_loc, 5, '
');
dbms_lob.writeappend(clob_loc, 12, '
Navigator Links Tab
'); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 5, 'The Links tab displays the ');
dbms_lob.writeappend(clob_loc, 66, 'external links available for the current item and user.
');
dbms_lob.writeappend(clob_loc, 12, '
| Column '); dbms_lob.writeappend(clob_loc, 29, ' Name | '); dbms_lob.writeappend(clob_loc, 83, 'Description | '); dbms_lob.writeappend(clob_loc, 10, '
| Name | '); dbms_lob.writeappend(clob_loc, 64, 'The name of '); dbms_lob.writeappend(clob_loc, 30, ' the Link. | '); dbms_lob.writeappend(clob_loc, 10, '
| Actions | '); dbms_lob.writeappend(clob_loc, 65, 'Click on the '); dbms_lob.writeappend(clob_loc, 58, ' view action link to display the link. | '); dbms_lob.writeappend(clob_loc, 10, '
The other tabs in the Navigator allow you to navigate and view the properties, contents, and related item details that are applicable to the current object. '); dbms_lob.writeappend(clob_loc, 5, '
'); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 5, '
');
dbms_lob.writeappend(clob_loc, 5, '
Warehouse Builder Browser Navigator
'); dbms_lob.writeappend(clob_loc, 5, 'The Navigator page is divided into the following '); dbms_lob.writeappend(clob_loc, 32, 'parts from the top down: '); dbms_lob.writeappend(clob_loc, 5, '
'); dbms_lob.writeappend(clob_loc, 19, ' '); dbms_lob.writeappend(clob_loc, 22, ' '); dbms_lob.writeappend(clob_loc, 57, 'Header
'); dbms_lob.writeappend(clob_loc, 29, ' '); dbms_lob.writeappend(clob_loc, 69, 'The header defines the type of page you are looking at and has links '); dbms_lob.writeappend(clob_loc, 29, 'to other pages. '); dbms_lob.writeappend(clob_loc, 4, ''); dbms_lob.writeappend(clob_loc, 29, ' '); dbms_lob.writeappend(clob_loc, 42, 'The header contains the following: '); dbms_lob.writeappend(clob_loc, 5, '
'); dbms_lob.writeappend(clob_loc, 32, '| Page Title | '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 118, 'The title lets you know the type of page you are looking at. For example, '); dbms_lob.writeappend(clob_loc, 75, 'in this case you are looking at a Warehouse Builder Navigation page. There '); dbms_lob.writeappend(clob_loc, 75, 'are also Warehouse Builder Administration and Favorites pages. | '); dbms_lob.writeappend(clob_loc, 6, '
| The Home Link | '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 103, 'This link takes you to your default home page. | '); dbms_lob.writeappend(clob_loc, 6, '
| The Date | '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 113, 'The date shows you when the page is displayed. This is typically the '); dbms_lob.writeappend(clob_loc, 71, 'current date. If you print a report, this can be helpful to keep track '); dbms_lob.writeappend(clob_loc, 40, 'of when the report was run. | '); dbms_lob.writeappend(clob_loc, 6, '
| Add To My Favorites | '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 114, 'Select this link to add the current Navigation page to your Favorites '); dbms_lob.writeappend(clob_loc, 19, 'pages. | '); dbms_lob.writeappend(clob_loc, 6, '
| Browse My Favorites | '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 115, 'Select this link to view the page containing your favorite Navigations '); dbms_lob.writeappend(clob_loc, 25, 'and Reports. | '); dbms_lob.writeappend(clob_loc, 6, '
| Customize | '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 84, 'Select this link to go to the Customize '); dbms_lob.writeappend(clob_loc, 68, ' Display Options page and customize your page display. | '); dbms_lob.writeappend(clob_loc, 6, '
| Logout | '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 102, 'Select this link to log out of Oracle Portal. | '); dbms_lob.writeappend(clob_loc, 6, '
'); dbms_lob.writeappend(clob_loc, 19, ' '); dbms_lob.writeappend(clob_loc, 24, ' '); dbms_lob.writeappend(clob_loc, 66, 'Item Definition
'); dbms_lob.writeappend(clob_loc, 29, ' '); dbms_lob.writeappend(clob_loc, 71, 'The Item Definition gives you the information you need to identify the '); dbms_lob.writeappend(clob_loc, 26, 'item and its type. '); dbms_lob.writeappend(clob_loc, 4, ''); dbms_lob.writeappend(clob_loc, 29, ' '); dbms_lob.writeappend(clob_loc, 51, 'The item definition contains the following: '); dbms_lob.writeappend(clob_loc, 5, '
'); dbms_lob.writeappend(clob_loc, 32, '| The Item Name | '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 111, 'The name of the item that you have navigated to. | '); dbms_lob.writeappend(clob_loc, 6, '
| The Path | '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 114, 'The Path shows you the context of the item. It lists the items in the '); dbms_lob.writeappend(clob_loc, 110, 'hierarchy and also shows the type of each item. For example, Path: * Warehouse Builder: Repository> '); dbms_lob.writeappend(clob_loc, 149, ' My Project: Project, would be the path for the project named My Project as the current item. You can click on any of the items in the path to make '); dbms_lob.writeappend(clob_loc, 35, 'that the current item. | '); dbms_lob.writeappend(clob_loc, 6, '
| The Role | '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 101, 'The role that you are logged in as is shown. | '); dbms_lob.writeappend(clob_loc, 6, '
| Help | '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 123, 'The Help link will take you to online help for the Navigation Page | '); dbms_lob.writeappend(clob_loc, 6, '
'); dbms_lob.writeappend(clob_loc, 19, ' '); dbms_lob.writeappend(clob_loc, 28, ' '); dbms_lob.writeappend(clob_loc, 63, 'Item Details
'); dbms_lob.writeappend(clob_loc, 29, ' '); dbms_lob.writeappend(clob_loc, 68, 'The Item Details section consists of a Tabbed Table. The Table will '); dbms_lob.writeappend(clob_loc, 79, 'show different information depending on which tab is currently selected. The ? '); dbms_lob.writeappend(clob_loc, 79, 'in the header of the tabbed table takes you to specific help for the currently '); dbms_lob.writeappend(clob_loc, 21, 'selected tab. '); dbms_lob.writeappend(clob_loc, 4, ''); dbms_lob.writeappend(clob_loc, 29, ' '); dbms_lob.writeappend(clob_loc, 53, 'The item details contains the following tabs: '); dbms_lob.writeappend(clob_loc, 5, '
'); dbms_lob.writeappend(clob_loc, 32, '| Properties | '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 114, 'The Properties tab displays property name-value pairs of the selected '); dbms_lob.writeappend(clob_loc, 72, 'Item. The property names will be different depending on the type of the '); dbms_lob.writeappend(clob_loc, 26, 'current item. | '); dbms_lob.writeappend(clob_loc, 6, '
| Contents | '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 115, 'The Contents Tab lists the Items that are contained within the current '); dbms_lob.writeappend(clob_loc, 74, 'item. For example, if the current item was a table, then the Contents Tab '); dbms_lob.writeappend(clob_loc, 72, 'would list its columns, keys and foreign keys. This is the tab that you '); dbms_lob.writeappend(clob_loc, 91, 'use when you are drilling down into the Warehouse Builder Repository by using the Contents '); dbms_lob.writeappend(clob_loc, 43, 'Action on an item in the list. | '); dbms_lob.writeappend(clob_loc, 6, '
| Related | '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 112, 'The Related Tab allows you to view relationships between items. For '); dbms_lob.writeappend(clob_loc, 73, 'example, if the current item is a table, then you can use it to identify '); dbms_lob.writeappend(clob_loc, 72, 'which tables it is related to with foreign keys. Like the Contents Tab, '); dbms_lob.writeappend(clob_loc, 74, 'you can use this Tab to drill down into items in the repository. When you '); dbms_lob.writeappend(clob_loc, 76, 'make one of these items the current item, the path will switch to represent '); dbms_lob.writeappend(clob_loc, 39, 'the path of this new item. | '); dbms_lob.writeappend(clob_loc, 6, '
| Reports | '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 114, 'The Reports Tab shows you the available reports for the current item. '); dbms_lob.writeappend(clob_loc, 73, 'Each role has its own set of reports available for each item type, so if '); dbms_lob.writeappend(clob_loc, 71, 'you are a Warehouse User, you will see a different set of reports from '); dbms_lob.writeappend(clob_loc, 34, 'a Warehouse Engineer. | '); dbms_lob.writeappend(clob_loc, 6, '
| Links | '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 78, 'The Links Tab shows you a list of '); dbms_lob.writeappend(clob_loc, 77, ' available external items related to the current object. These items do not '); dbms_lob.writeappend(clob_loc, 73, ' exist in the Warehouse Builder Repository. They are hypertext links to '); dbms_lob.writeappend(clob_loc, 71, ' information stored within a Oracle Portal content area. | '); dbms_lob.writeappend(clob_loc, 6, '
'); dbms_lob.writeappend(clob_loc, 7, ' '); dbms_lob.close(clob_loc); --text document 'us/nav_port.html' insert into wmp_text_docs (doc_name, doc_value,language) values ('nav_port.html', empty_clob() ,'us'); select doc_value into clob_loc from wmp_text_docs where doc_name = 'nav_port.html'; dbms_lob.open(clob_loc, dbms_lob.lob_readwrite); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 7, '
'); dbms_lob.writeappend(clob_loc, 51, 'Warehouse Builder Navigator Portlet '); dbms_lob.writeappend(clob_loc, 5, '
'); dbms_lob.writeappend(clob_loc, 5, 'Use the Warehouse Builder Navigator Portlet to browse the repositories accessible to the current '); dbms_lob.writeappend(clob_loc, 81, 'user within the area assigned to the portlet. The Navigator Portlet has the same '); dbms_lob.writeappend(clob_loc, 95, 'functionality as the Navigator, except it continues to display within the area of the portlet. '); dbms_lob.writeappend(clob_loc, 84, 'You can click the Full Page link to display the Navigator.
'); dbms_lob.writeappend(clob_loc, 80, 'The following table describes some of the action '); dbms_lob.writeappend(clob_loc, 81, 'links available on this portlet. Select the question mark on each tab to display '); dbms_lob.writeappend(clob_loc, 69, 'specific information about each Navigator tab area.
'); dbms_lob.writeappend(clob_loc, 19, '| Action '); dbms_lob.writeappend(clob_loc, 29, ' Link | '); dbms_lob.writeappend(clob_loc, 107, 'Description | '); dbms_lob.writeappend(clob_loc, 10, '
| Customize | '); dbms_lob.writeappend(clob_loc, 83, 'Allows '); dbms_lob.writeappend(clob_loc, 59, ' you to customize your display options. | '); dbms_lob.writeappend(clob_loc, 10, '
| Help | '); dbms_lob.writeappend(clob_loc, 85, 'Displays '); dbms_lob.writeappend(clob_loc, 54, ' the online help for this portlet. | '); dbms_lob.writeappend(clob_loc, 10, '
| About | '); dbms_lob.writeappend(clob_loc, 85, 'Displays '); dbms_lob.writeappend(clob_loc, 69, ' information about the Warehouse Builder Browser. | '); dbms_lob.writeappend(clob_loc, 10, '
| Add '); dbms_lob.writeappend(clob_loc, 36, ' to My Favorites | '); dbms_lob.writeappend(clob_loc, 81, 'Adds '); dbms_lob.writeappend(clob_loc, 70, ' the current Navigator page to the Favorites page. | '); dbms_lob.writeappend(clob_loc, 10, '
| Full '); dbms_lob.writeappend(clob_loc, 25, ' Page | '); dbms_lob.writeappend(clob_loc, 85, 'Displays '); dbms_lob.writeappend(clob_loc, 53, ' the Navigator in full page mode. | '); dbms_lob.writeappend(clob_loc, 10, '
Use the Customize Display Options page to set up '); dbms_lob.writeappend(clob_loc, 86, 'the Navigator portlet. There are two sets of options for you to set.
'); dbms_lob.writeappend(clob_loc, 64, 'Role Selection
'); dbms_lob.writeappend(clob_loc, 53, 'Select the role '); dbms_lob.writeappend(clob_loc, 77, 'you want to use with the Navigator. These roles are defined in the following '); dbms_lob.writeappend(clob_loc, 91, 'table. Use the Administration pages to assign access to roles. The default is Warehouse '); dbms_lob.writeappend(clob_loc, 28, 'User.
'); dbms_lob.writeappend(clob_loc, 31, '| Role | '); dbms_lob.writeappend(clob_loc, 79, 'Description | '); dbms_lob.writeappend(clob_loc, 8, '
| Warehouse Developer | '); dbms_lob.writeappend(clob_loc, 81, 'User that uses Warehouse Builder '); dbms_lob.writeappend(clob_loc, 43, ' to create the warehouse. | '); dbms_lob.writeappend(clob_loc, 8, '
| QA User | '); dbms_lob.writeappend(clob_loc, 79, 'User that tests the quality of '); dbms_lob.writeappend(clob_loc, 55, ' the warehouse before it is deployed. | '); dbms_lob.writeappend(clob_loc, 8, '
| Warehouse User | '); dbms_lob.writeappend(clob_loc, 76, 'User that uses the deployed '); dbms_lob.writeappend(clob_loc, 67, ' Warehouse to understand the underlying metadata. | '); dbms_lob.writeappend(clob_loc, 8, '
Display Selection
'); dbms_lob.writeappend(clob_loc, 80, 'Specify how many items you want displayed within '); dbms_lob.writeappend(clob_loc, 56, 'the portlet. The default is Show All.
'); dbms_lob.writeappend(clob_loc, 5, ''); dbms_lob.close(clob_loc); --text document 'us/nav_prpts.html' insert into wmp_text_docs (doc_name, doc_value,language) values ('nav_prpts.html', empty_clob() ,'us'); select doc_value into clob_loc from wmp_text_docs where doc_name = 'nav_prpts.html'; dbms_lob.open(clob_loc, dbms_lob.lob_readwrite); dbms_lob.writeappend(clob_loc, 63, ' '); dbms_lob.writeappend(clob_loc, 7, ' '); dbms_lob.writeappend(clob_loc, 7, ' '); dbms_lob.writeappend(clob_loc, 76, ' '); dbms_lob.writeappend(clob_loc, 48, ' '); dbms_lob.writeappend(clob_loc, 61, ' '); dbms_lob.writeappend(clob_loc, 43, '
Navigator Properties Tab
'); dbms_lob.writeappend(clob_loc, 5, '| Column Name | '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 75, 'Description | '); dbms_lob.writeappend(clob_loc, 6, '
| Property Name | '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 87, 'The name of the property as defined in the '); dbms_lob.writeappend(clob_loc, 46, ' Warehouse Builder Public Views. | '); dbms_lob.writeappend(clob_loc, 6, '
| Property Value | '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 85, 'The value of the property taken from the '); dbms_lob.writeappend(clob_loc, 47, ' Warehouse Builder Repository for the current '); dbms_lob.writeappend(clob_loc, 18, 'item. | '); dbms_lob.writeappend(clob_loc, 6, '
The other tabs in the Navigator '); dbms_lob.writeappend(clob_loc, 107, 'allow you to navigate and view the contents, related '); dbms_lob.writeappend(clob_loc, 109, 'items, reports, and links that are applicable to the current object. '); dbms_lob.writeappend(clob_loc, 5, '
');
dbms_lob.writeappend(clob_loc, 5, '
');
dbms_lob.writeappend(clob_loc, 8, ' ');
dbms_lob.writeappend(clob_loc, 8, ' ');
dbms_lob.close(clob_loc);
--text document 'us/nav_rfsh_di.html'
insert into wmp_text_docs (doc_name, doc_value,language) values ('nav_rfsh_di.html', empty_clob() ,'us');
select doc_value into clob_loc from wmp_text_docs where doc_name = 'nav_rfsh_di.html';
dbms_lob.open(clob_loc, dbms_lob.lob_readwrite);
dbms_lob.writeappend(clob_loc, 1, ' ');
dbms_lob.writeappend(clob_loc, 1, ' ');
dbms_lob.writeappend(clob_loc, 7, '
Refreshing the Dependency Index
'); dbms_lob.writeappend(clob_loc, 5, 'The Dependency Index is used '); dbms_lob.writeappend(clob_loc, 80, 'when displaying Lineage and Impact Analysis diagrams. In order for the diagrams '); dbms_lob.writeappend(clob_loc, 102, 'to display the most current information, the index must be refreshed regularly, if the content of the '); dbms_lob.writeappend(clob_loc, 37, 'repository is not frozen.
'); dbms_lob.writeappend(clob_loc, 84, 'Select one of the following action links:
'); dbms_lob.writeappend(clob_loc, 32, '| Action | '); dbms_lob.writeappend(clob_loc, 79, 'Description | '); dbms_lob.writeappend(clob_loc, 8, '
| Refresh Dependency '); dbms_lob.writeappend(clob_loc, 28, ' Index | '); dbms_lob.writeappend(clob_loc, 143, 'Refreshes the dependency index based on the latest data in the repository '); dbms_lob.writeappend(clob_loc, 79, 'and stores the username, date, and elapsed time in a log. The log is displayed '); dbms_lob.writeappend(clob_loc, 44, 'on the lower half of this page. | '); dbms_lob.writeappend(clob_loc, 8, '
| Purge '); dbms_lob.writeappend(clob_loc, 26, ' Log | '); dbms_lob.writeappend(clob_loc, 152, 'Purges the log of refreshes performed. The last refresh will be saved. | '); dbms_lob.writeappend(clob_loc, 8, '
Navigator Related Tab
'); dbms_lob.writeappend(clob_loc, 5, 'The following table describes the Related tab '); dbms_lob.writeappend(clob_loc, 26, 'column values.
'); dbms_lob.writeappend(clob_loc, 32, '| Physical '); dbms_lob.writeappend(clob_loc, 23, ' Name | '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 101, 'Description | '); dbms_lob.writeappend(clob_loc, 6, '
| Name | '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 74, 'The '); dbms_lob.writeappend(clob_loc, 41, ' physical name of the item. | '); dbms_lob.writeappend(clob_loc, 6, '
| Type | '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 133, 'An icon showing a graphical representation of the of item type '); dbms_lob.writeappend(clob_loc, 38, ' and the item type name. | '); dbms_lob.writeappend(clob_loc, 6, '
| Actions | '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 80, 'There are ');
dbms_lob.writeappend(clob_loc, 75, ' two types of actions: generic actions and item specific actions. Generic ');
dbms_lob.writeappend(clob_loc, 77, ' actions are available for every item and are intended to help navigate the ');
dbms_lob.writeappend(clob_loc, 79, ' repository. Item specific actions are only available for particular items or ');
dbms_lob.writeappend(clob_loc, 71, ' item types and either perform tasks or link to external data. ');
dbms_lob.writeappend(clob_loc, 68, ' Generic Actions: '); dbms_lob.writeappend(clob_loc, 5, '
'); dbms_lob.writeappend(clob_loc, 31, ' '); dbms_lob.writeappend(clob_loc, 70, 'Note: You can also use contents to select a new item and '); dbms_lob.writeappend(clob_loc, 87, 'then switch tabs when the screen has refreshed. The properties, related, '); dbms_lob.writeappend(clob_loc, 71, 'reports and links action links are shortcuts. '); dbms_lob.writeappend(clob_loc, 74, 'Item Specific Actions: '); dbms_lob.writeappend(clob_loc, 5, '
| ');
dbms_lob.writeappend(clob_loc, 6, '
The other tabs in the Navigator '); dbms_lob.writeappend(clob_loc, 110, 'allow you to navigate and view the properties, related '); dbms_lob.writeappend(clob_loc, 82, 'items, reports, and links that are applicable to '); dbms_lob.writeappend(clob_loc, 27, 'the current object. '); dbms_lob.writeappend(clob_loc, 18, '
');
dbms_lob.writeappend(clob_loc, 15, '
Navigator Reports Tab
'); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 5, 'The Reports tab displays the ');
dbms_lob.writeappend(clob_loc, 62, 'Reports available for the current item. Select view to ');
dbms_lob.writeappend(clob_loc, 66, 'open up the Report for each related object. Each role has its own ');
dbms_lob.writeappend(clob_loc, 61, 'set of Reports available for each item type, so if you are a ');
dbms_lob.writeappend(clob_loc, 65, 'Business User, you will see a different set of reports from a QA ');
dbms_lob.writeappend(clob_loc, 11, 'user.
');
dbms_lob.writeappend(clob_loc, 19, '
| Column '); dbms_lob.writeappend(clob_loc, 29, ' Name | '); dbms_lob.writeappend(clob_loc, 83, 'Description | '); dbms_lob.writeappend(clob_loc, 10, '
| Name | '); dbms_lob.writeappend(clob_loc, 64, 'The name of '); dbms_lob.writeappend(clob_loc, 32, ' the report. | '); dbms_lob.writeappend(clob_loc, 10, '
| Actions | '); dbms_lob.writeappend(clob_loc, 78, 'Click view to '); dbms_lob.writeappend(clob_loc, 40, ' display the report. | '); dbms_lob.writeappend(clob_loc, 10, '
For information about Lineage and '); dbms_lob.writeappend(clob_loc, 62, 'Impact Analysis diagrams, click here.
'); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 63, 'The other tabs in the Navigator allow you to navigate and view the properties, contents, links and related item details that are applicable to the current object. '); dbms_lob.writeappend(clob_loc, 5, '
'); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 5, 'Warehouse Builder Reports Portlet
'); dbms_lob.writeappend(clob_loc, 5, 'Use the Warehouse Builder Reports Portlet to '); dbms_lob.writeappend(clob_loc, 77, 'display a Warehouse Builder Report on your Oracle Portal home page. When you '); dbms_lob.writeappend(clob_loc, 82, 'install this portlet, it does not contain a default Report. In order to display a '); dbms_lob.writeappend(clob_loc, 82, 'Report, you must add a report to your favorites. Once the report is saved in your '); dbms_lob.writeappend(clob_loc, 86, 'favorites you can use the Customize link on this portlet to add it.
'); dbms_lob.writeappend(clob_loc, 85, 'NOTE: When you have a Reports portlet on '); dbms_lob.writeappend(clob_loc, 79, 'your Oracle Portal home page, it refreshes each time you reload the home page. '); dbms_lob.writeappend(clob_loc, 45, 'This can delay the page display.
'); dbms_lob.writeappend(clob_loc, 80, 'The following table describes some of the action '); dbms_lob.writeappend(clob_loc, 44, 'links available on this portlet.
'); dbms_lob.writeappend(clob_loc, 19, '| Action '); dbms_lob.writeappend(clob_loc, 29, ' Link | '); dbms_lob.writeappend(clob_loc, 107, 'Description | '); dbms_lob.writeappend(clob_loc, 10, '
| Customize | '); dbms_lob.writeappend(clob_loc, 83, 'Allows '); dbms_lob.writeappend(clob_loc, 59, ' you to customize your display options. | '); dbms_lob.writeappend(clob_loc, 10, '
| Help | '); dbms_lob.writeappend(clob_loc, 85, 'Displays '); dbms_lob.writeappend(clob_loc, 54, ' the online help for this portlet. | '); dbms_lob.writeappend(clob_loc, 10, '
| About | '); dbms_lob.writeappend(clob_loc, 85, 'Displays '); dbms_lob.writeappend(clob_loc, 69, ' information about the Warehouse Builder Browser. | '); dbms_lob.writeappend(clob_loc, 10, '
| Full '); dbms_lob.writeappend(clob_loc, 25, ' Page | '); dbms_lob.writeappend(clob_loc, 85, 'Displays '); dbms_lob.writeappend(clob_loc, 53, ' the Navigator in full page mode. | '); dbms_lob.writeappend(clob_loc, 10, '
'); dbms_lob.writeappend(clob_loc, 7, ' '); dbms_lob.close(clob_loc); --text document 'us/rpt_port_cst.html' insert into wmp_text_docs (doc_name, doc_value,language) values ('rpt_port_cst.html', empty_clob() ,'us'); select doc_value into clob_loc from wmp_text_docs where doc_name = 'rpt_port_cst.html'; dbms_lob.open(clob_loc, dbms_lob.lob_readwrite); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 7, ' '); dbms_lob.writeappend(clob_loc, 47, '
Use the Reports Customize page to select which report '); dbms_lob.writeappend(clob_loc, 78, 'to display in the Reports portlet. You can only choose from Reports that have '); dbms_lob.writeappend(clob_loc, 60, 'previously been added to your list of favorites.
'); dbms_lob.writeappend(clob_loc, 80, 'To add a Report to the portal:
'); dbms_lob.writeappend(clob_loc, 78, 'Choose the Report you want displayed and click ');
dbms_lob.writeappend(clob_loc, 64, 'the Make Default link from the Actions column.
');
dbms_lob.writeappend(clob_loc, 29, ' The link will change to ');
dbms_lob.writeappend(clob_loc, 83, 'Reset Default. If you have more than one Report available, only one can be set ');
dbms_lob.writeappend(clob_loc, 52, 'as the default in the portlet at a time.
You can also choose to not display a Report in '); dbms_lob.writeappend(clob_loc, 79, 'the portlet. This is beneficial if you have a large report in your portlet and '); dbms_lob.writeappend(clob_loc, 81, 'you are reloading the Oracle Portal home page frequently.
'); dbms_lob.writeappend(clob_loc, 5, 'Managing Resources
'); dbms_lob.writeappend(clob_loc, 5, 'Use the Resource Management page to set up access '); dbms_lob.writeappend(clob_loc, 80, 'to different Warehouse Builder Browser elements, as well as edit and unregister '); dbms_lob.writeappend(clob_loc, 27, 'repositories. '); dbms_lob.writeappend(clob_loc, 79, '
The following table describes available actions '); dbms_lob.writeappend(clob_loc, 35, 'for each resource type:
'); dbms_lob.writeappend(clob_loc, 19, '| Resource '); dbms_lob.writeappend(clob_loc, 31, ' Type | '); dbms_lob.writeappend(clob_loc, 100, 'Action '); dbms_lob.writeappend(clob_loc, 31, ' Link | '); dbms_lob.writeappend(clob_loc, 121, 'Description | '); dbms_lob.writeappend(clob_loc, 12, '
| Portlet | '); dbms_lob.writeappend(clob_loc, 109, 'Access | '); dbms_lob.writeappend(clob_loc, 94, 'Use '); dbms_lob.writeappend(clob_loc, 67, ' this to grant or revoke access to a portlet. | '); dbms_lob.writeappend(clob_loc, 12, '
| Repository | '); dbms_lob.writeappend(clob_loc, 109, 'Access | '); dbms_lob.writeappend(clob_loc, 94, 'Use '); dbms_lob.writeappend(clob_loc, 70, ' this to grant or revoke access to a repository. | '); dbms_lob.writeappend(clob_loc, 12, '
| Edit | '); dbms_lob.writeappend(clob_loc, 94, 'Use '); dbms_lob.writeappend(clob_loc, 62, ' this to edit repository specifications. | '); dbms_lob.writeappend(clob_loc, 12, '|
| Unregister | '); dbms_lob.writeappend(clob_loc, 94, 'Use '); dbms_lob.writeappend(clob_loc, 110, ' this to unregister a repository. After unregistration the repository can no longer be browsed using '); dbms_lob.writeappend(clob_loc, 43, 'the Warehouse Builder Browser. | '); dbms_lob.writeappend(clob_loc, 12, '|
| Role | '); dbms_lob.writeappend(clob_loc, 109, 'Access | '); dbms_lob.writeappend(clob_loc, 94, 'Use '); dbms_lob.writeappend(clob_loc, 64, ' this to grant or revoke access to a role. | '); dbms_lob.writeappend(clob_loc, 12, '
| Custom '); dbms_lob.writeappend(clob_loc, 29, ' Report | '); dbms_lob.writeappend(clob_loc, 95, 'Role ');
dbms_lob.writeappend(clob_loc, 17, ' | ');
dbms_lob.writeappend(clob_loc, 94, ' Use '); dbms_lob.writeappend(clob_loc, 53, ' this to assign the report to one or roles. '); dbms_lob.writeappend(clob_loc, 76, 'When the report is assigned to a role, it appears in the appropriate report '); dbms_lob.writeappend(clob_loc, 32, 'list for that role. | '); dbms_lob.writeappend(clob_loc, 12, '
| Edit | '); dbms_lob.writeappend(clob_loc, 94, 'Use '); dbms_lob.writeappend(clob_loc, 69, ' this to edit the specification for the report. | '); dbms_lob.writeappend(clob_loc, 12, '|
| Unregister | '); dbms_lob.writeappend(clob_loc, 94, 'Use '); dbms_lob.writeappend(clob_loc, 106, ' this to unregister a report. After unregistration, the report can no longer be viewed using the '); dbms_lob.writeappend(clob_loc, 28, ' Warehouse Builder '); dbms_lob.writeappend(clob_loc, 21, 'Browser. | '); dbms_lob.writeappend(clob_loc, 12, '
'); dbms_lob.writeappend(clob_loc, 10, '
'); dbms_lob.close(clob_loc); --text document 'us/rsrcmgnt_ed_cr.html' insert into wmp_text_docs (doc_name, doc_value,language) values ('rsrcmgnt_ed_cr.html', empty_clob() ,'us'); select doc_value into clob_loc from wmp_text_docs where doc_name = 'rsrcmgnt_ed_cr.html'; dbms_lob.open(clob_loc, dbms_lob.lob_readwrite); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 7, ' '); dbms_lob.writeappend(clob_loc, 38, '
Editing Custom Reports
'); dbms_lob.writeappend(clob_loc, 5, 'Use the Edit a custom report page to edit the '); dbms_lob.writeappend(clob_loc, 77, 'information about custom report. A Custom Report is an application component '); dbms_lob.writeappend(clob_loc, 80, 'created using the Oracle Portal facilities. Registration of the report provides '); dbms_lob.writeappend(clob_loc, 81, 'the Warehouse Builder Browser system with the information required to invoke the '); dbms_lob.writeappend(clob_loc, 80, 'report. In order for the report to be available, roles must be assigned. If you '); dbms_lob.writeappend(clob_loc, 78, 'are editing an existing custom report, it is not necessary to re-assign roles '); dbms_lob.writeappend(clob_loc, 36, 'that previously existed.
'); dbms_lob.writeappend(clob_loc, 77, 'The following table describes the fields that '); dbms_lob.writeappend(clob_loc, 38, 'pertain to Custom Reports.
'); dbms_lob.writeappend(clob_loc, 32, '| Field Name | '); dbms_lob.writeappend(clob_loc, 79, 'Description | '); dbms_lob.writeappend(clob_loc, 8, '
| Display Name | '); dbms_lob.writeappend(clob_loc, 85, 'Edit the name of the report which is '); dbms_lob.writeappend(clob_loc, 49, ' seen in the reports list page. | '); dbms_lob.writeappend(clob_loc, 8, '
| Type Name | '); dbms_lob.writeappend(clob_loc, 79, 'Edit the name of the data type '); dbms_lob.writeappend(clob_loc, 92, ' reported on by this report. Choose one data type from the drop-down menu. | '); dbms_lob.writeappend(clob_loc, 8, '
| Package | '); dbms_lob.writeappend(clob_loc, 81, 'Edit the full name of the PL/SQL '); dbms_lob.writeappend(clob_loc, 56, ' package which implements this report. | '); dbms_lob.writeappend(clob_loc, 8, '
| Repository | '); dbms_lob.writeappend(clob_loc, 80, 'Edit the name of the repository '); dbms_lob.writeappend(clob_loc, 79, ' containing target objects for this report. The drop-down menu contains a '); dbms_lob.writeappend(clob_loc, 55, ' list of the registered repositories. | '); dbms_lob.writeappend(clob_loc, 8, '
'); dbms_lob.close(clob_loc); --text document 'us/rsrcmgnt_ed_crrole.html' insert into wmp_text_docs (doc_name, doc_value,language) values ('rsrcmgnt_ed_crrole.html', empty_clob() ,'us'); select doc_value into clob_loc from wmp_text_docs where doc_name = 'rsrcmgnt_ed_crrole.html'; dbms_lob.open(clob_loc, dbms_lob.lob_readwrite); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 7, '
'); dbms_lob.writeappend(clob_loc, 43, 'Editing Custom Report Roles
'); dbms_lob.writeappend(clob_loc, 5, 'To add access to a given role: '); dbms_lob.writeappend(clob_loc, 5, '
To remove access from a given role:
'); dbms_lob.writeappend(clob_loc, 5, 'Editing Database Links
'); dbms_lob.writeappend(clob_loc, 5, 'To edit a database link:
'); dbms_lob.writeappend(clob_loc, 32, 'Editing a Repository
'); dbms_lob.writeappend(clob_loc, 5, 'Fill in the following fields to register a '); dbms_lob.writeappend(clob_loc, 23, 'repository:
'); dbms_lob.writeappend(clob_loc, 31, '| Field Name | '); dbms_lob.writeappend(clob_loc, 105, 'Description | '); dbms_lob.writeappend(clob_loc, 8, '
| Name | '); dbms_lob.writeappend(clob_loc, 83, 'The name '); dbms_lob.writeappend(clob_loc, 21, ' the repository '); dbms_lob.writeappend(clob_loc, 94, ' will be known as within the Warehouse Builder Browser system. For example, this name is '); dbms_lob.writeappend(clob_loc, 53, ' displayed in the navigation pages. | '); dbms_lob.writeappend(clob_loc, 8, '
| Host Name | '); dbms_lob.writeappend(clob_loc, 102, 'The name of the computer on '); dbms_lob.writeappend(clob_loc, 73, ' which the repository is stored. This name must be identical to the '); dbms_lob.writeappend(clob_loc, 75, ' name used within the Warehouse Builder client or else it will not be '); dbms_lob.writeappend(clob_loc, 83, ' possible to invoke reports for this repository from that client. | '); dbms_lob.writeappend(clob_loc, 8, '
| Database SID | '); dbms_lob.writeappend(clob_loc, 107, 'The SID of the database in which '); dbms_lob.writeappend(clob_loc, 72, ' the repository is stored. This name must be identical to the name '); dbms_lob.writeappend(clob_loc, 79, ' used within the Warehouse Builder client or else it will not be possible '); dbms_lob.writeappend(clob_loc, 54, ' to invoke reports from that client. | '); dbms_lob.writeappend(clob_loc, 8, '
| OWB Repository Schema | '); dbms_lob.writeappend(clob_loc, 106, 'The name of the schema in which '); dbms_lob.writeappend(clob_loc, 72, ' the repository is stored. This name must be identical to the name '); dbms_lob.writeappend(clob_loc, 79, ' used within the Warehouse Builder client or else it will not be possible '); dbms_lob.writeappend(clob_loc, 54, ' to invoke reports from that client. | '); dbms_lob.writeappend(clob_loc, 8, '
| Database Link | '); dbms_lob.writeappend(clob_loc, 104, 'The name of the database link '); dbms_lob.writeappend(clob_loc, 80, ' which should be used to access the repository. The link must already have '); dbms_lob.writeappend(clob_loc, 81, ' been created, using SQL*Plus for example. This field must be specified and '); dbms_lob.writeappend(clob_loc, 80, ' must refer to a valid link even if the repository is on the same database '); dbms_lob.writeappend(clob_loc, 59, ' as the Warehouse Builder Browser system. | '); dbms_lob.writeappend(clob_loc, 8, '
| Description | '); dbms_lob.writeappend(clob_loc, 101, 'The descriptive text which '); dbms_lob.writeappend(clob_loc, 75, ' appears within the navigation pages for this repository. | '); dbms_lob.writeappend(clob_loc, 8, '
'); dbms_lob.writeappend(clob_loc, 82, 'Granting and Revoking Portlet Access
'); dbms_lob.writeappend(clob_loc, 5, 'Grant Access To User
'); dbms_lob.writeappend(clob_loc, 5, 'Grant Access To Group
'); dbms_lob.writeappend(clob_loc, 5, 'Change Access
'); dbms_lob.writeappend(clob_loc, 5, 'Granting and Revoking Repository Access
'); dbms_lob.writeappend(clob_loc, 5, 'Grant Access To User
'); dbms_lob.writeappend(clob_loc, 5, 'Grant Access To Group
'); dbms_lob.writeappend(clob_loc, 5, 'Change Access
'); dbms_lob.writeappend(clob_loc, 5, 'Granting and Revoking Role Access
'); dbms_lob.writeappend(clob_loc, 5, 'Grant Access To User
'); dbms_lob.writeappend(clob_loc, 5, 'Grant Access To Group
'); dbms_lob.writeappend(clob_loc, 5, 'Change Access
'); dbms_lob.writeappend(clob_loc, 5, '