25 Dialog reference

"How to edit business area properties"

This dialog has two tabs: General and Dependents. Click each tab to view or edit properties.

General tab

Name

This field displays the business area name.

Description

This field displays a text description of the business area.

The contents of this field are displayed in the description line of the Discoverer Plus Query Wizard (for more information, see the Oracle Business Intelligence Discoverer Plus User's Guide..

Identifier

A unique name that Discoverer uses to identify EUL and workbook objects. When matching objects common to different EULs, Discoverer uses identifiers to locate objects in different EULs that refer to the same business object. For more information, see "What are identifiers?".

Warning: It is not advisable to change an identifier as it can affect the relationships between EUL objects.

Dependents tab

Note that dependents do not apply at the business area level.

Automatically save changes after each edit

Use this check box to save changes each time a field in this dialog is updated.

Changing Identifier Warning dialog

This dialog is displayed when you attempt to save changes to an item's identifier, to warn you of the implications of changing an identifier.

Identifiers are unique names that Discoverer uses to identify EUL and workbook objects (e.g. business areas, folders, items, worksheets, parameters, joins, conditions, calculations). For example a folder named Sales in EUL 'A' might refer to the same business object to which the folder Sales Figures in EUL 'B' refers. Both folders have the same identifier and can therefore be recognized as being the same object.

Warning: It is not advisable to change an identifier as it can affect the relationships between EUL objects.

Some examples of why you might want to change an identifier are as follows:

to comply with strict naming conventions
where an object has been deleted and needs to be recreated with the same identifier

If you do change an identifier, then matching identifiers in other EULs should also be updated to reflect the change.

Are you sure you want to proceed?

Yes

Use this button to proceed. This enables you to make changes to the identifier.

Use this button to abandon the change.

Discoverer displays the Properties dialog.

Don't show this warning again during this session

Select this check box to disable display of this warning during a session.

Choose Folder dialog (for an item, condition or join)

Use this dialog to select a folder in which to store new items, conditions, or joins. Discoverer might display the Choose Folder dialog in any of the following cases:

the currently selected folder does not use the condition you are about to create
a folder is not selected on the Join Manager dialog and you click Change folder in the drop down list

This dialog is also displayed as:

New Join dialog

New Item dialog

New Condition dialog

For more information, see:

"About joining two folders using more than one join"

Business area

Use this drop down list to select a business area.

Choose a folder from the expandable list below.

Choose Join dialog

Use this dialog to select one or more joins once you have added items to a complex folder.

Discoverer displays the Choose Join dialog when you select items from two folders that are joined using more than one join.

For more information, see:

"How to create complex folders"

Choose Join

Use this field to select one or more joins.

Choose user or table/view dialog

Use this dialog to:

choose database and user

For example, when choosing a database user as the Owner of a folder (for further information, see "Folder Properties dialog").
choose table or view

For example, choosing a table or view when creating an external summary folder (for further information, see "How to create summary folders based on external summary tables").

This dialog is also displayed as:

Choose user dialog

For more information, see:

Database

Use the drop down list to select the database that contains the required user or table/view.

Use the list to select the user or table or view that you want.

Condition Properties dialog

Use this dialog to view or change the properties of a condition.

Note: Where more than one condition is selected, if you choose the Properties option then any changes made to a property will affect all the selected conditions.

For more information, see:

Name

Use this field to enter a descriptive condition name. This name appears in condition lists, and on Discoverer worksheets.

Description

Use this field to enter a brief description for the condition. This description is displayed in condition lists to help Discoverer users choose which condition they want to use.

Type

Use this drop down list to specify the condition as Mandatory and Optional as follows:

Mandatory conditions always apply to a folder. The Discoverer end user does not see the condition in Discoverer Plus and cannot turn it off.
Optional conditions can be applied or not applied. This offers Discoverer end users the choice to turn the condition on or off in Discoverer Plus.

Sequence

This field displays the order in which this item appears in the Discoverer Plus Object Selection Wizard. For example, you might want to display all conditions before items.

Formula

This field displays the formula that defines the condition.

Click this field to display the "Edit Condition dialog".

For more information about valid server syntax, see the Oracle Server SQL Language Reference Manual.

Identifier

Warning: It is not advisable to change an identifier as it can affect the relationships between EUL objects.

The Dependents tab displays two columns:

Type

Displays one or more object types (e.g. folders, items) that have a dependency on the selected condition.

Name

Displays the name of each object listed in the Type column.

Automatically save changes after each edit

Use this check box to save changes each time a field in this dialog is updated.

Conditions dialog

Use this dialog to select an existing condition to use when you create or edit a condition.

For more information, see:

Discoverer displays this dialog when you choose the Select Condition... option from the drop down list in the Item field of the New/Edit Condition dialog.

Select a condition:

Choose a condition to display in the Item field of the New/Edit Condition dialog.

Use the OK button to display the selected condition in the Item field.

The condition that you select here is used in the current condition statement of this condition.

Confirm Business Area Delete dialog

Use this dialog to manage how you delete a business area. For example, to check the impact of removing a business area before doing so.

Note: Folders that have no business area become orphaned folders. These folders still exist in the EUL, but are no longer visible in the Workarea. You can view and delete orphaned folders by using the Tools | Manage Folders option from the Discoverer main menu.

For more information, see:

"How to delete a business area"

Are you sure you want to delete this business area?

Delete this Business Area

Use this radio button to remove only the business area, but not the contents of the business area.
Delete this Business Area and its Folders

Use this radio button to remove the business area and all of the folders. This option does not remove folders from any other business area.

Yes

Use this button to remove the selected business area.

Use this button to cancel the action, and close this dialog with no change to the business area or EUL.

Impact

Use this button display the "Impact dialog". The Impact dialog displays a list of all objects that will be affected or removed if you remove the selected business area.

Confirm Delete dialog

Use this dialog to manage how you remove an item. For example, to check the impact of removing an item before doing so.

Yes

Use this button to removes the selected item from the business area.

Use this button to cancel the action and close the dialog without changing the business area.

Impact

Use this button to display the "Impact dialog". The Impact dialog displays a list of all objects that will be affected or removed if you remove the selected item.

Confirm Folder Delete dialog

Use this dialog to manage how you delete a folder. For example, to check the impact of removing a folder before doing so.

Note: A folder removed from the business area but not the EUL, and which is not referenced in any other business area is known as an orphan folder.

For more information, see:

"How to delete folders from a business area"

Are you sure you want to delete this folder?

Delete from this Business Area

Use this radio button to remove the selected folder from the current business area, but not delete the folder from the EUL. This means that you can still use this folder in other business areas.
Delete from the End User Layer

Use this radio button to remove the selected folder from the business area and from the EUL. You will no longer be able to use this folder in this or any other business area in the EUL.

Impact

Use this button display the "Impact dialog". The Impact dialog displays a list of all objects that will be affected or removed if you delete the selected folder.

Connect dialog

Use the Connect dialog to connect to a different End User Layer. This dialog also appears when you first run Discoverer Administrator. You cannot work in Discoverer Administrator unless you are connected to an EUL.

Notes

When you connect to Oracle Applications EULs, the Connect dialog prompts you to enter your Oracle Applications connect details, (see the Status area in the Connect dialog). If Discoverer is not configured to use Oracle Applications EULs, you need to reconfigure your Connect dialog. Choose Tools ¦ Options to configure Discoverer to connect to Oracle Applications EULs.

For more information, see:

"Differences with the Discoverer Connect dialog in Oracle Applications mode"

Username

Use this field to enter your authorized database user name.

Password

Use this field to enter authorized database password to match the user name.

Connect

Use this field to enter the name of the database that you are connecting to.

Oracle Applications User

This optional check box is displayed when Discoverer is configured to use both standard Discoverer EULs and Oracle Applications EULs.

If you DO NOT want to connect to an Oracle Applications EUL, make sure that this option is NOT selected.

If you DO want to connect to an Oracle Applications EUL, make sure that this option is selected.

Connect button

Use this button to connect to the database using the connection details entered.

Note: You cannot be connected to more than one End User Layer at a time. When you establish a new connection, all open business areas close and the connection to the current database terminates. You are prompted to save any changes before the new connection is established. If the new connection fails, you remain connected as the original user id.

Create EUL Wizard dialog

Use the Create EUL Wizard to help you create a new End User Layer (EUL). In this dialog you define the owner of the new EUL.

For more information, see:

Who will own the EUL?

Select an existing user

Use this radio button to create an EUL for an existing database user in the current database. Select the database user from the User drop down list.

Note: If the database user already owns an EUL, the new EUL will replace the existing EUL.
Create a new user

Use this radio button to create a new database user and an EUL for that database user. You must have sufficient database privileges to create a new user (for more information, see "What privileges do you need to create an End User Layer in an Oracle database?").

Grant EUL access to PUBLIC

Select this check box to specify that the new EUL is accessible to all users in the current database.

Clear this check box to specify that the EUL owner is the only database user that is able to access data through this EUL.

Note: It is recommended that you clear the Grant EUL access PUBLIC check box, where security is an issue. The EUL owner can subsequently define business area access and privileges for users and roles or responsibilities as required (for more information, see "Controlling access to information").

New EUL is for use by Oracle Applications users ONLY

Select this check box to restrict EUL access to Oracle Applications users. Clear this check box to create a standard EUL.

Note: The choice that you make here is final. You cannot change a standard EUL into an Oracle Applications EUL (and vice versa).

Enter the EUL user's password

User

If you want a new database user to own the new EUL, use this field to enter a username for the new database user. A new database user will be created.

Select

If you want an existing database user to own the new EUL, use this button to display the "Select User dialog" where you can search for and select the database user that will own the new EUL.

Password

If you want a new database user to own the new EUL, use this field to enter a password for the new database user.

If you want an existing database user to own the new EUL, use this field to enter the password for that user.

This field is grayed out if you have specified that the current user (i.e. the username you used to start Discoverer Administration) will own the EUL.

Confirm password

If you want a new database user to own the new EUL, use this field to re-enter the password for the new user.

This field is grayed out if you have specified that an existing user will own the new EUL.

Create EUL Wizard: Step 2 dialog

Use this dialog when you want a new database user to own a new EUL. Use this dialog to select the default and temporary tablespace for the new user.

Note: These settings are database settings.

This dialog is also displayed as:

Create EUL Wizard: Step 3 dialog

For more information, see:

Default Tablespace

Use this field to select the database tablespace in which to store the Discoverer EUL tables, metadata, workbooks and worksheets for this user.

For more information about EUL space requirements and storage parameters, see "What are the space requirements and storage parameters for a typical EUL?".

For a default configuration, you typically choose the USR tablespace here.

Tablespace

Lists the available tablespaces in the database.
MB free

Displays the amount of space available in the tablespace.
Auto Ext.

Indicates whether the Auto Extend feature is On or Off for the tablespace in the database. When the Auto Extend feature is On, the tablespace will automatically increase in size when necessary.

Temporary Tablespace

Use this field to select the database tablespace where temporary data is stored for this user. For a default configuration, you typically choose TEMP here.

Create EUL Wizard: Step 2 dialog (Oracle Applications EUL)

Use this dialog when you are creating a new Oracle Applications EUL. Use this dialog to select the schema (containing the Oracle Applications FND (Foundation) tables) and enter a password for the schema. The FND tables contain the metadata for the Oracle Applications.

For more information, see:

"What are Oracle Applications?"

Select the schema containing the Oracle Applications FND tables

Schema

Use this drop down list to select the schema that contains the FND tables.

Password

Use this field to enter the password for the schema.

Custom Folder dialog

Use this dialog to create and edit custom folders. You do this by entering a SQL select statement. Like other folders, cu stom folders require joins in order for their data to relate to other data in the business area.

For more information, see:

"What are custom folders?"

"How to create custom folders"

Enter the SQL to define the custom folder

Use this field to enter the SQL statement that will define the folder. For example:

SELECT ENAME, JOB, SAL FROM EMP@ORCL

The Discoverer Administrator then creates items for each of the select list items. In Discoverer Plus, end users can use custom folders to build queries in exactly the same way as for other folders.

You can enter up to 2,000,000,000 characters in this field.

Name

Use this field to enter a name for the folder.

Validate SQL

Use this button to validate the SQL statement at any time before saving it. An invalid SQL statement prompts an error message.

Use this button to validate the SQL statement and save the custom folder.

Notes

Discoverer allows you to save the custom folder even if the SQL is invalid. This allows for situations where the SQL needs to be inserted into the EUL before the actual database objects are created or made available. However, users will not be able to query it until the SQL is corrected.
If the SQL is invalid and you wish to correct it, select the custom folder in the Data tab and right-click to access its Properties dialog. Double-click on the Custom SQL field to display the Custom Folder dialog.
This dialog becomes read-only if the current user does not have the Create/Edit Business Area privilege (for more information, see "Privileges dialog: Privileges tab"). When this dialog is read-only you can still copy and paste the SQL statement to another document.
When a custom folder is based upon a view and you update the view(e.g. by adding a new column), the update will only become available in Discoverer if you refresh the business area. For more information, see "How to synchronize a business area with the database".
Discoverer does not allow you to use the WITH clause in the custom folder SQL.

Custom Folder Properties dialog

Use this dialog to look at or change the properties of the currently selected custom folder.

For more information, see:

"What are custom folders?"

Name

Use this field to enter a name for the folder.

Description

Use this field to enter a brief description for the folder.

Visible to user

Use this field to choose whether you want Discoverer end users to be able to see this folder in Discoverer Plus.

Valid

This read-only field displays Yes when the SQL statement used to create the custom folder is valid.

Custom SQL

Use this field to display the "Custom Folder dialog", where you can change the SQL statement used to create the custom folder.

Identifier

Warning: It is not advisable to change an identifier as it can affect the relationships between EUL objects.

Automatically save changes after each edit

Use this check box to save changes each time a field in this dialog is updated.

Notes

The Custom SQL field contains the SQL statement that defined the folder. If the SQL statement is incorrect, the custom folder will not be functional in Discoverer Plus.
To view the entire statement resize the Properties window.

Database Information dialog

Use this dialog to view the name of the database to which you are currently connected and the functions available. For example, to check that you have configured the database correctly.

For more information, see:

"What are the prerequisites for using Oracle Business Intelligence Discoverer Administrator?"

Connected to:

Use this field to find out the name of the database to which you are connected. This field is a concatenation of your user name, the @ symbol and the database name.

The list box displays database configuration information as well as any functionality not available to this database user and why the functionality it is not available.

Notes

If summary management is displayed as not available:

Summary management will not be available to a newly created EUL owner.

The following privileges must be granted to enable summary management:
- analyze any
- create any materialized view
- drop any materialized view
- alter any materialized view
- global query rewrite
The above privileges can also be set up from the script eulasm.sql (located in the <ORACLE_HOME>\discoverer\util directory).

Database Storage Properties dialog: List of tabs

Use these tabs to edit the database storage properties for summary folders. For example, to change the tablespace allocation, cache setting or refresh type.

This dialog is also displayed as:

Database Storage Properties dialog

Note: Database storage properties do not apply to summary folders based on external summary tables.

For more information about summary folders, see:

"How to edit database storage properties of summary combinations for a summary folder"

The Database Storage Properties dialog consists of four tabs:

Properties

Use the "Database Storage Properties dialog: Properties tab" to view and set database storage properties.

Mappings

Use the "Database Storage Properties dialog: Mappings tab" to view the mappings between the items in the summary combination and database columns.

Tablespaces

Use the "Database Storage Properties dialog: Tablespaces tab" to view storage attributes for available tablespaces, including the available space in each tablespace. This information can help you to select a tablespace on the Properties tab.

Materialized Views (Oracle9i (or later) Enterprise Edition databases)

Use the "Database Storage Properties dialog: Materialized Views tab" to view and set database storage properties that are specific to Oracle9i (or later) Enterprise Edition databases.

Database Storage Properties dialog: Materialized Views tab

Use this tab to view and set database storage properties that are specific to Oracle9i (or later) Enterprise Edition databases.

Note: Database storage properties do not apply to summary folders based on external summary tables.

For more information, see:

"What are materialized views?"

"How to edit database storage properties of summary combinations for a summary folder"

The following table lists the properties and their default values, where appropriate. When you select a property, the panel at the bottom of the dialog displays a description of the purpose of the property.

Property	Default Value	Range	Create/Edit
Parallel Inserts	No	Yes/No/Default	yes
No. of Processes	1		yes, if Parallel Inserts set to yes
Logging	Same as user's tablespace	Yes/No	yes
Cache	No	Yes/No	yes, if Logging set to yes
Refresh Type	Full	Full/Incremental	yes
Refresh	On demand	On demand/On commit	yes
Last Refresh			no
Incremental Load			no
Stale			no

Parallel Inserts

Use this property to choose whether to use parallel inserts when refreshing summary folders.

No. of processes

Use this property (if Parallel Inserts is set to Yes) to set the number of parallel processes used when refreshing summary folders.

Logging

Use this property to enable or disable database logging.

Cache

Use this property to enable or disable database caching.

Refresh Type

Use this property to specify whether the summary folder Refresh Type is Incremental or Full.

Incremental

Only rows that have changed in the detail tables will be applied to the summary folder.

For more information on the conditions required for incremental refresh, see the Oracle Database Data Warehousing Guide.
Full

The summary folder is entirely rebuilt from the detail tables.

Refresh Mode

Use this property to specify whether the summary folder Refresh Mode is On demand or On commit.

On demand

Select this option to refresh manually or through scheduled refreshes.
On commit

Select this option to refresh every time the detail tables are updated. There is no need to schedule refreshes, and the scheduling option of the Summary Wizard is not enabled.

Restrictions apply as to when you can perform a refresh On commit. For more information, see the Oracle Database Data Warehousing Guide.

Last Refresh

This read-only property indicates the date when the last summary folder was refreshed.

Incremental Load

This read-only property indicates the types of inserts to the detail/fact table that can be incrementally refreshed.

None

The materialized view cannot be incrementally refreshed.
Direct Load

Only direct loads can be handled.
DML

Only DML (data manipulation language) statements can be handled.
Direct Load and DML

Both direct loads and DML can be handled.
Direct Load and limited DML

Direct loads and a subset of DML will be handled (for more information, see the Oracle9i Database documentation)

Stale

This read-only property indicates whether the detail tables have changed since the last summary folder refresh.

Database Storage Properties dialog: Mappings tab

Use this read-only tab to find out how summary combinations are stored in the database. You can see how combination items map to columns in this materialized view.

Note: Database storage properties do not apply to summary folders based on external summary tables.

For more information, see:

"What are summary combinations?"

"About folders and summary folders in Discoverer"

"What to consider when defining summary combinations?"

"Guidelines for setting up summary combinations"

"How to edit database storage properties of summary combinations for a summary folder"

Item

This column displays the name of the item in the business area.

Database column

This column displays the column to which the item is mapped.

Datatype

This column displays the data type of the item.

Notes

The information on this tab is read-only.
The Mappings tab does not apply where summary folders are based on external summary tables.

Database Storage Properties dialog: Properties tab

Use this dialog to view and set database storage properties and the materialized view name (or summary table name in Oracle Standard Edition databases).

Note: Database storage properties do not apply to summary folders based on external summary tables.

For more information, see:

"How to edit database storage properties of summary combinations for a summary folder"

The following table lists the properties and their default values. When you select a property, the panel at the bottom of the dialog displays a description the purpose of the property and the datatype it will accept.

Property	Datatype	Default Value*	Range	Create/Edit
Table Owner**	alphanumeric	current user		yes
Table Name	alpha	EUL generated		yes
Tablespace**	alphanumeric	SYSTEM		yes
Initial Extent**	numeric	10K		yes
Next Extent	numeric	10K	minimum data block	yes
% Increase	numeric	50%	>=0%	yes
Min. Extent**	numeric	1	1-Maximum Extent	yes
Max. Extent	numeric	121	> Minimum Extent	yes
% Free	numeric	10%	0-100%	yes
% Used	numeric	40%	0-99%	yes
Status	alpha			no
# Rows	numeric			no
Error	alpha			no
Last Refreshed				no

Note: In the above table, if you change a **non-dynamic storage property that affects existing summary data, Discoverer recreates the summary folder, this might take some time.

Values for the attributes Status, # Rows, Error and Last Refreshed are only available for summary folders that have been built. Therefore, when you use the Summary Wizard, these fields are grayed out, but when you edit the summary folder, these fields display appropriate values.

Database Storage Properties dialog: Tablespaces tab

Use this read-only tab to view database storage attributes for available tablespaces, including the available space in each tablespace.

Note: Database storage properties do not apply to summary folders based on external summary tables.

For more information, see:

"How to edit database storage properties of summary combinations for a summary folder"

Tablespace

This column displays the name of the tablespace.

Free Space

This column displays the amount of free space remaining in the tablespace.

Used Space

This column displays the amount of space currently used.

Extend

This column indicates whether the tablespace automatically extends when more space is required.

Delete EUL dialog

Use this dialog to verify the name of the EUL that you want to delete. Discoverer Administrator only enables you to delete the EUL to which you are currently connected.

For more information, see:

"How to delete an End User Layer"

EUL

This field displays the name of the EUL that you want to delete. Because you can only delete the current EUL, the name you see in this field is the name of the EUL to which you are currently connected.

Use this button to delete the current EUL.

Cancel

Use this button if the name displayed in the EUL text box is not the EUL you want to delete.

To delete a different EUL, close the EUL Manager dialog and reconnect to the EUL you want to delete.

Edit Calculation dialog

Use this dialog to edit items and calculated items.

For more information, see:

"What are calculated items?"

"How to edit calculated items"

For example:

to change the name or description of an item
to change the name of a calculated item
to amend the formula in a calculated item

Show

Use these radio buttons to display calculations, functions, and item that you can use to build a calculation. To include items in the calculation, paste them into the Calculation field.

Items

Use this radio button to display the EUL items available.
Functions

Use this radio button display the functions available.

Paste

Use this button to the add the item currently selected in the Show list to the Calculation. The item is copied into the Calculation field at the position of the cursor.

Name

Use this field to edit the name of the item or calculated item.

Calculation

Use this field to enter the calculation details (for calculation examples, see Oracle Business Intelligence Discoverer Plus User's Guide).

To create a calculation, you one or more of the following methods:

Type the formula directly into the Calculation field.

Note: If you type an expression in the Calculation field, you must prefix the expression with an equals sign (i.e. =). For example, '=Sales SUM-Costs SUM'.
Paste items and functions from the Show field on the left into the calculation.
Click the operator buttons underneath the Calculation field to use them in the calculation.

Operator buttons + - x / % ( )

Use these buttons to add operators to the calculation. Operators are copied into the Calculation field.

Note: When you use arithmetic expressions in a calculation, the multiply and divide operators are executed first, regardless of their position in the calculation. If you have more than one operator of the same precedence, they are evaluated from left to right.

For example, the calculation Price – Discount * Quantity is evaluated as Discount*Quantity subtracted from Price. If you use parentheses around the subtraction expression (Price – Discount), the subtraction is executed before the multiplication.

Use this button to validate and save the calculation, as follows:

If the calculation has valid syntax, the calculation is saved and displayed in the Calculations dialog.
If the calculation has invalid syntax, an error message is displayed. You must correct any syntax errors before you can save the calculation.

Notes

The table below shows the functions available in the field beneath the Show field:

Category	Description
All Functions	An alphabetical list of all functions.
Analytic	Advanced statistical analysis, such as RANK, NTILE, CORR.
Conversion	Converting from one data type to another, such as: RAWTOHEX, TO_CHAR, TO_DATE.
Database	Optional category that is displayed when user defined functions are available (created using the Register PL/SQL Functions facility on the Tools menu).
Date	Manipulating date items such as ADD_MONTHS, NEW_TIME, SYSDATE and NEXTDATE.
Group	Aggregate and statistical functions including SUM, COUNT, MAX, MIN, VARIANCE.
Numeric	Numeric items, transcendentals and floating point such as COS, LOG, MOD, POWER.
Others	Miscellaneous functions such as LEAST, USER, DECODE, ROWNUM.
String	Character items, text operations such as INITCAP, LPAD, NLS_UPPER.

For detailed information about all functions available in Discoverer, see the Oracle Database SQL Reference Guide and Oracle Database Data Warehousing Guide.
For examples of the most commonly used functions, see Oracle Business Intelligence Discoverer Plus User's Guide.

Edit Hierarchy dialog: Items tab

Use this dialog to manage date hierarchies for use in Discoverer workbooks.

This dialog is also displayed as:

Hierarchy Wizard: Step 2 dialog

You can create a date hierarchy in one of two ways:

Create a custom format mask of your own (for more information, see the New Format button below).
Choosing from a set of predefined date format masks

For more information, see:

"What are date format masks?"

"What are date items?"

Select date formats for the hierarchy

New Format

Use this button to display the "New Date Format dialog", where you can define a customized date format mask.

Note: This button is only displayed when you are creating a date hierarchy using the Hierarchy Wizard.

Description

This editable field displays a brief description of the data format currently selected in the right hand pane.

(Format pane)

To use a predefined format, select from the items listed in the left hand pane and move them to the right hand pane.

You can select more than one item by pressing the Ctrl key and clicking another item.

Promote

Use this button to move the selected item up one level in the hierarchy.

Demote

Use this button to move the selected item down one level in the hierarchy.

Group

Use this button to group the selected items at the same level in the hierarchy.

Ungroup

Use this button to ungroup previously grouped items to their previous levels in the hierarchy.

Edit Hierarchy dialog: Items tab (select date items that will use this date hierarchy)

Use this dialog to specify which items in the business area use a defined hierarchy. For example, if you create a hierarchy: Year - Month - Week - Day, you might want to specify year, month, week, and day items here. When Discoverer users drill on these items, they can use this hierarchy in the drill path.

This dialog is also displayed as:

Hierarchy Wizard: Step 3 dialog

For more information, see:

"How to create date hierarchies and templates"

Available Items

Use this drop down list to select a business area.

Select the items to use this hierarchy from the expandable list below.

To select items, move them from the Available Items list to the Selected Items list.

You can select more than one item by pressing the Ctrl key and clicking another item.

Selected items

This field displays the selected items that will use this hierarchy.

To select items, move them from the Available field to the Selected field.

Edit Hierarchy dialog: Items tab (select items to include in this hierarchy)

Use this dialog to create or edit items to include in hierarchies for use in Discoverer workbooks.

This dialog is also displayed as:

Hierarchy Wizard: Step 2 dialog

For more information, see:

"What are item hierarchies?"

Select items to include in this hierarchy.

Use this drop down list to select a business area that contains the items that you want to use in the hierarchy.

Use the expandable list below to select one or more items. To add items to the hierarchy, move items from the left-hand list to the right-hand list.

Description

This field displays a brief description of the item format currently selected in the right hand list.

Promote

Use this button to move the selected item up one level in the hierarchy.

Demote

Use this button to move the selected item down one level in the hierarchy.

Group

Use this button to position selected items on the same level of the hierarchy. Use grouped items so the Discoverer end user can drill from one item to display two levels of detail (e.g. the user could drill from Product to description and full description).

Ungroup

Use this button to ungroup the selected items, which means that they are no longer on the same level of the hierarchy.

Notes

You can select more than one item by pressing the Ctrl key and clicking another item.

Edit Hierarchy dialog: Name tab

Use this dialog to enter a name and description for a hierarchy.

This dialog is also displayed as:

Hierarchy Wizard: Step 3 dialog (name hierarchy)

Hierarchy Wizard: Step 4 dialog (name hierarchy)

For more information, see:

Hierarchy Name

Use this field to enter a name for the hierarchy.

Hierarchy Description

Use this field to enter additional information about the hierarchy.

Set as default date hierarchy

(Displays when you create a date hierarchy)

Select this check box for Discoverer to use this date hierarchy as the default date hierarchy.

Edit Item Class dialog: Alternative Sort tab

Use this dialog to select the item on which to base the alternative sort.

This dialog is also displayed as:

Item Class Wizard: Step 2 dialog (select the item containing the alternative sort sequence)

Item Class Wizard: Step 3 dialog (select the item containing the alternative sort sequence)

Item Class Wizard: Step 4 dialog (select the item containing the alternative sort sequence)

For more information, see:

Select the item containing the alternative sort sequence:

Folder

Use this field to select an item on which to base the alternative sort.

Note: The alternative sort item must be in the same folder as the list of values.

Edit Item Class dialog: General tab

Use this dialog to enter a name and description for a new item class.

This dialog is also displayed as:

Item Class Wizard: Step 3 dialog (enter name and description)

Item Class Wizard: Step 5 dialog (enter name and description)

Item Class Wizard: Step 6 dialog (enter name and description)

For more information, see:

Item class name

Use this field to enter a name for the new item class. Discoverer Administrator enters a default name for you that you can use. This name is used to identify the item class in other dialogs.

Item class description

(optional) Use this field to enter a brief description for the new item class.

Edit Item Class dialog: List of values tab

Use this dialog to select the item on which to base the list of values.

For more information, see:

This dialog is also displayed as:

Item Class Wizard: Step 2 dialog (select the item that generates the LOV)

Select the item that generates list of values:

Business area:

Use this field to select an item on which to base the list of values. You can choose from any business area in the EUL.

Notes

Selecting a business area displays its folders.
Click the plus (+) symbol to expand folders and display the items contained in them.

Edit Item Class dialog: Options tab

Use this dialog to change advanced list of value (LOV) options for an item class. The settings made here affect how Discoverer Plus users select and display LOV options.

This dialog is also displayed as:

Item Class Wizard: Step 4 dialog (advanced options for list of values)

Item Class Wizard: Step 5 dialog (advanced options for list of values)

For more information, see:

Retrieve values in groups of

Use this spin box to specify the maximum number of rows to display to an end user (for each array fetch of data from the database), when a list of values is expanded in Discoverer Plus.

Discoverer end users see the results of each database array fetch as a block of data that they can scroll up and down. End users can also easily display the next block of data (for more information, see the Oracle Business Intelligence Discoverer Plus User's Guide).

This setting is useful in Discoverer where a LOV might contain many rows, as it removes the risk of having to wait to retrieve all the values from the database at once. Discoverer displays the LOV values in blocks of a specific number of rows.

Note: The value set here is used as a default when the Require user to always search for values check box is cleared (for more information, see the "Require user to always search for values" item below).

Note: In Discoverer Plus, the server will always fetch from the database, the number of rows specified in the Retrieve values in groups of field no matter how large the number is. However, the maximum number of values that can be fetched by the client from the server is 100.

This means that if the Discoverer manager sets the fetch size to be 1000, (more than the 100 maximum above), in Discoverer Plus the rows are always fetched by the client in groups of 100. If the Discoverer manager sets the fetch size to be 50, (less than the 100 max), in Discoverer Plus the rows are always fetched in groups of 50.

Sort the values and remove duplicates

Select this check box to hide duplicate values and alphabetically sort the display order of the list of values (for an item class) in Discoverer.

Clear this check box to display duplicate values and display rows in the same order as the values stored in the database.

This option enables you to decide whether LOV statements should automatically add the DISTINCT and ORDER BY clauses. If you know that your data is already distinct and ordered (or if it doesn't matter if your data is returned this way) then you can choose to turn this setting off.

Note: The time taken to display large lists of values depends upon how long it takes to complete a search of the database tables. Clearing this check box can improve the time taken to display large lists of values.

Show values in "Select Items" page of Worksheet Wizard

Select this check box to display LOV items in the Select Items dialog of the Worksheet Wizard (the item navigator) in Discoverer Plus.

Clear this check box not to display LOV items in the Select Items dialog of the Worksheet Wizard (the item navigator) in Discoverer Plus.

Note: In the Item Navigator, the LOV does not use the array fetch size (as specified in the "Retrieve values in groups of" spin box). In this specific instance only, Discoverer will fetch all the values first before they are displayed. If you have millions of rows, this could potentially take a long time and you would want to have this option selected.

Require user to always search for values

Sometimes, for performance reasons you might want to force end users to query a subset of the LOV. To do this you use this check box.

Select this check box when you want Discoverer to display a Search Criteria field that forces end users to enter search criteria to reduce the list of values to a subset of the whole list.

Clear this check box when you want Discoverer to display the number of rows specified in the Retrieve values in groups of spin box (for more information, see "Retrieve values in groups of").

Cache list of values during each connection

Select this check box to cache the LOV (during the current session) once it has been displayed for the first time. Use a cache when your data is static during your session. This is the recommended setting.

Clear this check box to fetch LOVs from the database each time. This option is most useful when the data is extremely dynamic and you wish end users to always see the very latest (up-to-the-second) list of values.

Edit Item Class dialog: Select Items tab

Use this dialog to specify which items in the business area will use the new item class. For example, if you create a list of values on Month (January, February, March etc.), you might want to specify all month items here. When Discoverer end users query on month, they can choose from January, February, March etc.

This dialog is also displayed as:

Item Class Wizard: Step 2 dialog (select items that use this item class)

Item Class Wizard: Step 3 dialog (select items that use this item class)

Item Class Wizard: Step 4 dialog (select items that use this item class)

For more information, see:

Select the items that use this item class.

Available items:

Use this drop down list to select a business area.

Use the field to select the items to use this item class from the expandable list below.

To select items, move them from the Available items list to the Selected items list.

You can select more than one item by pressing the Ctrl key and clicking another item.

Selected items

This field displays the items that will use the item class.

To select items, move them from the Available items list to the Selected items list.

Notes

If you do not select the items using the item class, you will need to apply the item class to specific items later.

Edit Join dialog: Items tab

Use this dialog to create a new join, or to edit an existing join.

This dialog is also displayed as:

Join Wizard: Step 1 dialog

For more information, see:

"What are single item joins?"

"How to create joins"

Name

Use this field to enter the name of the join. This name is displayed in the Discoverer Administrator Workarea. Discoverer end users only see this name when two or more joins exist between two folders, and the end user has to choose between them.

Description

Use this field to enter additional information about the join. This description is displayed in the Discoverer Administrator Workarea. Discoverer end users only see this description when two or more joins exist between two folders, and the end user has to choose between them.

Master Items

Use this field to select the item in the master folder that you want to join. Fields are prefixed with the folder name, for example Products.Product Key.

Choose More items to display the "New Join dialog", where you can select a folder or item from anywhere in the EUL.

Operator

Use this drop down list to select how you want to match the items in the master folder and the detail folder. For example, choose the equals (=) operator to find an exact match between the two items.

List of join operators:

Operator	Equi or Non-equi Join?	Description
=	equi	relates rows that have equivalent values for specified items
< >	non-equi	not equal
<	non-equi	less than
<=	non-equi	less than or equal
>=	non-equi	greater than or equal
>	non-equi	greater than

Note: For more information about non-equi joins, see "What are non-equi-joins?".

Detail Items

Use this drop down list to select the item in the detail folder that matches the item in the master folder. The detail item folder can be in the same business area as the master folder, or in a different business area.

Choose More items to display the "New Join dialog", where you can select a folder or item from anywhere in the EUL.

Add

Use this button to add a join item to the join. Here, you can create multi-item joins by selecting another master folder, operator, and detail folder.

Delete

Use this button to remove the currently selected join item from the join.

Edit Join dialog: Options tab

Use this dialog to specify whether detail items exist in the master folder and optionally specify an outer join and the join relationship (also known as the cardinality of the join).

This dialog is also displayed as:

Join Wizard: Step 2 dialog

For more information, see:

"What are single item joins?"

"What effect do joins have on query results and query performance?"

"How to create joins"

Choose the join details

Use this option to specify whether Discoverer can assume that detail item values exist in the master folder for this join. For more information about which radio button to select, see "Examples of how joins can affect query results from complex folders".

Detail item values always exist in the master folder (Typical)

Use this radio button to display rows for detail items assuming that values in the detail folder always have corresponding values in the master folder (for more information, see "What effect do joins have on query results and query performance?")
Detail item values might not exist in the master folder

Use this radio button to not display rows for detail items assuming that values in the detail folder do not always have corresponding values in the master folder (for more information, see "What effect do joins have on query results and query performance?").

For more information about when to use these settings, see "Examples of how joins can affect query results from complex folders".

No outer joins

Use this radio button to not create any outer joins, and return all matching master and detail rows.

Outer join on detail

Use this radio button to create an outer join on the detail table. This returns all master rows that have no corresponding detail items, as well as all matching master and detail rows. For more information, see "What are outer joins?".

Outer join on master

Use this radio button to create an outer join on the master table. This returns all detail rows that have no corresponding master items, as well as all matching detail and master rows. This construct is rare in real business scenarios. To use this construct you must select the Detail item values might not exist in the master folder radio button. For more information, see "What are outer joins?".

One to one join relationship between master and detail

Select this check box to create a one-to-one relationship instead of a one-to-many relationship between the master and detail tables. There is no real master and detail in this case, because each row in the master table can correspond to no more than one row in the detail table.

This setting has no effect on the SQL that Discoverer generates, because SQL does not know about the cardinality of joins. It only affects the fan trap detection (for more information, see "What are fan traps, and how does Discoverer handle them?").

For more information about join relationships, see "What are one-to-many joins, one-to-one joins, and many-to-many joins?".

Edit Summary dialog: Choose Items tab

Use this dialog to select which items to add to a summary folder.

Note: You can select any axis items and math functions, but if the items are from different tables, a join must exist between the tables.

This dialog is also displayed as:

Summary Wizard: Step 3 dialog (add items to summary folder)

Summary Wizard: Step 4 dialog (add items to summary folder)

For more information, see:

"What are summary folders?"

Available items

Use this field to select items to add to the summary folder.

To select an item to add to the summary folder, move it from the Available items field to the Selected items field.

You can select more than one item by pressing the Ctrl key and clicking another item.

Selected items

This field contains items selected for the summary folder.

Edit Summary dialog: Combinations tab

Use this dialog to specify when you want Discoverer to use summary folders.

This dialog is also displayed as:

Summary Wizard: Step 4 dialog (add combinations of items)

Summary Wizard: Step 5 dialog (add combinations of items)

For more information, see:

"What are summary combinations?"

"What to consider when defining summary combinations?"

"Guidelines for setting up summary combinations"

"How to create summary folders based on items in the EUL"

Add combinations of items to this summary folder by clicking "Add Combination" and checking desired items

You need to choose the summary combinations that are to be pre-built and managed by the End User Layer. Each summary combination should reflect the type of analysis the user will want. The Summary Wizard displays one column for each possible summary combination of axis items and summary folders.

Items

This column displays the axis items selected for this summary folder.

Combinations

In each column, select the check box for each axis item in a summary combination to create a summary folder that reflects your requirements. Discoverer will build the results data for the summary folder when you finish using the wizard. The results data is available when a Discoverer end user runs a worksheet where the query matches a summary combination from this summary folder.

Add Combination

Use this button to add a new summary combination column.

Remove Combination

Use this button to delete the selected summary combination column.

Estimate Space

Use this button to display an estimate of the database space required to store the summary combinations you have created.

Properties

Use this button to view and edit database storage properties for the selected summary combination. For more information, see "Database Storage Properties dialog".

Status

This field displays the status and any database error message for a selected summary combination. If the summary folder for this combination was not built, Discoverer displays the server error message here. For more information about Status field values, see the "Summary Properties dialog" Notes section.

Edit Summary dialog: General tab

Use this dialog to enter a name and description for a summary folder. For summary folders based on materialized views or summary tables, you can also configure when to build the summary folder. For example, you might want to build a summary folder immediately.

This dialog is also displayed as:

Summary Wizard: Step 5 dialog (name summary folder)

Summary Wizard: Step 6 dialog (name summary folder)

Summary Wizard: Step 7 dialog (name summary folder)

For more information, see:

"About folders and summary folders in Discoverer"

"Why must you refresh summary data?"

For summary folders based on summary tables or materialized views

Here you can name a summary folder and schedule its build times.

Provide a name and description for this summary folder

Name

Use this field to enter a name for the summary folder. Discoverer Administrator creates a default name for you that you can use.

Description

(optional) Use this field to enter additional information about the summary folder.

When would you like to build this summary folder?

Build immediately

Use this radio button if you have smaller summary folders, or if you want to build the summary folder immediately.
Build at (Date, Time)

Use this radio button if you have larger summary folders that are best built at off-peak hours. Enter the time and date you want to build the summary folder.

For summary folders based on external summary tables

Here you can name the summary folder and provide a description.

Provide a name and description for this summary folder

Name

Use this field to enter a name for the summary folder. Discoverer Administrator creates a default name for you that you can use.

Description

(optional) Use this field to enter additional information about the summary folder.

Edit Summary dialog: Refresh tab

Use this dialog to set the refresh date and time for a summary folder.

This dialog is also displayed as:

Summary Wizard: Step 4 dialog (refresh summary folder)

Summary Wizard: Step 5 dialog (refresh summary folder)

Summary Wizard: Step 6 dialog (refresh summary folder)

For more information about refreshing summary folders see:

"How does ASM work?"

"What happens when a summary folder is refreshed?"

For summary folders (based on Discoverer summary tables or materialized views) refreshed by Discoverer

For summary folders refreshed by Discoverer, you can decide whether to refresh the summary automatically. If so, you can specify the date and time and the interval that you want to repeat the refresh.

When was this summary folder last refreshed by Discoverer?

These read-only fields display the date and time of the last refresh.

Automatically refresh this summary folder, starting on:

Use this check box to specify the date, time and repeat period that you want to apply to the refresh of this summary folder.

For summary folders (based on external summary tables) refreshed by another application

For summary folders refreshed by another application (i.e. using external summary tables), you can decide whether you want Discoverer to refresh the summary folder automatically, and if so you specify a date and time and the interval that you want to repeat the refresh.

Manage the refresh of this summary

Use this check box if you want Discoverer to manage the refresh of this summary folder.

Note: Be aware that if you use this option, you give Discoverer full control over the external summary table. For example, if you delete the summary folder that is based on a managed external summary, you also delete the external summary folder.

When was this summary last refreshed?

Date/Time

Use this field to enter the date and time the summary data was last refreshed. Discoverer uses this information to determine when summary folder data should be used.

Automatically refresh this summary folder, starting on:

Use this check box to specify the date, time and repeat period that you want to apply to the refresh of this summary folder.

EUL Manager dialog

Use this dialog to create and maintain End User Layers (EULs). This dialog also enables you to install the Discoverer sample data in the current EUL. The Discoverer sample data is an example business area that you can make available to Discoverer end users, enabling them to create and view workbooks and worksheets.

For more information, see:

"How to create an End User Layer for an existing database user"

"How to delete an End User Layer"

Connected to EUL: <EULName>

This field displays the name of the EUL to which you are currently connected.

Create an EUL

Use this button to display the "Create EUL Wizard dialog", where you can:

create a new EUL for the current user or another user in the database.
create a new user and an EUL for that user at the same time, providing you have sufficient database privileges (for more information, see "What privileges do you need to create an End User Layer in an Oracle database?").

Delete an EUL

Use this button to display the "Delete EUL dialog", where you delete the current EUL. Note that you can only delete the current EUL.

Install the sample data

Use this button to display the "Install/Uninstall Sample Data Wizard: Step 1 dialog", where you install the sample data into the current EUL. If the sample data has not been installed before, you must have sufficient database privileges to create the sample data user (for more information, see "What privileges do you need to create an End User Layer in an Oracle database?").

Uninstall the sample data

Use this button to display the "Install/Uninstall Sample Data Wizard: Step 1 dialog", where you delete the sample data business area and optionally remove the sample data, database tables and data from the current EUL. Note that the sample data database user is not deleted.

EUL Upgrade dialog

This dialog informs you that you must upgrade the EUL tables before you can use the current version of Discoverer Administrator.

Upgrading the EUL tables requires existing users to install the equivalent version of Discoverer Plus, Discoverer Desktop or Discoverer Viewer in order to continue running queries and reports.

We recommend that you export the EUL tables before starting the upgrade process.

Discoverer suggests two ways to proceed:

Manually create a new EUL

When you upgrade from a version 9.0.2, 9.0.4, or 9.0.4.1 EUL this option is recommended. Previous versions of Discoverer Plus, Discoverer Viewer and Discoverer Desktop will still be able to access the old EUL.

When you upgrade from a version 4.1 EUL this option is not essential because previous versions of Discoverer Plus, Discoverer Viewer and Discoverer Desktop will still be able to access the old EUL.
Automatically upgrade the existing EUL

When you upgrade from a version 4.1 EUL this option is recommended because previous versions of Discoverer Plus, Discoverer Viewer and Discoverer Desktop will still be able to access the old EUL.

Warning: Do not use this option when you upgrade from a version 9.0.2, 9.0.4 or 9.0.4.1 EUL until you have carried out an export of the EUL tables. If you don't export the 9.0.2, 9.0.4 or 9.0.4.1 EUL tables before carrying out the upgrade process, you might lose your version 9.0.2, 9.0.4 or 9.0.4.1 EUL. If you upgrade the from a version 9.0.2, 9.0.4 or 9.0.4.1 EUL , all users must upgrade to the latest versions of Discoverer Plus, Viewer and Desktop.

For more information, see:

"Upgrading from earlier versions of Discoverer"

"How to export an EUL using the standard database export utility")

Yes, I have completed a database export

Select this radio button to confirm that you have backed up the EUL by performing a database export. When you have selected this radio button, the Upgrade button is enabled.

Continue

Use this button to begin the EUL upgrade.

EUL Upgrade Error dialog

Use this dialog to find out about errors that have occurred during the EUL Upgrade process. This dialog appears automatically during the upgrade process if an error has occurred. The error messages displayed in this dialog enable you to diagnose and correct upgrade issues.

Notes

Make sure that you make a note of the error message before closing the dialog.
When you have resolved the error, reconnect to the EUL and the upgrade will resume automatically.

The error message typically includes an Oracle Database Error number. For example, the error number ORA-02298 is displayed when a table has orphaned child records. For more information about Oracle database error messages, see Oracle9i Database Error Messages in the Oracle documentation library.

For more information, see:

"Upgrading from earlier versions of Discoverer"

"About copying EULs and EUL objects by exporting and importing"

Export Wizard Step 1 dialog

Use this dialog to choose the Discoverer objects that you want to export to a file. You can export the entire EUL, one or more business areas, one or more EUL objects (e.g. folders, item classes, workbooks, the automated summary management (ASM) policy).

For more information, see:

"Creating and maintaining business areas"

What do you want to export?

The entire End User Layer

Use this radio button if you want to export the entire EUL to a file (i.e. all business area definitions, folders, item classes, item hierarchies, date hierarchies, PL/SQL function registration information, summary folders, workbooks and the automated summary management (ASM) policy).
Selected Business Areas

Use this radio button if you want to export one or more business areas to a file (i.e. selected business area definitions and their folders, item classes, item hierarchies, date hierarchies, PL/SQL function registration information, summary folders, workbooks and the automated summary management (ASM) policy).
Selected objects in the End User Layer

Use this radio button if you want to export one or more EUL objects to a file (i.e. selected business area definitions, folders, item classes, item hierarchies, date hierarchies, PL/SQL function registration information, summary folders, workbooks and the automated summary management (ASM) policy).

Notes

Note that you are only exporting the definition of the EUL, the business area, or the object being exported. You are not exporting the database containing the EUL tables, or the EUL tables themselves. Nor are you exporting the database objects referenced by the EUL objects. If you import a business area or object into a database, the following conditions must apply before Discoverer end users can view the data referenced by the imported business area or object:
- the database tables referenced by the imported business area or object must exist in the database
- database users must have sufficient privileges to access the database, the EUL tables, and the database objects, that the imported business area or object reference (for more information, see "Controlling access to information" and "What are the data access prerequisites?")

Export Wizard: Step 2 dialog (to export selected business areas)

Use this dialog to select the business areas to export.

This dialog is also displayed as:

Export Wizard: Step 2 dialog

For more information, see:

"About copying EULs and EUL objects by exporting and importing"

Which business areas do you want to export?

Available

This field displays all accessible business areas in the EUL.

To export a business area, move it from the Available field to the Selected field.

Selected

This field displays the business areas that will be exported.

To select a business area, move it from the Available field to the Selected field.

Export Wizard: Step 2 dialog (to export selected objects)

Use this dialog to select EUL objects to export (e.g. business area definitions, folders, workbooks).

This dialog is also displayed as:

Export Wizard: Step 2 dialog

For more information, see:

"About copying EULs and EUL objects by exporting and importing"

Which objects do you want to export?

Use this drop down list to select the type of object to display in the Available field (e.g. business area definitions, folders, item classes, item hierarchies, date hierarchies).

Available

This field displays all available objects in the EUL for the currently selected object type (e.g. if you chose item classes from the Which objects do you want to export drop down list, all item classes in the EUL are listed in this field).

To export an EUL object, move it from the Available field to the Selected field.

Selected

This field displays the EUL objects that you want to export.

Relationships between business areas and folders are displayed in the Selected field.

To select an EUL object, move it from the Available field to the Selected field.

Export Wizard: Step 2/3 dialog

Use this dialog to specify where you want to save the export file.

You can also:

save workbooks in XML
save export commands as a text file (*.txt)

This dialog is also displayed as:

Export Wizard: Step 2 dialog

Export Wizard: Step 3 dialog

For more information, see:

"About copying EULs and EUL objects by exporting and importing"

Where do you want to save the file?

Use this field to specify the name and location of the export file in which to save the exported objects. The export file will have .eex as the suffix.

Use the Browse button to specify the export file name and location using the Save As dialog.

Hint: It is a good idea to give the export file a name that suggests the kind of EUL objects the file contains. A descriptive name makes it easier to locate the file when you want to import it into another EUL later.

The following objects will be exported:

This field displays all of the objects that will be exported to the export file.

Generate additional XML for exported workbooks

Select this check box to save workbooks in XML format within the .eex file.

Clear this check box to only save workbooks in binary format within the .eex file.

Discoverer Administrator saves exported EUL objects in XML format in the export file, with the exception of workbooks. By default, workbooks are saved in binary format. By saving workbooks additionally in XML format you can view workbook definitions in an XML browser.

Save export commands as text file (*.txt)

Select this check box to create an additional text file containing the commands that were used to create this export. You might save export commands as a text file, in order to re-use them in the Discoverer command line interface (for more information, see "About using the Discoverer command line interface").

Notes

Note that you only export the definition of the EUL, the business area, or the object being exported. You are not exporting the database containing the EUL tables, or the EUL tables themselves. Nor are you exporting the database objects referenced by the EUL objects. If you import a business area or object into a database, the following conditions must apply before Discoverer end users can view the data referenced by the imported business area or object:
- the database tables referenced by the imported business area or object must exist in the database
- database users must have sufficient privileges to access the database, the EUL tables, and the database objects, that the imported business area or object reference (for more information, see "Controlling access to information" and "What are the data access prerequisites?")

Folder Properties dialog

Use this dialog to set properties for the currently selected folder. For example, to change the name of a folder, or to specify whether the folder is visible to end users.

For more information, see:

"How to edit folder properties"

"What is complex folder reach through?"

The Folder Properties dialog displays the following tabs for a simple folder, for more information, see:

"Folder Properties dialog: General tab"
"Folder Properties dialog: Dependents tab"

The Folder Properties dialog displays additional tabs for a complex folder, for more information, see:

"Folder Properties dialog: Components tab"
"Folder Properties dialog: Reach-Through tab"

Folder Properties dialog: General tab

Use this tab to configure the properties of the current folder.

For more information, see "What are folders?".

Name

Use this field to enter a unique name for the folder. The contents of this field are displayed in the Discoverer Plus folder selection dialog. The name of the folder must be unique in the End User Layer. You cannot have two folders with the same name, even in different business areas.

Note: If you change the name of an item, this might affect the names of secondary elements (e.g. joins, hierarchies, hierarchy nodes, item classes) that have the Auto generate name property set to Yes (for more information, see "About generating and updating EUL item names automatically").

Description

Use this field to enter a brief description of the folder. The contents of this field are displayed on the description line of the Query Wizard.

Visible to user

Use this field to specify whether the folder is displayed to the end user in the Discoverer Plus Query Wizard. Choose Yes to display this folder. You can use this property to hide items that are not directly of value to the end user, but need to be included in the business area because of joins or calculations. Folders not visible to the end user will be displayed in Discoverer Administrator in gray to indicate their hidden status.

Database

This field specifies the location of the source database which stores the table corresponding to the folder. To change the database, click this field to display the Choose Database dialog and select from the drop down list.

Note: This field is read-only for complex folders.

Owner

This field specifies the database user ID or owner of the table or view corresponding to the folder.

Note: This field is read-only for complex folders.

To change the owner, either type in the owner directly or click on the field and then click the button to display the Choose user dialog where you can select from the list.

The Owner field can be left blank. In this case the owner property is not specified in subsequent SQL references (through Discoverer Plus) to that folder. For example, a SQL select statement could now read as follows:

select <column> from <table>

rather than:

select <column> from <owner>.<table>

This is useful as it enables you to create/maintain an EUL for which the tables or table owners are not yet available, or to which the EUL administrator does not have access. It also enables multiple users (such as Oracle Applications users) each with their own schema in an EUL, to access their schema tables when making queries in Discoverer Plus.

Object

This field displays the name of the database object that corresponds to this folder. If a new table or view name has been chosen, it will appear here. To change the object, click this field to display the "Choose user or table/view dialog" and select from the list. You can choose an object from a different owner or a different business area.

If you select an Object name, the Database and Owner fields will also be re-populated with the database and owner values of the selected Object (irrespective of whether the Owner field was blank or not).

Note: This field is read-only for complex folders.

Optimizer hints

Use this field to place a specific optimizer hint against the folder. The hint is not visible in Discoverer Plus. For more information about how to use optimizer hints, see an appropriate release of the Oracle designing and tuning for performance documentation.

Identifier

Warning: It is not advisable to change an identifier as it can affect the relationships between EUL objects.

Automatically save changes after each edit

Use this check box to save changes each time a field in this dialog is updated.

Notes

If the Owner field is left blank, summary tables (in Oracle Standard Edition databases) based on this folder are not allowed. If a summary folder already exists a warning message is displayed.
If the Owner field is changed, summary tables (in Oracle Standard Edition databases) based on this folder need to be refreshed. If a summary folder already exists a message is displayed advising you to refresh the summary folders based on this folder.

Folder Properties dialog: Dependents tab

The Dependents tab displays two columns (Type and Name) that clarify the extent to which other objects (e.g. folders, joins, items, item classes, summaries, conditions, calculations, workbooks, scheduled workbooks) are dependent on the selected folder.

For more information, see "What are folders?".

Type

This field displays the type of item that has a dependency on the current folder. For example, folders, conditions, summaries, workbooks, scheduled workbooks.

Name

This field displays the name of each item that has a dependency on the current folder.

Folder Properties dialog: Components tab

This tab displays all component folders (and their items and joins) that are used by this complex folder.

For more information, see "What are complex folders?".

Use the + and - icons to expand and collapse the tree.

Note: This tab is only displayed for complex folders.

Folder Properties dialog: Reach-Through tab

This tab displays the base folders that you can define as reach through enabled for the currently selected complex folder. If a worksheet contains items from the complex folder, Discoverer end users can add additional items from reach through enabled base folders.

For more information, see "What is complex folder reach through?".

Use the check box to enable reach through for this base folder.

Note: This tab is only displayed for complex folders.

Hierarchy Properties dialog

Use this dialog to set hierarchy properties. For example, to change the name or description of a hierarchy.

For more information, see:

Name

Use this field to change the name of the hierarchy. By default, the name is derived from the item on which the hierarchy is based.

Note: This field becomes read-only if the Auto generate name property is set to Yes.

Auto generate name

Use this field to change the value of the Auto generate property to Yes or No. When the Auto generate name property is set to Yes, Discoverer enables the names of some types of End User Layer (EUL) items to be dynamically generated, whenever a folder or item name (used in this type of hierarchy) is changed.

This field becomes read-only when the Auto generate name property is not applicable to this item class.

For more information about this property, see "About generating and updating EUL item names automatically".

Description

Use this field to change the description of the hierarchy. The contents of this field are displayed on the description line of Discoverer Plus's Query Wizard.

Identifier

Use this field to change the unique name that Discoverer uses to identify EUL and workbook objects. When matching objects common to different EULs, Discoverer uses identifiers to locate objects in different EULs that refer to the same business objects.

Warning: It is not advisable to change an identifier as it can affect the relationships between EUL objects.

Automatically save changes after each edit

Use this check box to save changes each time a field in this dialog is updated.

Hierarchy Wizard: Step 1 dialog

Use this dialog to select the type of hierarchy that you want to create. For example, to select a date hierarchy when you want Discoverer end users to be able to drill into time-based data.

For more information, see:

"What are item hierarchies?"

"How to create item hierarchies"

"How to create date hierarchies and templates"

Which type of hierarchy do you want to create?

Item hierarchy

Use this radio button to select the item hierarchy type.
Date hierarchy

Use this radio button to select the date hierarchy type.

Notes

The hierarchical relationships that you create are not defined in the database, but in the business area.
Item hierarchies are used to connect multiple items in a specified order, allowing your user to drill up and down to different levels of detailed information. For example, you can connect the columns country, region, district, and retail store to create a location-based sales hierarchy. Each higher item (country is higher than region, for example) being a super-set of the items below it. When you create this sales hierarchy, users can create a worksheet that displays sales by country, then drill down to get regional details for each country, and so on down to the retail store level.
A date hierarchy lets your users drill up or down into date items from virtually any time-based perspective. For example, users can see sales data based on year, then drill down to quarter, and even further to month. Date hierarchies, unlike Item hierarchies, possess an inherent structure based on year, quarter, month, week, day, hour, minute, and second. Therefore, Discoverer Administrator uses pre-existing Date Templates to define many common formats for date hierarchies. In addition, you can create customized date hierarchies.

Impact dialog

Use this dialog to assess the impact of refreshing or deleting an object (e.g. business area, folder, item, item class, join, condition, hierarchy).

Based on the information displayed, you can determine if it is safe to carry out the current action against the object.

For more information, see:

"Confirm Business Area Delete dialog"

"Confirm Delete dialog"

"Confirm Folder Delete dialog"

Type

Use this column to view any dependent EUL objects that might be affected by the current action you are taking. The EUL objects listed here can include workbooks, scheduled workbooks, summary folders, business areas, folders, items, joins, conditions and item classes.

If you select a row, Discoverer displays text that indicates the effect the current action will have on the EUL object.

The following table lists the messages that Discoverer can display when workbooks, summary folders or other EUL objects are affected by the current action:

Scenario	Message Discoverer displays in Impact dialog
Workbook definitely affected	The object you are deleting is referenced by this workbook
Workbook might be affected	A probable impact to this workbook has been detected. Please open and close the workbook to re synchronize it with the current EUL.
Summary	You will need to remove the object from the summary before being able to delete it.
Item Class	This object will be updated.
All other eul objects	This will be deleted.

Name

Use this column to view the name of the EUL objects that might be affected by the current action you are taking.

Notes

Discoverer Administrator does not refresh or delete dependent workbooks when you refresh or delete an EUL object. Subsequent use of a workbook however, will be affected when you delete an EUL object that has dependent workbooks.
The Impact dialog displays dependent workbooks that are saved to the database. Dependencies might also exist in workbooks that are saved locally, such workbooks are not displayed in the Impact dialog.
Discoverer does not delete an EUL object that has dependent summary folders. You must manually remove such summary folders first. You delete summary folders at the Summaries tab in the Workarea (for more information, see "How to delete summary folders").

Import PL/SQL Functions dialog

Use this dialog to select the PL/SQL function that you want to import into the End User Layer.

For more information, see:

"Why do you need PL/SQL functions?"

"How to register custom PL/SQL functions automatically"

"How to register custom PL/SQL functions manually"

The functions listed in this dialog have been defined in the database using SQL commands. For more information about defining PL/SQL functions in the database, see the PL/SQL User's Guide and Reference.

Note: To register a PL/SQL function you must have EXECUTE privilege on the function.

Show PL/SQL functions where Owner matches

Use this field to enter search criteria to filter the PL/SQL functions that you want to display in the Select functions to import field.

Note: This field might improve performance when there are very large numbers of PL/SQL functions to display.

Use this button to search for functions that match the search criteria that you entered in the Show PL/SQL functions where Owner matches field, and list the results in the Select functions to import field.

Select functions to import

Use this list to select one or more functions that you want to import from the database.

You can select more than one function by pressing the Ctrl key and clicking another function.

Use this button to import the functions selected and display to the "PL/SQL Functions dialog: Functions tab".

Import Wizard: Step 1 dialog

Use this dialog to choose which EUL export files to import. For example, you might want to import a business area definition stored in a file called sales.eex.

For more information, see:

"About copying EULs and EUL objects by exporting and importing"

"How to import EUL objects from a file using the Import Wizard"

Add the files you would like to import

This field displays the list of files that you have selected for import.

Add

Use this button to display the Open File dialog, where you select the export file (.EEX) that you want to import.

When you have selected one or more files to import, the files appear in the Add the files you would like to import field.

Delete

Use this button to remove a highlighted export file from the list of files that you want to import.

Import Wizard: Step 2 dialog

Use this dialog to choose how to treat objects that have the same name or identifier, common to the EUL that you exported the objects from and the EUL that you are importing the objects into.

For more information, see:

"About copying EULs and EUL objects by exporting and importing"

"How to import EUL objects from a file using the Import Wizard"

If two objects match then what action should occur?

Rename the imported object

Use this radio button to rename imported objects to differentiate them from existing objects in the current EUL.

For example, you might want to import a folder named Sales into the current EUL, even though the current EUL already contains a folder named Sales. Selecting this option will change the name of the imported folder to Sales1. The EUL will contain a folder called Sales, and a folder called Sales1.
Rename the existing object

Use this radio button to rename existing objects in the current EUL to differentiate them from imported objects.

For example, you might want to import a folder named Sales into the current EUL, even though the current EUL already contains a folder named Sales. Selecting this option will change the name of the existing folder to Sales1. The EUL will contain the existing folder renamed to Sales1, and the imported folder named Sales.
Do not import the matching object

Use this radio button to not import objects that match existing objects in the current EUL.

For example, you might want to import a folder named Sales into the current EUL, even though the current EUL already contains a folder named Sales. Selecting this option will not import the folder Sales. The EUL will contain only the existing folder called Sales.
Refresh the object

Use this radio button to refresh any objects that match existing objects in the current EUL.

For example, you might want to import a folder named Sales into the current EUL, even though the current EUL already contains a folder named Sales. Selecting this option will update the existing folder Sales. The EUL will contain an updated folder named Sales.

When you use the Refresh the object radio button, it also activates the Preserve display related properties check box.

Preserve display related properties

This check box is activated when you select the Refresh the object radio button.

Select this check box to preserve the following workbook display properties:

heading
format mask
alignment
word wrap
display case
replace NULL with
default position

How you would like objects to be matched up?

Discoverer can use one of the following methods for determining, during an import, whether an object from one EUL is the same as an object in another EUL.

By Identifier

Use this radio button to match the same objects from different EULs by using identifiers. When an object from one EUL is the same as an object from another EUL, both objects share the same identifier.

Note: It is recommended that you use the By Identifier radio button to make sure that Discoverer correctly matches the same objects from different EULs, and not use the By Display Name radio button.
By Display Name

Use this radio button to match the same objects from different EULs by using object display names.

Note: It is recommended that you do not use the By Display Name radio button, but use the By Identifier radio button instead. This option is included here only for compatibility with previous versions of Discoverer.

Should the current user take ownership of imported workbooks?

Always take ownership of imported workbooks

Use this radio button if you want the current user to own any imported workbooks.
Only take ownership if original owner cannot be found

Use this radio button if you want the owner of an imported workbook to be the same database user as the original owner of that workbook. If the database does not contain a user with the same name as the original owner of a particular workbook, the current user will be the owner of that imported workbook.

Import Wizard: Step 3 dialog,

Use this dialog to start the import process and monitor its status as Discoverer processes each EUL object.

When you click the Start button, the status bar at the top of the page shows the percentage of the import that has completed.

For more information, see:

"About copying EULs and EUL objects by exporting and importing"

"How to import EUL objects from a file using the Import Wizard"

Start

Use this button to start the import process.

Log

Use this window to monitor messages as they are displayed. Two types of message are displayed:

information messages providing information about imported objects
warning messages, providing warnings about potential problems

Save log...

Use this button to specify the import log file name and location using the Save As dialog. The log file will have .txt as the suffix.

Hint: It is a good idea to give the log file a similar name to that of the export file that you are importing. A descriptive name makes it easier to locate the file later on.

Clear Log

Use this button to clear the messages from the Log field.

Cancel

Use this button to abort the import. You might want to abort the import if there are warning messages in the Log field.

When you abort an import, everything that has already been imported is rolled back.

Finish

Use this button after a successful import to commit the import transactions to the database.

Notes

Note that you only import the definition of the EUL, the business area, or the object being imported. You are not importing the database containing the EUL tables, or the EUL tables themselves. Nor are you importing the database objects referenced by the EUL objects. When you import a business area or object into a database, the following conditions must apply before Discoverer end users can view the data referenced by the imported business area or object:
- the database tables referenced by the imported business area or object must exist in the database
- database users must have sufficient privileges to access the database, the EUL tables, and the database objects, that the imported business area or object reference (for more information, see "Controlling access to information" and "What are the data access prerequisites?")

Install/Uninstall Sample Data Wizard: Step 1 dialog

Use this dialog to confirm the name of the EUL when you are installing or removing the sample data business area, data and tables.

If the EUL shown in this dialog is not the current EUL, click Cancel, close the EUL Manager dialog, and reconnect to the correct EUL.

For more information, see:

"Install Sample Data Wizard: Step 1 dialog"
"Uninstall Sample Data Wizard: Step 1 dialog"
"EUL Manager dialog"

Install Sample Data Wizard: Step 1 dialog

Use the Install Sample Data Wizard to help you install the sample data tables, data, and other necessary files.

You can only install the sample data in the current EUL.

EUL

This field displays the name of the EUL where the sample data information will be installed.

Uninstall Sample Data Wizard: Step 1 dialog

Use the Uninstall Sample Data Wizard to uninstall the sample data and tables from the current EUL.

Note: When you uninstall the sample data:

the sample data business area is removed from the current EUL
the VIDEO5 database user is not removed from the database.

EUL

This field displays the name of the EUL from where the sample data information will be uninstalled.

Remove the sample data tables

Use this checkbox to decide whether or not to remove the sample data and tables from the current EUL as follows:

Select this checkbox to remove the sample data and tables.

If you select this checkbox, other sample data installations will no longer be able to access the sample data.
Clear this check to remove the business area only.

Install/Uninstall Sample Data Wizard: Step 2 dialog

Use this dialog to confirm the sample data user's password when you are installing or removing the sample data business area, data and tables.

For more information, see:

"Install Sample Data Wizard: Step 2 dialog"
"Uninstall Sample Data Wizard: Step 2 dialog"
"EUL Manager dialog"

Install Sample Data Wizard: Step 2 dialog

Use this dialog to specify a password for the new VIDEO5 database user that is required to install the sample data.

User

This field displays the name of the sample data database user (VIDEO5) and is read-only.

Password

Use this field to enter the password for the VIDEO5 database user. If this is the first time the sample data has been installed in the current database, you create the password by entering it in this field.

Confirm password

Use this field to re-enter the password you entered in the Password field to confirm the VIDEO5 database user password. If the sample data was previously installed in any EUL in the current database, you will not need to confirm this password.

Finish

Use this button to install the sample data in the current EUL.

Uninstall Sample Data Wizard: Step 2 dialog

You must know the VIDEO5 database user password to uninstall the sample data.

Note: When you uninstall the sample data:

if you selected the Remove the sample data tables checkbox in the "Uninstall Sample Data Wizard: Step 1 dialog", the sample data and tables are removed from the database
the sample data business area is removed from the current EUL
if you selected the Remove the sample data tables checkbox in the "Uninstall Sample Data Wizard: Step 1 dialog", other sample data installations will no longer be able to access the sample data
the VIDEO5 database user is not removed from the database.

User

This read-only field displays the name of the sample data database user (VIDEO5).

Password

Use this field to enter the password for the VIDEO5 database user.

Finish

Use this button to uninstall the sample data from the current EUL.

Notes

If you do not know the VIDEO5 database user password, ask the DBA.

Install Sample Data Wizard: Step 3 dialog

Use this dialog to select the default and temporary tablespace for the VIDEO5 database user.

For more information, see:

"EUL Manager dialog"

Default Tablespace

Use this field to select the database tablespace in which to store the VIDEO5 data. The tablespace you select must have at least 10 MB free.

For more information about EUL space requirements and storage parameters, see "What are the space requirements and storage parameters for a typical EUL?".

For a default configuration, you typically choose the USR tablespace here.

Tablespace

Lists the available tablespaces in the database.
MB free

Displays the amount of space available in the tablespace.
Auto Ext.

Indicates whether the Auto Extend database feature is On or Off for the tablespace in the database. When the Auto Extend feature is On, the tablespace will automatically increase in size when necessary.

Temporary Tablespace

Use this field to select the database tablespace where temporary data is stored for the VIDEO5 database user. For a default configuration, you typically choose TEMP here.

Item Class Properties dialog: General tab

Use this dialog to set item class properties. For example, to change the name or description of an item class.

For more information, see:

"How to edit item properties"

Name

Use this field to change the name of the item class. By default, the name is derived from the item on which the item class is based.

Note: This field becomes read-only if the Auto generate name property is set to Yes.

Note: If you change the name of an item class, this might affect the names of secondary elements (e.g. joins and items in complex folders) that have the Auto generate name property set to Yes (for more information, see "About generating and updating EUL item names automatically").

Auto generate name

This field becomes read-only when the Auto generate name property is not applicable to this item class.

For more information about this property, see "About generating and updating EUL item names automatically".

Description

Use this field to change the description of the item class. The contents of this field are displayed on the description line of Discoverer Plus's Query Wizard.

Fetch in groups of

Use this field to change the maximum number of values that are returned with each fetch from the database.

Sort Values

Use the drop down list to sort the item class values or display them in the order that they are stored in the database.

Show in Wizard

Select Yes from this drop down list to show item class values in the Select Items page of the worksheet Wizard. This enables users to expand the LOV when selecting items to include in a worksheet.

Select No from this drop down list not to show item class values in the Select Items page of the worksheet Wizard. Users are not able to expand the LOV when selecting items to include in a worksheet.

Display Search Dialog

Select Yes from this drop down list to require users to always search for values whenever the LOV is expanded.

Cache LOV

Select Yes from this drop down list to store each LOV value in memory when the LOV is expanded for the first time.

Select No from this drop down list to retrieve values from the database each time the LOV is expanded.

Identifier

Warning: It is not advisable to change an identifier as it can affect the relationships between EUL objects.

Automatically save changes after each edit

Use this check box to save changes each time a field in this dialog is updated.

Item Class Wizard: Step 1 dialog

Use this dialog to choose the type of item class that you want to create. For example, to choose to create a list of values (LOV) that Discoverer end users can use when choosing parameter values to restrict workbooks.

For more information, see:

Select item class attributes:

List of values

Use this check box to create a set of the unique values that exist for an item. The values correspond to those found in a database column.

Alternative sort

Use this check box to sort items by criteria you define. Items are normally sorted in ascending or descending order according to ASCII sort values. Sometimes, however, you might want to sort data objects in an alternative order. For example, you might want to sort sales regions North, South, East, and West in that order, so the alternate sort order would be North=1, South=2, East=3 and West=4.

Drill to detail

Use this check box to allow users to drill from summary information into more specific information. These items do not need to be in the same folder.

Notes

To create an alternative sort order, you must first add a column to the database table containing the column to be sorted.
The item to be sorted with an alternate sequence must be contained within the same folder as the item providing the list of values for the item class. An item class containing an alternate sort sequence must also contain a list of values.
A one to one relationship must exist between the item used for the list of values and the item used for the sort order.

Item Hierarchy Node Properties dialog

Use this dialog to set item or date hierarchy node properties. For example, to change the name or description of an item or date hierarchy node.

For more information, see:

Name

Use this field to change the name of the item or date hierarchy node. By default, the name is derived from the item on which the hierarchy is based.

Note: This field becomes read-only if the Auto generate name property is set to Yes.

Auto generate name

This field becomes read-only when the Auto generate name property is not applicable to this item class.

For more information about this property, see "About generating and updating EUL item names automatically".

Description

Use this field to change the description of the item or date hierarchy node. The contents of this field are displayed on the description line of Discoverer Plus's Query Wizard.

Identifier

Warning: It is not advisable to change an identifier as it can affect the relationships between EUL objects.

Automatically save changes after each edit

Use this check box to save changes each time a field in this dialog is updated.

Item Properties dialog

Use this dialog to set item properties. For example, to change the name or formula of an item.

For more information, see:

"How to edit item properties"

The Item Properties dialog contains two tabs:

"Item Properties dialog: General tab" - use this tab to configure the item. For example, to change the item name.
"Item Properties dialog: Dependents tab" - use this tab to look at other items dependent on this item. For example, summaries that use the item.

Item Properties dialog: General tab

Use this tab to configure the item.

Name

Use this field to change the name of the item. By default, the name is derived from the database column on which the item is based.

Note: This field becomes read-only if the Auto generate name property is set to Yes.

Note: If you change the name of an item, this might affect the names of secondary elements (e.g. joins and items in complex folders) that have the Auto generate name property set to Yes (for more information, see "About generating and updating EUL item names automatically").

Auto generate name

This field becomes read-only when the Auto generate name property is not applicable to this type of item.

For more information about this property, see "About generating and updating EUL item names automatically".

Description

Use this field to change the description of the item. The contents of this field are displayed on the description line of Discoverer Plus's Query Wizard.

Data type

This read-only field displays the data type of the item, supplied by the column definition in the data dictionary. This field is not editable because it identifies the data type directly from the dictionary.

Formula

Use this field to display the "Edit Calculation dialog" where you change the item's formula. A formula displayed in this field means the item is a derived item. A derived item is created, by applying a calculation to an existing item. For example, a derived item can be the calculation for percentage profit. Deriving items in the business area means users do not have to know complex formulas themselves in order to calculate analysis results. A field containing a column name indicates that it is not a derived item and that its data comes directly from the database column (in this case, the field is read-only).

Database column

This field displays the derivation of the item. It consists of the owner's user name, the table name and column name. If this field is blank, the column has been created from a formula.

Visible to User

Use this field to specify whether the item is visible to Discoverer end users:

choose Yes to display the item in Discoverer Plus.
choose No to hide the item in Discoverer Plus

Note: You typically use the No option to hide items that must be present in the folder to be used in calculations, but are of no value or are inappropriate to display to the end user. Other hidden items might contain data such as primary and foreign keys or sensitive data such as salary information.

Item Class

Use this field to change the item class to which the item belongs. Use the list to select an alternative item class. This field is active only when the item is an axis item.

Date Hierarchy

Use this field to change the date hierarchy that is applied to the item. A list is available of valid date hierarchies that can be applied to the item. The field is inactive when the item is not a date item.

Default position

Use this field to change where the item is positioned by default on worksheets (e.g. Side, Page, Top, Datapoint)

Default aggregate

Use this field to change the aggregate type for the item (if numeric).

Heading

Use this field to change the heading. Discoverer displays the Heading property of each item used in a worksheet. By default, the heading is the item's Name property, which is derived from the database column on which the item is based.

Format mask

Use this field to change the default format mask used to display the item in Discoverer end user workbooks. The syntax uses standard Oracle formats found in the Server SQL Language Reference Manual, which is supplied with your Oracle database. By default, a listing shows sample format masks appropriate for the item's data type. You can enter your own format mask if the samples do not list the one you want.

Note: Discoverer Administrator does not currently enable you to use the Euro currency symbol in the format mask. However, you can specify the Euro currency symbol in the format mask using Discoverer Plus. For more information, see the Oracle Business Intelligence Discoverer Plus User's Guide.

Alignment

Use this field to change the alignment of data displayed in Discoverer Plus. Select an alignment from the drop down menu. The default selection, General, right aligns numeric data, and left aligns date and text data.

Word Wrap

Use this field to specify whether text data wraps in Discoverer Plus.

Note: Setting this to Yes can impact on performance in Discoverer Plus when accessing large amounts of text data.

Case Storage

Use this field to specify how text items are stored in the database, independent of how they are displayed. The Discoverer end user does not see this information. It enables you to optimize the use or display of this information in end-user workbooks. For example, if the data is already being stored correctly, you do not need to modify the text using the Display case option. Setting this value can improve the user's performance when running queries with conditions. If the data is always stored in uppercase in the database, set the value to uppercase. If the data is stored in lowercase, set the value to lowercase.

Display case

Use this field to change how items are displayed in workbooks.

Default width

Use this field to change the item's default width (i.e. in characters) when displayed in end user reports. This value is only used if Use Default Width is set in Discoverer Plus (under Tools | Options | Table).

Replace NULL with

Use this field to change how Discoverer displays null characters. For example, null = We're out... order now!, null = 0, null = nothing visible, or space.

Content type

Use this field to specify that the item contents are to be used to launch an external application. Choose FILE if the data item contents require another application to run, such as Microsoft Excel or an Internet browser. Choose <NONE> if the data type does not require another application.

Note: Setting this field to FILE only enables the item contents to display the data by launching an external application, when you are using Discoverer Desktop.

If the item contains a binary large object (BLOB), the file extension determines the application (i.e. which .exe executable file) to use to view the item. For example, .DOC uses MS Word, .WAV plays a sound through the currently registered sound player for WAV files. These associations are set up in your computer's operating system.

Note: If the content is an image that is stored in the database, choose NONE (for more information, see "About drilling out to other applications").

Max char fetched

Use this field to view (or specify, for LONG data types) the maximum amount of characters retrieved in a SQL call to the database. This option is particularly useful for specifying the number of characters retrieved for LONG data types. The purpose of restricting the total number of characters is that sometimes there are hundreds or thousands of characters in a data element and it would be inefficient or unnecessary to retrieve the entire data element.

Note: This field only displays values for LONG, LONG RAW and BLOB datatypes.

Alternative display value

Use this field to specify a descriptive label for items that have the Content Type set to <FILE>. This label is displayed in Discoverer Plus, Discoverer Viewer, and Discoverer Desktop. The label you specify here is used in the text for the drill link in Discoverer Desktop. For example, you might enter 'Click here to display the report in Wordpad' to replace the default field value \files\Report.doc.

Note: Setting the Content type field to FILE only enables you to drill on the item to display the data by launching an external application, when you are using Discoverer Desktop.

When a Discoverer Desktop end user clicks on a drill link, the file is opened in the application associated with the file type. For example, if you select a link for a *.DOC file, Discoverer Desktop might invoke Microsoft Word to display the file.

Indexed item

Use this field to select an indexed item to associate with the current item. Discoverer uses the indexed item to improve query performance when a parameter is based upon this item. The value of the indexed item you select here can be displayed in lists of values in Discoverer Plus and Discoverer Desktop when users create, edit and select parameter values.

When you select an item from the drop down list, make sure that the item has a database index icon beside it (the icon indicates that the item represents an indexed column in the database). Selecting an item that is not indexed might not improve query performance.

You can specify an indexed item for any EUL item, subject to the following conditions:

The item and its indexed item must be in the same EUL folder.
There must be a one-to-one mapping between the current item and its associated indexed item (i.e. for each item value there must be one (and only one) corresponding indexed item value). This condition is set by the database.
The indexed item cannot be of data type LONG or LONG RAW.
An EUL item can have only one indexed item associated with it. However, many EUL items can use the same item as their indexed item.
An item cannot simultaneously be associated with an indexed item and also be the indexed item of another EUL item.
Items that are hidden from end users can be selected as the indexed item.

Identifier

Warning: It is not advisable to change an identifier as it can affect the relationships between EUL objects.

Note: The primary use for the formula and database columns is for tracking the source of the item's data. For example, if something has changed in the underlying database or data dictionary, this field provides an audit trail identifying the data's original source. It provides information to the Discoverer manager about exactly where the data came from.

Automatically save changes after each edit

Use this check box to save changes each time a field in this dialog is updated.

Item Properties dialog: Dependents tab

This read-only tab displays two columns (i.e. Type and Name) that clarify the extent to which other objects (e.g. folders, joins, items, item classes, summary folders, conditions, calculated items) are dependent on the selected item.

Type

This field displays one or more object types (e.g. folders, items) that have a dependency on the selected item.

Name

This field displays the name of each object listed in the Type column.

Items dialog

Use this dialog to select an item to use when you create or edit a condition.

For more information, see:

Discoverer displays this dialog when you choose the Select Item... option from the drop down list in the Value(s) field of the New/Edit Condition dialog.

Select an item:

Choose an item to display in the Value(s) field of the New/Edit Condition dialog.

Use the OK button to display the selected item in the Value(s) field.

The item that you select here is used in the current condition statement of this condition.

Join Properties dialog

Use this dialog to configure join properties. For example, to change the name of a join or change its cardinality (i.e. Join relationship property).

The Join Properties dialog contains two tabs:

"Join Properties dialog: General tab" - use this tab to configure the join. For example, to change the join name.
"Join Properties dialog: Dependents tab" - use this tab to look at other items dependent on this join. For example, to look at summary folders that use the join.

Note: You can use the Join Properties dialog to inspect and edit more than one join item at a time. Select a join to view its properties. If you select more than one join and make a change to a property that is common to the selected joins, the changes apply to all selected joins.

Note: Discoverer can improve query performance for end users by removing unwanted joins (also known as join trimming). For more information, see "What effect do joins have on query results and query performance?".

For more information, see:

"How to view or edit joins"

Join Properties dialog: General tab

Use this tab to configure the join.

Name

Use this field to change the name of the join. By default, Discoverer Administrator will name the join item by combining the master and detail folder names in the form: Master Folder - > Detail Folder.

Note: This field becomes read-only if the Auto generate name property is set to Yes.

Auto generate name

Use this field to change the value of the Auto generate name property to Yes or No. When the Auto generate name property is set to Yes, Discoverer enables the names of some types of Joins to be automatically updated whenever a folder or item name (used in this join) is changed.

For more information about this property, see "About generating and updating EUL item names automatically".

Description

Use this field to change the description of the join. By default, Discoverer Administrator will describe the join item by combining the master and detail folder names in the form: Master Folder - > Detail Folder.

Master

Use this read-only field to view the folder name at the master end of the join relationship.

Detail

Use this read-only field to view the folder name at the detail end the join relationship.

Formula

Use this field to display the "Edit Join dialog: Items tab", where you specify how the items are joined.

Outer join on

Use this field to specify an outer join on the detail or master folder. This field can display the values None, Master folder or Detail folder.

Use an outer join on the detail folder when you want to return:

Master rows that have no corresponding detail items, as well as all matching master and detail rows.

Use an outer join on the master folder when you want to return:

Detail rows that have no corresponding master items, as well as all matching detail and master rows. This construct is rare in real business scenarios. To use this construct, select the Detail item values might not exist in the master folder value in the Join details field. For more information, see "Edit Join dialog: Options tab".

Join details

Use this field to specify that detail items always exist in the master folder, or whether detail items might not exist in the master folder.

This field can display the following values:

Detail item values always exists in master folder

For more information, see the Detail item values always exist in the master folder (Typical) radio button in the "Edit Join dialog: Options tab".
Detail item values might not exist in master folder

For more information, see the Detail item values might not exist in the master folder radio button in the "Edit Join dialog: Options tab".

Join relationship

Use this field to specify the type of join relationship (i.e. the cardinality of the join) as follows:

Use the One to one (1:1) join to join two tables that have a one to one relationship. For example, if every department has one (and only one) manager, and every manager can manage one (and only one) department, then you would use a 1:1 join relationship.
Use the One to many (1:n) join to join two tables that have a one to many relationship. For example, if every employee can be in one (and only one) department, and a department can have one, many, or no employees, then you would use a 1:n relationship.

Identifier

This field displays a unique name that Discoverer uses to identify EUL and workbook objects. When matching objects common to different EULs, Discoverer uses identifiers to locate objects in different EULs that refer to the same business object.

Warning: It is not advisable to change an identifier as it can affect the relationships between EUL objects.

Automatically save changes after each edit

Use this check box to save changes each time a field in this dialog is updated.

Join Properties dialog: Dependents tab

The Dependents tab displays two columns (i.e. Type and Name) that clarify the extent to which other objects (e.g. folders, joins) are dependent on the selected join.

Type

This column displays one or more object types (e.g. folders, items) that have a dependency on the selected join.

Name

This column displays the name of each object listed in the Type column.

Load Wizard: Step 1 dialog

Use the Load Wizard to choose how you want to open a business area. For example, you might want to:

create a new business area
open an existing business area

For more information, see:

"How to create a business area using the Load Wizard"

What do you want to do?

Create a new business area

Use this button to create a new business area. Discoverer displays the field "Where do you want to load the metadata from?".

Open an existing business area

Use this button to open an existing business area. Discoverer displays the field "Select one or more business areas to open".

If you choose Create a new business area, Discoverer displays the following options:

Where do you want to load the metadata from?

On-line dictionary

Use this radio button to load tables and views from the Oracle dictionary.
Gateway

Use this radio button to load tables and views from the data source you specify in this text box. Use the drop down list to select from available data sources.

For more information about loading a business area from the gateway, see "How to create a business area using the Load Wizard".

If you choose Open an existing business area, Discoverer displays the following options:

Select one or more business areas to open

Use this field to choose one or more business areas to open. Click the appropriate check boxes or use the Select All and Clear All buttons to help you select the business areas.

Notes

Discoverer displays the Load Wizard automatically when you connect to an EUL. To display the Load Wizard when you are already connected to an EUL, choose File ¦ New.
The Gateway option is only available when you are using Oracle Designer or have a registered EUL Gateway and all its tables are visible (for more information about setting up an EUL Gateway, see "What is the EUL Gateway?"). If you are using Oracle Designer, the drop down list displays the Oracle Designer work areas to which you have access. Note that if you are using a version of Oracle Designer prior to Oracle Designer 6i, the drop down list simply displays 'Oracle Designer repository'.
If you are loading data from Oracle Designer 6i (i.e. where versioning is switched on), create a work area containing the set of object versions you want to load. We recommend that the work area rules are based on a configuration which defines a coherent release set of objects. It is important to make sure that no foreign key definitions within the work area reference tables/views outside the work area. To validate the work area is complete, use the Oracle Designer 'List External Reference' utility.
If versioning (e.g. with Oracle Designer 6i) is not switched on, there will only be one default work area called the 'Global Shared Work area' containing all the objects, and this must be used.

Load Wizard: Step 2 dialog

Use this dialog to define which objects you want to load into the new business area. Your choices depend on where you choose to get your metadata.

For more information, see:

"How to create a business area using the Load Wizard"

Select a database link

Use this drop down list to specify which database to use as the data source.

Note: A database link sets up a connection from one database to another, and is created in the database. You can set up multiple database links in a database. If you are unsure, ask your Database Administrator for more information.

Select the users whose tables you want to load [for loading meta data from an online dictionary]

Use this field to choose one or more users whose tables can be loaded from the data source named in the Select a Database Link field. Click the appropriate check boxes or use the Select All and Clear All buttons to help you select the users.

Select the schemas you want to load [for loading meta data from a gateway]

Use this field to choose one or more schemas (i.e. object owners) whose objects can be loaded from the database link named in the Select a Database Link field. Click the appropriate check boxes or use the Select All and Clear All buttons to help you select the schemas.

Load user objects that match

Use this field to enter Oracle wildcard characters to find objects to load. This is helpful if you do not remember the names of the tables you want to load. By default all objects owned by the userid you selected will be loaded (i.e. when the percent (%) symbol is displayed in this field).

For further information about wildcards see "Loading from the online dictionary"

Load Wizard: Step 3 dialog

Use this dialog to select the schema objects that you want to load into the new business area.

For more information, see:

"How to create a business area using the Load Wizard"

Available

This field displays all schema objects (i.e. tables and views) available for inclusion in the new business area. Select one or more schema objects from the Available field and move them to the Selected field.

Selected

This field displays all tables and views that you have selected to be included in the new business area. Each table and view that you select will be a folder in the new business area.

Notes

You can select more than one schema object by pressing the Ctrl key and clicking another schema object.
The selections made in the Load Wizard: Step 2 dialog determined the objects that are now displayed in the Available field in the Load Wizard: Step 3 dialog. If you want to change any of those selections (i.e. the database link, user IDs, or tables you specified, if you used the online dictionary options), click Back to return to the Load Wizard: Step 2 dialog.

Load Wizard: Step 4 dialog

Use this dialog to configure the joins and additional objects that Discoverer generates when data is loaded into the new business area.

For more information, see:

"How to create a business area using the Load Wizard"

Do you want to create joins?

Yes, create joins from:

Use this check box to create joins on items in the business area.

Primary/foreign key constraints

Use this radio button to create joins on primary and foreign keys. For example, if Regions contain many Stores, the primary key Region.Region Name might be joined to the foreign key Stores.Region Name.

It is recommended that you use this option:
- when primary and foreign key constraints are defined in the database
You use this option because:
- it saves you having to create the joins manually
- Discoverer will always create joins that are correct (i.e. the master and detail relationship is specified the right way round)
Matching column names

Use this radio button to create joins on matching column names in the database tables. You use this option when no primary and foreign key constraints are defined, for example, if you are using a non-Oracle data source.

If you choose this option, Discoverer checks every column name of every object being loaded against every other column name. As the number of columns that are loaded increases, the amount of processing required also increases. A side effect of doing this is that the joins created must be checked after the load to make sure they are valid. The master-detail folder relationship must be verified as being the correct way round, and the join condition must be verified as being valid (i.e. not created accidentally by two different columns using the same name.)

What additional objects do you want to generate?

Summaries based on folders that are created

Use this check box to use automated summary management (ASM) to create summary folders after the load process, based on folders that Discoverer creates.

ASM attempts to create a set of suitable summary folders after analyzing the table structure. Selecting this option might slightly increase duration of the business area load, but should give end users improved query performance.

Note: Do not choose this option if you are going to run ASM, or if your database space is low.

Date hierarchies:

Use this check box to automatically create date hierarchies for date items.

Choose a hierarchy from the drop down list of default date hierarchy formats. The date hierarchy is applied to all date columns in the business area. Creating a date hierarchy enables end users to drill up/down through date items. For example, from years to quarters or from months to days.

Automatically generating date hierarchies inserts additional (i.e. calculated) items into the folder. An extra item is created for every date item in each node in the date hierarchy. For example a date hierarchy containing year|quarter|month|day applied to a table with three date columns, generates an additional 12 items in the folder. For more information, see "Creating and maintaining hierarchies".

Default aggregate on data points

Use this check box to specify a default aggregate for numeric items.

Choose an aggregate from the drop down list. The default aggregate is SUM.

List of values for items of type:

Use this check box to generate lists of values based on the types you select. This option automatically creates lists of values for each axis item of each type specified, except character items longer than 40 characters. The values are derived from the values in the database column.

Notes

Items are loaded as data points if they are DECIMALS (i.e. a NUMBER data type) and have a non-zero scale. Integer numbers, all keys, and all other data types are loaded as axis items, with a default position of Top.
Axis items are usually displayed on one of the axes of a worksheet. For example, the term Monthly Profit might be an axis item in a worksheet.

The alternative term for an axis item is a dimension.
Data points are usually displayed in the body of a worksheet. For example, an amount in dollars (e.g. $2,000) might be a data point item representing Monthly Profit in a worksheet.

The alternative term for a data point is a measure.
In Discoverer Plus, whether an item is an axis item or data point determines the items' default placement on cross tab worksheets, as follows:
- Because data points usually include the numbers that users want to analyze, they are displayed by default with aggregate functions in the center of cross tabular reports.
- Axis items can have lists of values but data points cannot. Axis items appear on the page, top, or side of cross tabular worksheets by default.
- The default position of an axis item or data point item in a worksheet is determined by the Discoverer manager. However, Discoverer Plus users can alter the position of axis items and datapoint items in a worksheet.
Lists of values are derived by querying the database when Discoverer users click the plus (+) symbol next to the item. Lists are dynamic and change if the values in the database change. When the plus (+) symbol is clicked, Discoverer caches the values on the client machine for performance reasons, unless the Cache list of values during each connection check box is cleared, when creating or editing an item class in the following dialogs:
- Item Class Wizard: Step 4/5 dialog
- Edit Item Class dialog: Options tab
If you select the Cache list of values during each connection check box and you want to display new values in a list, you must reconnect (for more information about this setting, see "Edit Item Class dialog: Options tab").
Avoid creating lists of values on items that will contain many values (e.g. decimals).

Load Wizard: Step 5 dialog

Use this dialog to enter a name and description for the business area and to configure how data is loaded into the business area.

For more information, see:

"How to create a business area using the Load Wizard"

What do you want to name this business area?

Use this field to enter a name for your new business area. Use a short name that reflects the business function of the business area. For example, Web Usage Analysis.

What Description do you want for this business area?

Use this field to enter a description for your new business area. Use this field to provide additional information about the business area, such as who created it, the intended audience, or more specific details about its scope.

How do you want to generate object names?

Replace all underscores with spaces

Use this check box to replaces underscores with spaces. For example, Region_Name is converted to Region Name.

Remove all column prefixes

Use this check box to removes prefix characters that are common to all columns. For example, if a table name is EMP and its column names are EMP_Number, EMP_Name, and EMP_Address, the corresponding names in the business area become Number, Name, and Address.

Capitalize:

Use this check box to capitalize (then choose an option from the drop down list) as follows:

The first letter of every word

Choose this option to capitalize the first letter of folder and item names. For example, REGION_NAME is converted to Region_Name. This is useful because table names are usually in uppercase text in the database.
The initial letter

Choose this option to capitalize the first letter of the first word of folder and item names. For example, REGION_NAME is converted to Region_name.

Which objects do you want to sort?

Sort Folders

Use this check box to sort folders alphabetically within a business area.

Sort Items

Use this check box to sort items alphabetically within a folder.

For information about using the command line interface to sort folders and items during a business area load, see "/load".

For information about sorting folders and items in a business area, see:

Manage Folders dialog: By Business Area tab

Use this tab to assign multiple folders to a single business area. For example, to add multiple folders to a new business area.

For more information, see:

Business area

Use this drop down list to select a business area to which you want to assign one or more folders.

Available folders

This list displays available folders not currently assigned to the business area selected. Orphaned folders are also shown in the list.

To assign folders to the current business area, move the folders from the Available folders list to the Current folders list.

Current folders

This list displays folders currently assigned to the business area.

To remove a folder from the current business area, move the folder from the Current folders list to the Available folders list.

Notes

You can select more than one folder at a time by holding down the Ctrl key and clicking another folder.

Manage Folders dialog: By Folder tab

Use this tab to assign single folders to multiple business areas. For example, to assign a new folder to multiple business areas.

For more information, see:

Folder

Use this drop down list to select the folder that you want to assign.

If you select a folder that is not assigned to any business area, the folder is an orphaned folder.

Available business areas

This list displays all available business areas to which you can assign the current folder.

To assign the current folder to a business area, move the business area from the Available business areas list to the Current business areas list.

Current business areas

This list displays business areas to which the current folder is assigned.

To remove a business area from the current folder, move the business area from the Current business areas list to the Available business areas list.

Notes

You can select more than one business area at a time by holding down the Ctrl key and clicking another business area.

Manage Folders dialog: Orphaned Folders tab

Use this tab to view or delete orphaned folders from the current EUL. Orphaned folders are folders that are not owned by any business areas.

For more information, see:

"How to remove an orphaned folder from the EUL"

Orphaned Folders

This list displays all orphaned folders in the current EUL.

Delete

Use this button to delete a highlighted orphaned folder from the current EUL.

Notes

You can select more than one orphaned folder at a time by holding down the Ctrl key and clicking another orphaned folder.

Manage Scheduled Workbooks dialog

Use this dialog to monitor and maintain workbooks that Discoverer end users have scheduled. For example, you might want to check on the progress of a workbook being processed, or to remove a scheduled workbook that was created by a Discoverer end user but is no longer required.

For more information, see:

"What are workbooks and scheduled workbooks?"

Show workbooks for

Use the Select button next to this field to display the "Select User/Role dialog" where you can search for and select the user or role whose scheduled workbooks you want to view or edit. For example, choose jchan to display the scheduled workbooks for jchan.

Select all users

Use this check box to display scheduled workbooks for all users.

Scheduled workbooks

This field displays a list of the scheduled workbooks that are owned by the selected user or role. The workbooks listed are either scheduled to run or have already run and are ready to use. The list contains the following fields:

User

This column displays the name of the Discoverer user who scheduled the workbook.
Name

This column displays the name of the scheduled workbook.

Status

This column displays the status of the workbook. Refer to the table below for details about the status of a workbook.

Status	Description:
Scheduled	This workbook has been scheduled and will run at the specified date and time.
Running Query	This workbook is currently running. No results are available.
Could not schedule	This workbook was not successfully submitted to the processing job queue. It is a good idea to let the Discoverer end user know so they can attempt to reschedule this workbook.
Error while running query	There was an error when this workbook was run. No results were returned from the database. This could be due to a problem in the PL/SQL generation or execution. An Oracle database error is generated here and can be accessed by the database administrator. If part of a scheduled workbook fails (i.e. one sheet out of the workbook), the entire scheduled workbook run fails.
Report deleted by Administrator	The Discoverer manager has set the scheduled workbook for deletion. Report runs with this status are deleted when the user next disconnects from the EUL.
EUL has changed, reschedule report	A change has occurred in the EUL which affects the scheduled workbook. For example, if a folder has been deleted. The user can resubmit the scheduled workbook.
Number of Rows Limit exceeded	The results of this scheduled workbook return more rows than this user is allowed to retrieve. The results have been deleted. Use the "Privileges dialog: Query Governor tab" to change this limit.
Report Expired	The expiration date has passed. This workbook is no longer available. Reports with this status are deleted when the user disconnects from the EUL.
Report Ready	This workbook successfully queried the database and users can view the results.

Date

This column displays the date on which the workbook is next scheduled to run (if the workbook's status is Scheduled) or when the workbook was last run (if the workbook's status is Report Ready).
Time

This column displays the time at which the workbook is next scheduled to run (if the status is Scheduled) or was last run (if the status is Report Ready).
Run time

This column displays the length of time this workbook took to run.

Description

This read-only field displays any additional information about the selected workbook.

Edit

Use this button to display the "Schedule Workbook dialog: General tab", where you change the settings for the selected workbook. This option is only available for workbooks that have not yet been processed.

View Error

Use this button to display a description of why a selected workbook could not be run successfully. This option is only available for workbooks that could not be scheduled due to an error.

Unschedule/Delete

Use this button to un-schedule the workbook and remove the workbook from the list in the Scheduled workbooks field. Any workbooks resulting from previous runs of this workbook are removed.

Refresh

Use this button to check the database for any changes to the schedule since you opened this dialog.

Notes

You can re-sort the Scheduled Workbooks list by clicking the column you want to sort by. For example, if you want the list sorted by date, click the Date column header.

Matching Values dialog

Discoverer displays this dialog when you are defining an indexed item for an item in a folder, and Discoverer has determined that the list of values (LOV) associated with the indexed item in the current folder is created on another item (i.e. either in the current folder, or in another folder).

Use this dialog to confirm that the list of values (LOV) associated with the indexed item in the current folder exactly matches another LOV in another folder.

For more information, see "How to assign an indexed item to an item".

Use this button if you are sure that the values of the items referred to in this dialog, exactly match each other.

Note: If you use the OK button but the values of the items displayed in the Matching Values dialog do not exactly match each other, results returned when parameters are used in conditions might be incorrect.

Notes

A LOV (item class) contains values that are generated from a single item but which can be applied to multiple items in multiple folders (for more information, see "What are item classes?"). When Discoverer determines that the LOV (item class) to be used by the indexed item can be based on another item, Discoverer asks you to confirm that the values in the item class exactly match the unique values in the indexed item.
The items whose values you are matching must be of the same datatype. For example, you cannot match a date LOV (i.e. a Date datatype) with a city name LOV (i.e. a Varchar datatype), or a Days of the Week LOV (i.e. a varchar datatype) with a date LOV (i.e. a Date datatype).

New Condition dialog (Advanced)

Use this dialog to create a new condition for use in the business area.

For more information, see:

"What are the different types of condition?"

"How to create simple conditions"

"How to create advanced conditions"

Advanced conditions contain multiple criteria. For example:

to restrict Discoverer end users to data for the year 2001 in the first quarter, you might create a mandatory condition here: Year = 2001 AND Quarter = Q1. When they access workbooks, Discoverer end users will always see data for the year 2001 in the first quarter.
to enable Discoverer end users to easily look at data for different quarters in the year 2001, you might create the optional conditions:
- Year = 2001 AND Quarter = Q1
- Year = 2001 AND Quarter = Q2
- Year = 2001 AND Quarter = Q3
- Year = 2001 AND Quarter = Q4
When they access workbooks, Discoverer end users will be able to focus on data for particular quarters in the year 2001 by applying these conditions.

Name

Use this field to enter a name for the new condition.

Generate name automatically

Select this check box for Discoverer to create a name for you.

Clear this check box to enable the Name field and enter a condition name.

Description

Use this field to enter additional information about the condition. This description is displayed when you select this condition in the Workarea, and in Discoverer Plus. Make your description useful to both you and your users.

Location

This field displays the name of the folder that will store the condition. This is the location you selected when you chose Insert | Condition.

Type

Use this drop down list to choose the condition type:

Mandatory

Mandatory conditions are always applied to a worksheet that contains one or more items from the folder that contains the condition. Discoverer Plus users are not notified of mandatory conditions and can not turn them off.
Optional

Optional conditions can be turned on or off as required by Discoverer Plus users.

Formula

Use this field to specify the filter criterion that you want to use.

Item

Use this drop down list to choose what item you want to filter the data on. For example, choose Year here if you want to display data for a particular year.
Condition

Use this drop down list to choose how to match data against the item. For example, choose the '>' symbol (greater than) here to filter data where the item value is greater than a particular number.
Value(s)

Use this field to define what data you want to match against. For example, enter 2001 here to look only at data for the year 2001.

If you created a list of values for the item, these items appear in the drop down list.

You can also click the drop down list and match against the following:
- Click Select Multiple Values to display the "Values dialog".
  
  You select one or more values to use in the condition.
- Click Create Calculation to display the "New Item dialog".
  
  You create a calculated item to use in the condition.
- Use the Select Item option to display the "Items dialog".
  
  You select an item to use in the condition.
Note: You can enter up to 254 values in this field. If you want to enter more than 254 values in the condition, use the OR option to add a new condition statement line for the extra values.

Match case

Use this check box to match upper and lower case text data exactly. When selected, the match value 'New York' would not return data for 'new york'.

Advanced

Use this button to add one or more new criteria lines to the condition. Use this button to display the Add, Delete, And, Or and Not buttons.

Add

Use this button to insert a new criterion line to the condition. By default, the new item is grouped with a logical AND, which means that data must match all criteria contained within the AND group.

Delete

Use this button to remove the currently selected filter criterion from the condition.

And

Use this button to insert a new criterion line to the condition. The new item is grouped with a logical AND, which means that data must match all criteria contained within the AND group.

Use this button to insert a new criterion line to the condition. The new item is grouped with a logical OR, which means that data much match at least one of the criteria contained within the OR group.

Not

Use this button to invert the condition for the currently selected group. The item is grouped with a logical NOT AND or NOT OR, which means that data must not match the criteria contained with the NOT group.

Notes

The buttons Delete, And, and Or are only available if you have selected a criteria in the Formula display.

New Condition dialog (select an item or folder for)

Use this dialog to choose where you want to store the new condition.

For more information, see:

"What are the different types of condition?"

"How to create simple conditions"

"How to create advanced conditions"

For example, if you do not select a folder before choosing Insert ¦ Condition, you select a folder here.

This dialog is also displayed as:

New Condition dialog

Business Area

Use this drop down list to select a business area. Then, choose the folder in which to store the condition from the expandable item list below.

New/Edit Condition dialog

Use this dialog to create a new condition, or edit a condition in the business area.

This dialog is also displayed as:

New Condition dialog

Edit Condition dialog

For more information, see:

"What are the different types of condition?"

"How to create simple conditions"

"How to create advanced conditions"

Simple conditions typically contain one filter criterion. For example:

to restrict Discoverer end users to data for the year 2001, you might create a mandatory condition here: Year = 2001. When they access workbooks, Discoverer end users will always see data for the year 2001
to enable Discoverer end users to easily look at data for different quarters, you might create the optional conditions:
- Quarter = Q1
- Quarter = Q2
- Quarter = Q3
- Quarter = Q4
When they access workbooks, Discoverer end users will be able to focus on data for particular quarters by applying these conditions.

Name

Use this field to enter a name for the new condition.

Generate name automatically

Select this check box for Discoverer to create a name for you.

Clear this check box to enter a name for this condition.

Description

Location

This field displays the name of the folder that will store the condition. This is the location you selected when you chose Insert | Condition.

Type

Use this drop down list to choose the condition type:

Mandatory - mandatory conditions are always applied to a worksheet that contains one or more items from the folder that contains the condition. Discoverer Plus users are not notified of mandatory conditions and can not turn them off.
Optional - optional conditions can be turned on or off as required by Discoverer Plus users.

Formula

Use this field to specify the filter criterion that you want to use.

Item

Use this drop down list to choose what item you want to filter the data on. For example, choose Year here if you want to display data for a particular year.
Condition

Use this drop down list to choose how to match data against the item. For example, choose the greater than symbol (>) here to filter data where the item value is greater than a particular number.
Value(s)

Use this field to define what data you want to match against. For example, enter 2001 here to look only at data for the year 2001.

If you created a list of values for the item, these items appear in the drop down list.

You can also click the drop down list and match against the following:
- Click Select Multiple Values to display the "Values dialog".
  
  You select one or more values to use in the condition.
- Click Create Calculation to display the "New Item dialog".
  
  You create a calculated item to use in the condition.
- Use the Select Item option to display the "Items dialog".
  
  You select an item to use in the condition.
Note: You can enter up to 254 values in this field. If you want to enter more than 254 values in the condition, click Advanced and use the OR option to add a new condition statement line for the extra values.

Match case

Use this check box to match upper and lower case text data exactly. When selected, the match value 'New York' would not return data for 'new york'.

Advanced

Use this button when you want to create more than one filter criterion. Here, you display additional fields and buttons used to create advanced conditions (see "New Condition dialog (Advanced)").

New Date Format dialog

Use this dialog to create a new date format. For example, you might want to create a new format for Year containing the last two digits only of a typical four digit year (e.g. to display the digits 01 to represent 2001, 02 to represent 2002 and so on).

You can use the new format in date hierarchies.

For more information, see:

"What are date hierarchies?"

"What are date items?"

"What are date format masks?"

Date format group

Use this drop down list to choose the group in which you want the new date format to be included (e.g. Year, Quarter, Month).

New Format

Use this field to enter the date format mask that you want to use. For example, use Mon-YYYY to display the month plus the four digits of the year.

Notes

A new date format must confirm to the SQL Date Format Model, for example YYYY, YYY, YY, RR etc.
You can prefix a new Date Format with descriptive text by enclosing the descriptive text in quotes (e.g. "Fiscal Year" YYYY).

New Item dialog

Use this dialog to create items based on EUL objects and/or functions. Items can be derived items, aggregate calculated items or aggregate derived items.

For more information, see:

"What are calculated items?"

"How to create calculated items"

For example:

to create an item named Year, based on the EUL item Calendar Year
to create a calculated item named Sales Target, based on the formula Sales SUM * 1.25
to create a calculated item named Profit, based on the formula Sales SUM - Cost SUM
to create a calculated item named Rank Sales, based on the formula RANK () OVER (ORDER BY Sales SUM)

Show

Use these radio buttons to display calculations, functions, and item that you can use to build a calculation. To include items in the calculation, paste them into the Calculation field.

Items

Use this radio button to display the EUL items available.
Functions

Use this radio button display the functions available.

Paste

Use this button to the add the item currently selected in the Show list to the Calculation. The item is copied into the Calculation field.

Name

Use this field to enter a name for the item or calculated item. Discoverer Administrator creates a default name for you.

Calculation

Use this field to enter the calculation details (for calculation examples, see Oracle Business Intelligence Discoverer Plus User's Guide).

To create a calculation, you can use any or all of the following methods:

Type the formula directly into the Calculation field.

Note: If you type an expression in the Calculation field, you must prefix the expression with an equals sign (i.e. =). For example, '=Sales SUM-Costs SUM'.
Paste items and functions from the Show field on the left into the calculation.
Click the operator buttons underneath the Calculation field to use them in the calculation.

Operator buttons + - x / % ( )

Use these buttons to add operators to the calculation. Operators are copied into the Calculation field.

Use this button to validate and save the calculation, as follows:

If the calculation has valid syntax, the calculation is saved and displayed in the Calculations dialog.
If the calculation has invalid syntax, an error message is displayed. You must correct any syntax errors before you can save the calculation.

Notes

The table below shows the functions available in the field beneath the Show field:

Category	Description
All Functions	An alphabetical list of all functions.
Analytic	Advanced statistical analysis, such as RANK, NTILE, CORR.
Conversion	Converting from one data type to another, such as: RAWTOHEX, TO_CHAR, TO_DATE.
Database	Optional category that is displayed when user defined functions are available (created using the Register PL/SQL Functions facility on the Tools menu).
Date	Manipulating date items such as ADD_MONTHS, NEW_TIME, SYSDATE and NEXTDATE.
Group	Aggregate and statistical functions including SUM, COUNT, MAX, MIN, VARIANCE.
Numeric	Numeric items, transcendentals and floating point such as COS, LOG, MOD, POWER.
Others	Miscellaneous functions such as LEAST, USER, DECODE, ROWNUM.
String	Character items, text operations such as INITCAP, LPAD, NLS_UPPER.

For detailed information about all functions available in Discoverer, see the Oracle Database SQL Reference Guide and Oracle Database Data Warehousing Guide.
For examples of the most commonly used functions, see Oracle Business Intelligence Discoverer Plus User's Guide.

New Item dialog (select a folder for)

Use this dialog to choose where you want to store the new item. For example, if you do not select a folder before choosing Insert ¦ Item, you select a folder here.

Discoverer displays this dialog when the currently selected folder does not use the item that you are about to create.

This dialog is also displayed as:

New Item dialog

For more information, see:

Business Area

Use this drop down list to select a business area, then choose the folder in which to store the item from the expandable item list below.

New Join dialog (select a folder for)

Use this dialog to choose where you want to store the new join. For example, if you do not select a folder before choosing Insert ¦ Join, you select a folder here.

The Choose Folder window might appear in any of the following cases:

The currently selected folder does not use the join you are about to create.
No folder is selected on the Workarea.

This dialog is also displayed as:

New Join dialog

For more information, see:

"How to create joins"

Business Area

Use this drop down list to select a business area. Then, choose the folder in which to store the join from the expandable item list below.

Online Dictionary Options dialog

Use this dialog to specify what types of tables and views you want to see in the "Load Wizard: Step 2 dialog". For example, you can display all tables and views accessible to a user, not just those owned by a user.

For more information, see:

Which tables (and views) do you want to see?

Tables owned by user

Use this radio button to make available tables and views that belong to the user IDs specified in "Load Wizard: Step 2 dialog".

Choose this option:
- When you have a schema, and you want to load tables or objects based on the schema permissions.
- When you have a schema owner, and you want to load tables or objects based on the schema grants. For example, an owner such as FINAPPS, who owns all of the data tables used by the Financial Applications system and has granted access rights to other users to view those tables.
Tables accessible by user

Use this radio button to make available tables and views to which the user IDs have been granted SELECT access in the database.

What types of tables (and views) do you want to see?

Public tables

Select this check box to import tables and views in the selected user IDs' schema that have been granted public access. For example, JOE is seeing publicly accessible tables.
Partially restricted tables

Select this check box to import the tables and views in the selected user IDs' schema that have also been granted some access to another user ID. For example, user ID Bob could grant SELECT privileges on Table D in the database to user ID Betty. Table D would be designated as a partial access object. Use this option to display a list of partial access objects that are either owned by a user ID or objects to which the user ID has been given explicit SELECT access. For example, JOE has been granted specific access to these tables.
Private tables

Select this check box to import the tables and views in the selected user IDs' schema that are not accessible by any other user ID.

Notes

A user ID can own tables and also grant access to other user IDs. For example, an application owner, such as FINAPPS, owns all of the data tables used by the Financial Applications system and has granted access rights to other users to view those tables.

Open Business Area dialog

Use this dialog to specify which business areas you want to open in the Discoverer Administrator Workarea. For example, you might want to work with your own business area and the Video Stores Tutorial business area.

For more information, see:

"Loading from the online dictionary"

"Loading from a Gateway"

Available

This list displays business areas that are available. To open business areas, move the business areas from the Available list to the Selected list.

Selected

This list contains the business areas that will open in the Workarea. If you do not want to open business areas in this list, move these business areas from the Selected list to the Available list.

Notes

You can select more than one business area by pressing the Ctrl key and clicking another business area.
You cannot open the same business area twice. If you select a business area that is already open in the Workarea, the Open command will have no effect. To see another view of the same business area, choose New Window from the Window menu to display another Workarea window.

Options dialog: Connection tab

Use this dialog to specify the connection details to display in the "Connect dialog". For example, if you always connect to Oracle Applications EULs, you might configure the Connect dialog to prompt you to enter Oracle Applications connection details.

For more information, see:

"How to start Discoverer Administrator"

"Options dialog: Default EUL tab"

What type of EULs would you like to connect to?

Connect to standard EULs

Use this radio button when you only want to connect to standard EULs using Discoverer Administrator.

If you select this radio button, the Oracle Applications User check box is not displayed in the Connect dialog.
Connect to applications EULs

Use this radio button if you only want to connect to Oracle Applications EULs using Discoverer Administrator.

If you select this radio button, the Oracle Applications User check box is not displayed in the Connect dialog, but you must login using your Oracle Applications user ID and Responsibility.

Note that if you select this check box, you can only log in to Oracle Applications EULs.
Connect to both standard and applications EULs

Use this radio button when you want to be able to connect to both standard and Oracle Applications EULs using Discoverer Administrator.

If you select this radio button, the Oracle Applications User check box is displayed in the Connect dialog and allows you to:
- connect to Oracle Applications EULs by selecting the check box and specifying Oracle Applications connection details
- connect to standard EULs by clearing the check box and specifying standard database user details

Applications EUL Settings

Use these fields with an Oracle Applications EUL. Discoverer Administrator uses default values for both these fields if you do not enter any values.

Gateway User ID (GWYUID) / password

Use this field to specify the user name and password of the public Gateway (i.e. identified by the Gateway User ID/password) that Discoverer Administrator is to use when logging in to an Oracle Applications EUL. Use the forward slash (/) character to separate the user name and password.

You enter a Gateway User ID to override the default values (APPLSYSPUB/PUB) that Discoverer uses.

If you do not specify a Gateway User ID and password, Discoverer Administrator will use the default values specified above.

Foundation Name (FNDNAM)

Use this field to specify the FND schema that owns the core Oracle Applications tables and views.

Enter a Foundation Name to override the default value (APPS) that Discoverer uses.

If you do not specify a Foundation Name, Discoverer Administrator will use the default value specified above.

Notes

The default values for the Gateway User ID/password and Foundation Name for Discoverer Administrator, are defined in the Windows Registry. For more information, see "About Discoverer Administrator and Discoverer Desktop registry settings".

Options dialog: Default EUL tab

Use this dialog to specify the default EUL to connect to when you start Discoverer Administrator.

For more information, see:

"How to start Discoverer Administrator"

"Options dialog: Connection tab"

Which EUL would you like as your default?

Select a default EUL:

Use this field to choose which EUL you want to connect to by default when you start Discoverer Administrator. When you next connect to Discoverer Administrator, the Load Wizard will display business areas from the EUL that you chose here.

Notes

If you want to create new EULs, you must have write access to the default EUL that you specify here. If you do not have write access to the default EUL, the Create business area option will not be available in the Load Wizard. For more information, see "What are the data access prerequisites?" and "About Discoverer access permissions".

Options dialog: Query Governor tab

Use this dialog to specify the time that Discoverer Administrator or Discoverer Desktop waits for a query to return its data before displaying an error message. This setting might be useful for example, when you try to expand a long list of values (LOV) and Discoverer displays an error message before the LOV can be displayed. If you increase the value of this setting, Discoverer has more time to display the list of values before displaying the error message.

For more information, see:

"What are lists of values?"

"How to view the list of values for an item"

"Options dialog: Connection tab"

"Options dialog: Default EUL tab"

Cancel value retrieved after:

Use this field to define the maximum time (in seconds) you want to wait while Discoverer retrieves list of values items.

Note: This tab is displayed only if the user is connected to a database

PL/SQL Functions dialog: Arguments tab

Use this dialog to define arguments for PL/SQL functions that are registered.

You can register PL/SQL functions that have been defined in the database, using SQL commands.

For more information, see:

"Why do you need PL/SQL functions?"

Functions

This field displays Oracle-supplied PL/SQL functions and user-defined PL/SQL functions that have already been registered for use with Discoverer Administrator.

Arguments

This field displays a list of arguments defined for the function currently selected in the Functions field.

New

Use this button to create a new argument. Discoverer generates a default argument name and fields are initialized with default values. You can then edit the default values to configure the new argument as required.

Delete

Use this button to delete the currently selected argument. The argument is removed from the Arguments field.

Move Up/Move Down

Use these buttons to rearrange the list of arguments in the Arguments field. This is useful if an argument is out of place ordinally, or if the function itself has been modified and you need to update the function definition.

Attributes for <argument selected in Arguments field>

This area displays information about the selected PL/SQL function.

Name

Use this field to enter the argument name. When you add an argument, a default name is created by Discoverer Administrator.

Description

Use this field to enter additional information about the argument. When you add an argument, a default description is created by Discoverer Administrator.

Data Type

Use the drop down list to specify the argument data type for this field (the default is Number).

Identifier

Use this field to change the unique name that Discoverer uses to identify EUL and workbook objects.

Usage

Optional

Use this radio button when the argument is an optional argument to the function.
Required

Use this radio button when the argument is a mandatory argument to the function.

Notes

This dialog becomes read-only if the current user does not have the Create/Edit Business Area privilege (for more information, see "Privileges dialog: Privileges tab").
When a PL/SQL function contains an argument with a boolean data type, you can manually input the PL/SQL function only if the following conditions are met:
- the boolean argument has a default value defined for it (e.g. Arg1 on boolean:=TRUE)
- you select the Optional radio button

PL/SQL Functions dialog: Functions tab

Use this dialog to manage PL/SQL functions available to Discoverer Administrator. To register functions, you can:

import PL/SQL functions defined in the database (i.e. use the Import button)

This method is recommened because the function details are entered automatically once you select have selected a function to import.
enter PL/SQL function details manually (i.e. use the New button)

You might use this option if the list of functions in the database is very long, you want to reduce the search time by entering the function details yourself.

For more information, see:

"Why do you need PL/SQL functions?"

"How to register custom PL/SQL functions automatically"

"How to register custom PL/SQL functions manually"

Functions

This field displays a list of Oracle-supplied PL/SQL functions and user-defined PL/SQL functions that have already been registered for use with Discoverer Administrator. When the Available in Discoverer Plus check box is selected, these registered functions are also available to Discoverer end users to use in calculations.

Attributes for <function selected in Functions field>

This area displays information about the selected PL/SQL function.

Function Name

Use this field to enter a name for the function. The Function Name can be different from the Display Name.

Display Name

Use this field to enter a name for the function. This name will be visible in the Discoverer Administrator in the Edit Calculation window, and in Discoverer Plus if the Available in Discoverer Plus check box has been selected.

Owner

Use this field to enter the user ID of the owner of the function. Changing this value enables you to move the reference from a development environment to a production environment.

Package

Use this field to enter the package that contains this function. A package is used in the Oracle database to group many functions together by category for easier management.

Database Link

Use this drop down list to select the database that stores the function. This is a particularly useful feature if you are using distributed databases.

Return Type

Use this drop down list to enter the data type of the data returned by the function. For example, a function might return a character string (char) or a number.

Description

Use this field to enter additional information about the function.

Identifier

Available in Discoverer Plus

Use this check box to enable Discoverer end users to use this function in calculations.

Validate

Use this button to test the validity and accuracy of the information you have entered. The Discoverer Administrator generates a test SQL statement that includes the PL/SQL function and tests the query. This test validates the existence of the function (i.e. by properly naming and locating it), its owner, and tests the data return type.

New

Use this button to register a new PL/SQL function. A default function name is generated and fields are initialized with default values. You can then edit the default values to configure the new function as required.

Delete

Use this button to remove the PL/SQL function currently selected in the Functions field.

Import

Use this button to display the "Import PL/SQL Functions dialog", where you search for and select the PL/SQL functions (defined in the database) that you want to import. Once you have imported PL/SQL functions, you register them so that Discoverer Administrator can use them. For more information, see "How to register custom PL/SQL functions automatically".

Notes

This dialog becomes read-only if the current user does not have the Create/Edit Business Area privilege (for more information, see "Privileges dialog: Privileges tab").

Privileges dialog: Privileges tab

Use this tab to grant privileges to users or roles (role is replaced with responsibility for Oracle Applications users). For example, you can enable Discoverer Plus and Discoverer Desktop end users to create and edit queries, drill down, and drill out, but prevent them from saving workbooks to the database.

For more information, see:

"About Discoverer and security"

Show privileges for

Use the Select button next to this field to display the "Select User/Role dialog" where you can search for and select the user or role whose privileges you want to change. For example, choose jchan to display the privileges for jchan in the Administration Privilege and Desktop and Plus Privilege fields.

Administration Privilege

Use this check box to grant or revoke the ability of the currently selected user or role to use Discoverer Administrator.

Desktop and Plus Privilege

Use this check box to grant or revoke the ability of the currently selected user or role to use Discoverer Desktop and Discoverer Plus.

Use the check boxes in the fields under the Administration Privilege and Desktop and Plus Privilege check boxes, to grant or revoke privileges to the currently selected user or role as follows:

To grant Discoverer Administrator privileges, select individual privileges in the group under the Administration Privilege check box. These privileges apply to Discoverer Administrator.
To grant Discoverer Desktop and Discoverer Plus privileges, select individual privileges in the group under the Desktop and Plus Privilege check box. These privileges apply to Discoverer Desktop and Discoverer Plus.

This field displays a brief description about the currently selected privilege.

Select an Oracle system profile

Use this drop down list to specify an Oracle system profile to apply to the user. This allows you to apply pre-defined sets of privileges to users and roles.

system profiles are Oracle-specific
if you selected a database role or an Oracle Applications responsibility in the Show privileges for field, this field is grayed out

Notes

If your current user ID does not have access to the table DBA_ROLES, only a subset of roles and responsibilities might be visible in the "Select User/Role dialog".

Administration privilege types available:

Privilege Name	Description
Administration Privilege	Granting this privilege allows the user or role to log in to Discoverer Administrator. Note that to allow the user to access the features in Discoverer Administrator, you must select individual Administration features (privileges) listed below this privilege. This check box must be selected in order to grant any of the privileges listed below.
Format Business Area	Granting this privilege allows the user or role to edit formatting information in an existing business area to which they have access. Such formatting information includes folders, summary folders, joins, and items. Granting this privilege allows the user or role to specify names, descriptions, default format masks and placement.
Create/Edit Business Areas	Granting this privilege allows the user or role to create and modify business areas, folders, summary folders, joins, calculations, conditions, hierarchies and item classes.
Create/Edit Summaries	Granting this privilege allows the user or role to create summary folders through Discoverer Administrator. Also requires database resource privileges.
Set Privilege	Granting this privilege allows the user to maintain and modify user privileges using this dialog box. Note: You cannot grant this privilege to a role.
Manage Scheduled Workbooks	Granting this privilege allows the user or role to monitor and maintain the schedule for scheduled workbooks.

Desktop and Plus privilege types available:

Privilege Name	Description
Desktop and Plus Privilege	Granting this privilege allows the user or role to log in to Discoverer Desktop and Discoverer Plus. Note that to allow the user to access the features in Discoverer Desktop and Discoverer Plus, you must select individual Desktop features (privileges) listed below this privilege.This check box must be selected in order to grant any of the privileges listed below.
Create/Edit Query	Granting this privilege allows the user or role to create new worksheets (queries) and modify existing ones. Without this privilege, the user can only open and run existing (predefined) workbooks and worksheets.
Collect Query Statistics	Granting this privilege saves performance statistics when this user runs worksheets/workbooks (queries).If you clear this check box query prediction estimates might be less accurate. For more information, see "Predicting query performance".
Item Drill	Granting this privilege allows the user or role to drill to detail and related information in the worksheet. In addition to granting this privilege, you must create the drill using the Item Class wizard before the user will be able to use this function.
Drill Out	Granting this privilege allows the user or role to launch another application to see related information by drilling on an item in the worksheet. In addition to granting this privilege, you must create the drill using the Item Class wizard before the user will be able to use this function, or have items with the Content Type set to <FILE>.
Grant Workbook	Granting this privilege allows the user or role to grant access to their workbooks so other users can run and view them.
Schedule Workbooks	Granting this privilege, allows the user to schedule a workbook to run at a later time and at regular intervals (i.e., daily, weekly, monthly). Note: You cannot grant this privilege to a role.
Save Workbooks to Database	Granting this privilege allows the user or role to save the workbooks they create in the database. By default, Discoverer Desktop workbooks are saved on the user's hard drive.
Change Password	Note: This privilege is not used in this release.
Create Link	Granting this privilege enables Discoverer end user to create their own drill links. A drill link is a way to access another worksheet or URL from a particular worksheet cell value.

Privileges dialog: Query Governor tab

Use this tab to view and edit the query configuration for a specified user or role (role is replaced by responsibility for Oracle Applications users). For example, to limit the number of rows that can be retrieved for the user jchan.

For more information, see:

"Controlling access to information"

Show query limits for

Use the Select button next to this field to display the "Select User/Role dialog" where you can search for and select the user or role whose query limits you want to change. For example, choose jchan to display the query limit settings for jchan in the Query Governor area.

Query Governor

Warn user if predicted time exceeds... Seconds:

Select this check box to display a warning to the Discoverer end user if a query takes longer than the amount of time specified.

This privilege is only available when using an Oracle database.

Prevent queries from running longer than... Minutes:

Select this check box to limit the query time for the selected user.

Limit retrieved data to... Rows:

Select this check box to limit the number of rows a users query can return. The limit you set here is a maximum. The end user can set a limit that is lower. When a query has reached the maximum number of records set by you or the end user, the query stops and the data retrieved so far is returned to the end user. For example, if the check box is selected and the value 1000 is entered, only the first 1000 rows of a query are displayed on a Discoverer end user worksheet.

Clear this check box for Discoverer to attempt to retrieve all rows in a query. Note that for performance reasons, it is not recommended that you clear this check box when queries might return hundreds of thousands of rows or more.

Privileges dialog: Scheduled Workbooks tab

Use this tab to specify scheduled workbook settings for a specified user or role (role is replaced by responsibility for Oracle Applications users). For example, to limit the number of workbooks that a user can schedule, or to define the expiry date of scheduled workbooks.

For more information, see:

"Scheduling workbooks"

"About Discoverer and security"

"How to set scheduled workbook limits"

Show scheduling limits for

Use the Select button next to this field to display the "Select User/Role dialog" where you can search for and select the user or role whose scheduling limits you want to change. For example, choose jchan to display the scheduled workbook settings for jchan.

Note: If you select a user or role that does not have schedule workbook privileges, the configuration details are disabled. If you want the user or role to have this privilege, see "How to specify a user or role (responsibility) to perform a specific task":

Select the user to own the tables which store any workbook results

Use this drop down list to select the user name of the database user that will own the scheduled workbooks tables.

Use these radio buttons to specify if or when a user is required to schedule workbooks.

User must always schedule workbooks

Use this radio button for a Discoverer end user only to run queries using the scheduled workbooks facility.
User is never required to schedule workbooks

Use this radio button to enable users to choose whether or not they want to run queries using the scheduled workbooks facility.
Schedule only if predicted time exceeds (HH:MM:SS)

Use this radio button for users to schedule workbooks if the predicted time to run the query exceeds the value specified in the Time field. The maximum value that you can enter here is 23:59:59.

Limit number of scheduled workbooks

Use this check box to specify the maximum number of workbooks that a user can schedule.

Note: This option enables you to prevent users from submitting so many scheduled workbooks that no other jobs on the DBMS_JOB queue can run

Expire results

Use this check box to limit the lifetime of scheduled workbook results (days). Results due for deletion are deleted when the user disconnects from the EUL.

Commit size

Use this check box to specify the number of rows that are committed to the result table at a time, when Discoverer processes the scheduled workbook. For example, if 1000 rows need to be written and the Commit size is 100, 10 writes are performed. On large result sets, server performance is improved by setting the commit size higher than the default (although little gain will be achieved by setting the Commit size higher than 1000).

Restrict the hours during which a workbook may be scheduled

Use this check box to specify when a user can schedule workbooks. This could be exploited to prevent users from scheduling workbooks at peak times.

Privileges dialog: User/Role tab

Use this tab to configure specific privileges for users and roles. For example:

to look at which users and roles have Administration privileges
to check that a group of roles have the Save Workbooks to Database privilege
to revoke drill out privileges for specified users

Note that Oracle Applications users have responsibilities instead of roles.

For more information, see:

"About Discoverer and security"

"How to specify a user or role (responsibility) to perform a specific task"

Show users/roles with privilege

User this drop down list to choose a privilege that you want to look at. For example, choose Save Workbooks to Database to display the users and roles that have this privilege in the Show field.

Users

Use this check box to look at user privileges.

Roles

Use this check box to look at role privileges. This option is only available when you are using an Oracle database.

Show: (Users/Roles list)

This field displays all users and roles and whether they have the currently selected privilege. A privilege is applied to a user or role when the check box next to the user or role is selected. The list is updated when you select a new privilege in the Show users/roles with privilege field.

To grant a privilege, select the check box next to the user or role that requires the currently selected privilege.
To revoke a privilege, clear the check box next to the user or role that does not require the currently selected privilege.

Privilege Description

This field displays additional information about the currently selected privilege.

Properties dialogs

Choose one of the following help topics:

"Business Area Properties dialog"
"Condition Properties dialog"
"Folder Properties dialog"
"Item Properties dialog"
"Join Properties dialog"
"Summary Properties dialog"

Refresh Business Area dialog

Use this dialog to look at differences that have been found between the folders and items in the current business area and source tables in the database to which they link. For example, if a new primary key has been detected in the source database, you can use this dialog to correct this in the business area and continue the refresh. You can also assess the impact that changes will have on other objects in the business area.

For more information, see:

"Creating and maintaining business areas"

"How to synchronize a business area with the database"

Name

This field displays the name of the item that is different.

Type

This field displays the type of change that has occurred. For example, the source table has a new foreign key.

Actions

This field displays the effect that completing the refresh will have on the object and the check box enables you to switch the action on or off.

Use this button to start the refresh using the options selected.

Impact

Use this button to display the "Impact dialog". The Impact dialog displays a list of objects that will be affected or removed if you refresh this business area.

Refresh Summaries dialog

Use this dialog to refresh the currently selected summary folder. For Oracle Enterprise Edition databases you can also specify an incremental refresh if available (for more information, see the Oracle Database Data Warehousing Guide for conditions).

For more information about refreshing summary folders, see:

"How does ASM work?"

"Why must you refresh summary data?"

"What happens when a summary folder is refreshed?"

When would you like to refresh this summary?

Refresh the summary immediately

Use this radio button to refresh the selected summary folder immediately. Refresh will begin after clicking OK.

This option is useful when you have smaller materialized views or summary tables, or when you need to refresh the summary folder right away, without relying on the scheduling capabilities of the database server. Discoverer Administrator displays a progress bar enabling you to monitor the refresh.
Schedule the refresh at a later time

Use this radio button to enable the Date and Time fields where you can use the arrow buttons or type into the fields to select a later date and time when you want the refresh to occur.

This option submits a job to the queue using DBMS_JOB and immediately returns you to Discoverer Administrator (rather than waiting for the refresh to be complete) enabling you to continue working. This option is useful when you have larger materialized views or summary tables, which are best built during off-peak hours.

Perform Incremental refresh

Select this check box to perform an incremental refresh, available against Oracle Enterprise Edition databases only.

An incremental refresh is faster than a full refresh as it incrementally adds the new data that has been inserted into the tables.

During a summary folder refresh with Oracle Standard Edition databases a full table scan is carried out.

Clear this check box to refresh the summary using a full table scan.

Notes

The length of time taken for the refresh to complete depends on the data volume and the current database engine load.
For further information on the conditions required for incremental refresh, please see Oracle database Data Warehousing Guide.

Refresh Wizard dialog

Use the Refresh Wizard to refresh business areas in the current End User Layer. For example, when you make modifications to the database, the refresh facility synchronizes the business area with the data dictionary, incorporating database modifications into the business area.

Refresh Wizard Step 1

Use this dialog to specify how you want a business area to be refreshed.

Refresh business areas from:

On line dictionary

Use this radio button to refresh the business area from the Oracle database tables on which the business area is based.
Gateway

Use this radio button to refresh the business area from the source that you select from the drop down list.

Finish

Use this button to start the refresh process from the online dictionary.

Notes

If you choose the Gateway check box, click Next to display the Refresh Wizard Step 2.

Refresh Wizard Step 2

Use this dialog to select the gateway application that you want to refresh from.

Select the application you want to refresh from

Use this drop down list to select the gateway application that you are using as the source for the current EUL.

Finish

Use this button to start the refresh process from the selected gateway application.

Repository Users dialog

There might be a single database user that all Discoverer end users can exploit, or different ones created for each database user. The advantage of having a single database user is that individual end users do not need additional privileges to process scheduled workbooks, but the disadvantage is that space quota is shared, and so could be exhausted by a single user. Having multiple repository users provides a greater degree of control.

Responsibilities dialog

Use this dialog to select an Oracle Applications responsibility with which to connect to an Oracle Applications EUL.

For more information, see:

"Using Discoverer with Oracle Applications"

Responsibility list

Use this drop down list to select the responsibility that you want to connect to the database with.

Use this button to connect to the database as the selected responsibility.

Schedule Workbook dialog: General tab

Use this dialog to:

edit the description of a scheduled workbook
specify the interval between when Discoverer processes the scheduled workbook and when you want Discoverer to delete results automatically

For more information, see:

"Scheduling workbooks"

Name this scheduled workbook:

This read-only field displays the name of the scheduled workbook.

Description:

Use this field to enter additional information about the scheduled workbook. Discoverer end users will see this information when deciding which workbook to open.

Scheduled workbooks save results each time they run. Do you want to keep all versions of results?

Yes, keep all results

Use this radio button when you do not want to delete results sets when new results sets are created. For example, for a monthly report, do not delete the January and February results set when the March results set is created.
No, just keep the latest set of results

Use this radio button when you do want to delete old results sets when new results sets are created. For example, for a monthly report, delete the January results set when the February results set is created.

How long do you want to keep the results?

Delete results automatically after: _ days

Use this spin box to specify the interval in days between running this workbook and automatically deleting the workbook results. For example, you might want to delete the results set of a weekly report every seven days.

Parameters...

Use this button to display any parameters used in this scheduled workbook.

Scheduled Workbook dialog: Parameter values

Use this dialog to view parameter values required by worksheets. For example, a workbook might use the parameter '2001' when it is required to display data for the year 2001.

For more information, see the Oracle Business Intelligence Discoverer Plus User's Guide.

Parameter list

This area contains one or more fields in which you view the parameter values for the scheduled worksheet. Each field can also display a name.

Schedule Workbook dialog: Schedule tab

Use this dialog to specify when you want Discoverer to process the scheduled workbook. For example, you might want Discoverer to process a workbook at 1:00 a.m. every Sunday morning.

For more information, see:

"Scheduling workbooks"

Sheets included in the scheduled workbook:

Lists all the sheets included in the currently selected scheduled workbook.

Schedule this workbook on:

Use these fields to specify when you want Discoverer to process the scheduled workbook.

Time:

Use this spin box to specify the time at which you want Discoverer to process the scheduled workbook. The current time is displayed by default.

Date:

Use this spin box to specify the date on which you want Discoverer to process the scheduled workbook. The current date is displayed by default.

How often do you want to repeat this schedule?

Use these fields to specify how often you want Discoverer to process this scheduled workbook.

Never

Use this radio button when you want Discoverer to process a scheduled workbook only once. For example, for an occasional report requested by your manager.
Repeat every:

Use this radio button when you want Discoverer to process a scheduled workbook at regular intervals. For example, once per day or once per month.

Security dialog: Business Area - > User tab

Use this tab to grant or revoke multiple user access to a single business area. For example, to give a group of Discoverer end users access to the Video Store Tutorial business area so that users can use the sample data to learn about Discoverer Plus.

To grant a single user access to multiple business areas at once, use the "Security dialog: Users - > Business Area tab".

For more information, see:

"Controlling access to information"

Business area

Use this drop down list to select the business area to which you want to grant access. The drop down list displays business areas that you currently have open. If you cannot see the business area to which you want to grant access, reconnect to Discoverer and open that business area.

Available users/roles

Use this field to choose which users and roles you want to grant access to the selected business area. To grant access, move user names and roles from the Available users/roles field to the Selected users/roles field.

Selected users/roles

Use this field to see which users have access to the selected business area. To revoke access, move user names and roles from the Selected users/roles field to the Available users/roles field.

Show

Users

Use this check box to display Discoverer users in the Available users/roles field.

Roles

Use this check box to display Discoverer roles in the Available users/roles field.

Allow Administration

Use this check box to grant both access and administration rights to the users selected in the Selected users/roles field. The operations the user can perform on the granted business area depend on the user's Administration privileges.

Notes

Before displaying the folders in a business area, Discoverer checks if the user has database access to the tables referenced in the folders. If they don't have the necessary permission, Discoverer does not display the folders. You can override this check by changing the value of the ObjectsAlwaysAccessible registry setting (for more information, see ObjectsAlwaysAccessible in "Discoverer registry settings").
When logged in as an Oracle Applications user, the term Role is replaced with Responsibility.
You can select more than one user or role by pressing the Ctrl key and clicking another user or role.

Security dialog: Users - > Business Area tab

Use this tab to grant or revoke user access to multiple business areas. For example, to grant a new Discoverer end user access to a number of business areas in the End User Layer.

To grant multiple users access to a single business area, use the "Security dialog: Business Area - > User tab".

For more information, see:

"Controlling access to information"

User/Role

Use the Select button next to this field to display the "Select User/Role dialog" where you can search for and select the user or role that requires access.

Available business areas

Use this field to choose which business areas you want to grant access to the selected user or role. To grant access, move business areas from the Available business areas field to the Selected business areas field.

Selected business areas

Use this field to see which business areas the selected user or role has. To revoke access, move business areas from the Selected business areas field back to the Available business areas field.

Allow Administration

Use this check box to grant both access and administration rights on the selected business areas to the user selected.

Notes

Before displaying the folders in a business area, Discoverer checks if the user has database access to the tables referenced in the folders. If they don't have the necessary permission, Discoverer does not display the folders. You can override this check by changing the value of the ObjectsAlwaysAccessible registry setting (for more information, see ObjectsAlwaysAccessible in "Discoverer registry settings").
When connected to Discoverer as an Oracle Applications user, the term Role is replaced with the term Responsibility.
You can select more than one business area by pressing the Ctrl key and clicking another business area.

Select User/Role dialog

Use this dialog to search for and select the database user or role (or Oracle Applications responsibility) which you want to display privileges, query limits and scheduling limits. For example, to narrow your search you might want to list only database usernames that begin with the letter C.

This dialog is also displayed as:

Select User dialog

For more information, see:

"About Discoverer task privileges"

"Privileges dialog: Privileges tab"

"Privileges dialog: Query Governor tab"

"Privileges dialog: Scheduled Workbooks tab"

Search in

Use this drop down list to specify whether to search for users or roles (or Oracle Applications responsibilities).

Search by

Use this drop down list to specify how you want to match against the value that you type in the Search for field. For example, to find all database usernames starting with the letter T, choose Starts With and type T in the Search for field.

Search for

Use this field to enter the text that you want to search for. For example, to find all database usernames starting with the letter T, type T and choose Starts With from the Search by drop down list. You can also use the wildcards % and _. For example, if you enter the text N%, Discoverer Administrator will search for all usernames that start with the letter N. However, if you enter N_T, Discoverer Administrator will search for usernames that start with N and where the third letter of the username is T.

Case Sensitive

Use this check box to specify whether you want to match upper and lower case letters exactly when searching (e.g. when selected, the search term 'New York' would find 'New York', but would not find 'NEW YORK', 'new york', or 'new York').

Use this button to start the search according to the search criteria that you have specified and display matching values in the Results list below.

Use this button to start the search according to the search criteria that you have specified and display matching values in the Results list up to a maximum of 100,000 rows. The maximum number of rows displayed here is determined by the Registry setting MaxNumListRows (for more information, see "What are the Discoverer Administrator and Discoverer Desktop registry settings?").

If you click Go when the Search for field is empty, all users/roles specified by the Search In value are displayed.

Results

This list displays the results of the search. Use this list to select a database user (or role). Select a name in the list and click OK.

Notes

Discoverer displays an error message if the number of rows returned from a search exceeds 10,000 (for more information about changing this limit, see "What are the Discoverer Administrator and Discoverer Desktop registry settings?").

Summary Properties dialog

Use this dialog to view and configure properties for this summary folder. For example, to look at the status, or change the next refresh date for a summary folder.

For more information, see:

"What are summary folders?"

"What are Discoverer summary tables?"

"What are materialized views?"

"Why must you refresh summary data?"

Name

Use this field to enter a name for the summary folder.

Description

Use this field to enter a description for the summary folder.

Type

This read-only field indicates whether a summary folder is managed or external.

Managed summary folder

Managed summary folders have their data refreshed at intervals you specify. Managed summary folders can contain many summary combinations. Discoverer can create the materialized views required, and enables you to specify summary folder name, summary item names, and storage properties for summary folders you create. Alternatively you can pre-create the summary tables, and simply tell Discoverer the table owner and name.
External summary folder

External summary folders contain tables created by an application external to Discoverer. The column and item names might differ from those in Discoverer. With this option, you register each external table and map its columns to items in the End User Layer. You can specify that Discoverer takes over management of the external summary folder, so that Discoverer can populate the materialized view and refresh the summary folder.

Available for queries

Use this field to specify whether this summary folder can be used for worksheets run in Discoverer Plus. For example, when a Discoverer end user opens a worksheet that displays items from this summary folder Discoverer Plus might use the summary folder to display the worksheet results.

Status

This read-only field displays the current point in the life cycle of this summary folder. Only summary folders that have the status Complete, are available for queries.

The following list explains the meaning of values displayed in the Status field:

Pending

The summary refresh job is scheduled on DBMS_JOB queue, but has not yet started execution.
Under construction

The summary refresh job has started, and is inserting the rows into the materialized view.
Unusable

Discoverer has created a new summary a folder but has not yet refreshed it for the first time (Oracle Enterprise Edition databases).
Stale

The summary folder data is inconsistent with the detail data for a materialized view (Oracle Enterprise Edition databases).
Complete

The summary folder is complete and ready for use.
Failed

The summary refresh job fails and Oracle displays a database error.
Refresh Required

The end user must refresh the summary folder before it can be used. This normally happens only when the Discoverer manager has changed folder, item or join definitions in a way that requires the summary folder to be rebuilt. Discoverer displays the following reasons when refresh is required:
- Incompatible with database version
  
  The EUL definition of the materialized view is incompatible with the version of the database. This can occur if a database export/import of the EUL has occurred across database versions. For example, from an Oracle Standard Edition database to an Oracle Enterprise Edition database.
- EUL has changed
  
  Dependent EUL item has changed its definition. For example, the formula of an item used in the summary folder.
- Server has changed
  
  The definition of the materialized view in the database is inconsistent with the definition in the EUL (Oracle Enterprise Edition databases).
External

This summary folder is external and uses summary tables created in an application external to Discoverer.

Last refreshed

This read-only field displays the date when this summary folder last received up-to-date data from the database. This is only available for managed summary folders.

Next Refresh

Use this field to change the date when this summary folder will next receive up-to-date data from the database. This is only available for managed summary folders.

Refresh Interval

Use this field to change how often this summary folder receives up-to-date data from the database. This is only available for managed summary folders.

Identifier

Use this field to change the unique identifier that Discoverer uses to identify EUL and workbook objects. Discoverer uses identifiers to locate objects in different EULs that refer to the same business object.

Automatically save changes after each edit

Use this check box to save changes each time a field in this dialog is updated.

Summary Wizard (ASM): List of dialogs

The Summary Wizard enables you to use the Automated Summary Management facility to create and maintain the best set of summary folders for your organization's needs with the minimum of manual intervention.

For more information about ASM Summary Wizard dialogs, see:

"Summary Wizard: Step 1 dialog"

"Summary Wizard (ASM): Step 2 Analyze Folders dialog"

"Summary Wizard (ASM): Change default settings: List of dialog tabs"

"Summary Wizard (ASM): Step 3 Allocate Space dialog"

"Summary Wizard (ASM): Not Analyzed dialog"

"Summary Wizard (ASM): Recommended Summaries dialog"

Summary Wizard (ASM): Change default settings: List of dialog tabs

The preset default values found within Advanced Settings enable ASM to create and maintain the best set of summaries for your needs. If you want you can further refine the default setting to alter how ASM creates and maintains your summaries.

The Advanced Settings define which objects in the database to consider for inclusion in the ASM process and influence what ASM produces.

The Advanced Settings (Change Default Settings dialog) displays the following tabs:

"Summary Wizard (ASM): Change default settings dialog: Analyze tab"

"Summary Wizard (ASM): Change default settings dialog: Folders tab"

"Summary Wizard (ASM): Change default settings dialog: Query User tab"

"Summary Wizard (ASM): Change default settings dialog: Query Usage tab"

"Summary Wizard (ASM): Change default settings dialog: Deletion tab"

Summary Wizard (ASM): Change default settings dialog: Folders tab

Use this tab to specify which folders are analyzed by ASM. By default all folders are included. For example, you might have a large data warehouse and wish to only analyze the most important folders (for instance the fact tables) to reduce analysis time.

For more information, see:

Available

This list displays folders that are not included in the ASM analysis. Choose folders for analysis by moving folders from the Available list to the Included list.

Included

This list displays folders that are included in the ASM analysis. Remove folders from the ASM analysis by moving folders from the Included list to the Available list.

Notes

You can select more than one folder by pressing the Ctrl key and clicking another folder.

Summary Wizard (ASM): Change default settings dialog: Analyze tab

Use this tab to specify which folders to analyze and specify an optimization level. For example, to perform a complete analysis on all folders, not just those that have not already been analyzed.

For more information, see:

How do you wish to analyze the selected folders?

Only analyze folders that have not already been analyzed

Use this radio button when you have partly analyzed some folders previously, and wish to analyze the rest. When summary data has been held for more than the period specified by the After _ days field, this data is also re-analyzed.
Analyze ALL folders regardless

Use this radio button when you want to analyze every folder in the EUL.

When would you like a folders analysis to expire?

After _ days

Use this field to specify how long to use analyzed summary data. After this period, folders will be re-analyzed when you run ASM. The default for this is 30 days.

How would you like the analysis to be optimized?

Use this slider bar to increase the speed of analysis or the range of folders analyzed.

Max Speed

At this level, around 10% of folders are analyzed. This level produces a basic set of summaries without taking too long. For example, if you have a large data warehouse and wish to minimize analysis time.

Normal

At this level, you get an equal balance between speed and range.

Max Accuracy

At this level, 100% of folders are analyzed (default setting). This setting enables the widest range of summaries to be created by ASM. For example, if you have a relatively small data warehouse or where analysis time is not an issue.

Summary Wizard (ASM): Change default settings dialog: Deletion tab

Use this tab to configure how you purge (i.e. remove) summary folders that are out-of-date. For example, to make more space available in the database.

For more information, see:

Delete specific summary folders if

Last queried more than _ days ago

Use this field to delete summary folders if they were last used by Discoverer end users more than the number of specified days. For example, delete summary folders not used for seven days.

Created more than _ days ago

Use this field to delete summary folders if they were created before a specified time. For example, delete summary folders created more than two weeks ago.

Average usage less than _ times per _ over the last _ _

Use these fields when you want to finely control which summary folders are purged. For example, delete summary folders used less than ten times per week over the last two weeks.

Always retain the following summaries

Use this check box to exclude particular summary folders from the purge. For example, to maintain important summary folders that you always need to use.

Summaries to be retained

This field displays folders that are excluded from the purge. Include folders in the purge by moving folders from the Summaries to be retained field to the Available summaries field.

Available summaries

This field displays all folders that are included in the purge. Select folders to be excluded from the purge by moving folders from the Available summaries field to the Summaries to be retained field.

Notes

You cannot move external summary folders from the Summaries to be retained field.
If you try to move an external summary folder from the Summaries to be retained field to the Available summaries field a warning message appears and the summary folder remains in the Summaries to be retained field. Discoverer does not delete external summary data as it does not own it. Also deleting the metadata associated with external summary tables would not yield any great space gain which is why it is not done.

Summary Wizard (ASM): Change default settings dialog: Query Usage tab

Use this tab to select which queries are considered for summary recommendation. For example, to include only queries run at a specific time when Discoverer Plus users are working.

For more information, see:

Include

Use this drop down list to define which queries are considered for ASM.

All queries

Use this option to consider recommendations for summaries based upon all queries previously run.

Queries run since last execution

Use this option to consider recommendations for summaries based upon those queries run since the last execution of ASM.

Specific queries

Use this option to consider queries run at particular times, specified below.

Which have been run in the last x days
Which have been executed more than x times per minute/day/week/month/year
Where elapsed time is greater than x seconds

Move the slider to the position which best reflects the nature of your users queries

Use this slider bar to determine whether during analysis the constructed summary data favors predetermined (performance) or ad hoc (coverage) queries.

Predetermined

Use this setting to optimize the summaries maintained by ASM to reflect historical queries. In other words, the summaries will give great performance improvements where queries stay much the same over time.

For example, ASM might recommend a list of five exact match summaries, corresponding one-to-one with previously run queries (where ASM determines there is a benefit).

Mixed

A balance between predetermined and ad hoc queries (the default).

Adhoc

Use this setting to increase the coverage of a summary giving a potential performance gain for queries that have never been run before, but are closely related to previous system usage. However, the cost of this is that the individual performance gain for the previously run queries might not be as high.

For example, ASM might combine the five exact-match summaries to form fewer but more general summaries. These would provide benefit not only for the five previously run queries but also for a greater number of other potential queries (i.e. there would be a gain in overall coverage).

Summary Wizard (ASM): Change default settings dialog: Query User tab

Use this dialog to use Query Performance Statistics (QPP) from selected users in the ASM process. For example, to base ASM on a sub-set of users that require maximum performance when using Discoverer Plus.

For more information, see:

Available

This list displays users that are not included in the ASM process. Select users for analysis by moving users from the Available field to the Included field.

Included

This list displays users that are included in the ASM process. Remove users from the ASM process by moving users from the Included field to the Available field.

Notes

You can select more than one user by pressing the Ctrl key and clicking another user.

Summary Wizard (ASM): Not Analyzed dialog

Use this dialog to specify how you deal with folders that cannot be analyzed. For example, when you do not have analyze privileges on a particular database.

This dialog is also displayed as:

Not Analyzed dialog

For more information, see:

_ out of _ folders could not be analyzed. Would you like those folders to be excluded from the automatic summary creation?

Yes

Use this button to exclude folders that could not be analyzed.

Use this button to include folders that could not be analyzed.

Help

Use this button to get more information about the folders that could not be analyzed.

Notes

Use these notes to understand, and help to resolve the following issues:

You do not have ANALYZE privileges for a given object/table

In order to ANALYZE a table, you need one of the following:
- to be the owner of that table
- to have general ANALYZE privileges for the database (e.g. via 'grant ANALYZE any to me')
Where one of the underlying tables that make up a folder does not fit the above rules, that folder will not be analyzed. This means that if one or more tables within a folder cannot be analyzed then the whole folder is treated as if it cannot be analyzed.
When a folder is Invalid

How you fix this depends on why a folder is marked as invalid.

To display the error message associated with an invalid folder go to View | Validate Folders.
You are trying to ANALYZE over a DB-Link

If a folder refers to a table that resides on a database accessed over a DB-Link then ANALYZE will fail. This operation is not supported in the Oracle Server.
When Discoverer cannot determine or access the full list of tables that constitute a folder.

A Discoverer folder can contain more than one underlying database table and/or view. Getting a full set of the underlying tables might be impossible. For example:
- Where a view is based upon another view and the ASM user has access to the top level view, but not to the referenced view underneath.
This makes it impossible for the ASM user to see which database tables are actually used to make that view.
When folders do not fully resolve to tables

This should only really apply to the server dynamic tables (e.g. the V$ tables, and many DBA_tables). Not all these views and tables resolve to physical tables; some of them are stored in memory, thus they cannot be analyzed.

For example:
- V$_LOCKS
Although you can run queries on this kind of table/view, in practice it makes sense not to have summaries built on them as the summarized data would soon be out of date.

Summary Wizard (ASM): Recommended Summaries dialog

Use this dialog to look at which summaries Discoverer intends to use and change the included list if required. Discoverer might mark existing summaries for deletion when they fall outside the current ASM policy.

This dialog is also displayed as:

Recommended Summaries dialog

For more information, see:

Include

Use this check box to include a recommended folder in the ASM summary creation/deletion process.

Action

This field displays the action that will be carried out as part of the ASM process if the Include check box is selected.

Name

This field displays the Discoverer folder name.

Existing space used

This field displays the amount of space currently being used for summary folders.

Total space required

This field displays the total amount of space that is needed for the recommended summary folders.

Notes

When you first display the Recommended Summaries dialog, the summary folders that Discoverer recommends for the allocated space are selected. This means that should you click the Finish button in the main wizard the summary folders that are selected will be either be created or deleted depending on whether Create or Delete is displayed in the Action field. You can change which summary folders are created/deleted by selecting or clearing check boxes from the list of recommended summaries.
The right hand pane lists the currently selected summary folder components.
The total space required for the selected summaries is displayed underneath.
The method used to derive the figure for the Total space required from the list of recommended summaries is as follows:

The amount of space required is totalled and displayed in the Total space required field. Where summary folders are to be deleted, the space that was used by the summary folders to be deleted is made available for use by one of the other summary folders listed. The effect is that the figure for the Total space required is reduced by the sum of the KB of any summary folders to be deleted.
Discoverer will not generate summary folder recommendations based on items from base folders that are defined as reach though enabled (for more information, see "What is complex folder reach through?").

Summary Wizard (ASM): Step 2 Analyze Folders dialog

Use this dialog to automatically analyze your database structure and recommend which summaries you need.

This dialog is also displayed as:

Summary Wizard: Step 2 dialog

For more information, see:

(Progress indicator)

Use this bar to monitor the progress of the database analysis. When analysis is in progress, the cube above the bar revolves.

Start

Use this button to begin the folder analysis.

The first time this process is run, the analysis is based on default values. Any changes made to these values (through Advanced Settings) will be applied during subsequent folder analysis.

Continue

Use this button to resume folder analysis after you have stopped the process using the Stop button.

Stop

Use this button to pause the folder analysis.

To resume the folder analysis, use the Continue button.
To stop folder analysis, use the Cancel button.

Total folders in policy

This field displays the number of folders included in the ASM policy.

Folders analyzed

This field displays the number of folders in the ASM policy that have been analyzed.

Advanced Settings

Use this button to display the "Summary Wizard (ASM): Change default settings dialog: Analyze tab", where you can edit a range of default settings upon which folder analysis is based (known as the ASM Policy).

Notes

If you pause folder analysis, then change the ASM Policy, when you resume the process the new ASM Policy is used.

Summary Wizard (ASM): Step 3 Allocate Space dialog

Use this dialog to specify the ASM performance required against the amount of tablespace available for ASM. For example, to maximize ASM performance using the minimum of tablespace. You can also analyze the performance gain achieved by increasing the amount of tablespace.

For more information, see:

Performance vs. Space (KB)

Use this graph to evaluate the performance gain achieved by using the specified amount of allocated tablespace. As you change the amount of tablespace, you can see the performance impact displayed as a factor value.

The dotted line indicates the amount of tablespace available.
The red line indicates the amount of tablespace selected.
The plot line shows the performance gain achieved by selecting various amounts of tablespace.
To change the selected space setting, either:
- click the graph area and drag the red line to the left or right
- drag the triangle above the Space (KB) axis to the left or right
- click the graph area to the left of right of the red line
- enter the amount of tablespace you wish to use (in KB) in the Create summaries to fill field

Tablespace to use for summaries

Use this drop down list to specify which tablespace you want to use to store the summary tables.

Create summaries to fill

Use this field when you know how much tablespace is available and you want to evaluate the performance for the value.

Estimated performance gain

This figure is a factor value that represents the number of times faster that queries will run if ASM creates the recommended summaries.

Recommended Summaries

Use this button to display the "Summary Wizard (ASM): Recommended Summaries dialog", where you specify which summaries will be created/removed for optimum performance gain given the space currently allocated.

Advanced Settings

Use this button to display the "Summary Wizard (ASM): Change default settings: List of dialog tabs", where you define the ASM policy.

Notes

When choosing a tablespace, it is recommended that you place summaries in a separate tablespace specifically intended for summary data. If such a tablespace does not exist, we strongly recommend you do not use the SYSTEM or TEMP tablespaces.

Summary Wizard: Step 1 dialog

Use this dialog to specify how you want to create Discoverer summary folders. For example, to have Discoverer automatically create summaries for you.

For more information, see:

How do you want to create these summaries?

Have Discoverer recommend and create the best summaries for you

Use this radio button when you want Discoverer to automatically create summary folders for you. Here, you display the "Summary Wizard (ASM): Step 2 Analyze Folders dialog", which enables you to automatically analyze your tables and recommend which summary folders to create.

Note: If this option is disabled, select Help | Database Information to display the "Database Information dialog" where Discoverer displays reasons why ASM might not be available. For more information about why this option might be disabled, see "What are the prerequisites for creating summary folders with ASM?".
I want to create the summaries myself

Use this radio button when you want to create summary folders manually. Here, you display the "Summary Wizard: Step 2 dialog".

Summary Wizard: Step 2 dialog

Use this dialog to choose how to create summary folders. For example, to use query statistics collected on Discoverer Plus users to determine which summaries to create.

For more information, see:

How do you want to create this summary folder?

From items in the End User Layer

Use this radio button to create summary folders from an existing set of folders in the End User Layer (for more information, see "How to specify the tasks a user or role (responsibility) can perform").

You might select this option if, for example:
- you have switched off the Collect Query Statistics privilege (for more information, see "How to specify the tasks a user or role (responsibility) can perform")
- you want to manually select the combinations of EUL items that make up a summary folder
Based on query performance statistics

Use this radio button to create summary folders based on Discoverer queries that were run previously. This powerful facility means that you do not have to choose the items yourself. Once you have created the summary folder based on previous queries, you can add items and combinations, tailoring it to your users' needs (for more information, see "How to create summary folders based on users' queries").

Query performance statistics are automatically generated when queries are run in Discoverer Plus if the Collect Query Statistics privilege is switched on for users (for more information, see "How to specify the tasks a user or role (responsibility) can perform").

You might select this option if you know that you want to create one or more summary folders based upon specific queries, but you do not necessarily want Discoverer to create any other summary folders.
Based on an external summary table

Use this radio button to use external summary folders containing tables created with an application external to Discoverer. The column and item names might differ from those in Discoverer. With this option, you will register each external table and map its columns to items in the End User Layer. You can specify that Discoverer take over management of the summary folder, so that it can populate the table and continue to refresh its data(for more information, see "How to create summary folders based on external summary tables").

Summary Wizard: Step 3 dialog (using query statistics)

Use this dialog to specify how you collect query statistics for estimating best summaries. For example, to use query statistics where queries exceed a specified amount of CPU time.

This dialog is also known as:

Summary Wizard: Step 3 dialog

For more information, see:

Specify search criteria to obtain statistics on query performance, then click "Search"

Use these criteria to search for statistics to populate the Select a query to be summarized field.

Show query statistics from within the last _

Use this field to specify how recent the query statistic must be to qualify for the query list.

Average CPU Time exceeds _

Use this field to specify the minimum time required to execute the query on the database server.

Average elapsed time exceeds _

Use this field to specify the minimum time required to execute the query on the client workstation.

Number of queries exceeds _

Use this field to specify the minimum number of runs executed for the selected query. The runs might have been executed by different users at different times, but all used the same combination of folders and items.

Use this button to search for query statistics matching the search criteria specified above and display them in the Select a query to be summarized list.

Select a query to be summarized

This list displays query statistics matching the search criteria specified.

Select a query from the list to display the query's folders, joins and items in the lower right panel of the dialog, and activate the Next button.

The #Hits column records the number of times a query has been run by end users.

Notes

Summary folders built using Query statistics are refreshed by Discoverer.
A check mark or cube icon indicates that the current query has found a matching summary folder from a previous query. The symbol indicates an exact match that includes all objects.

Summary Wizard: Step 3 dialog (using external tables)

Use this dialog to map an external database table to the End User Layer (EUL). Run the Summary Wizard once for each external table you want to register.

External summary folders reference tables created with an application external to Discoverer. The column and item names might differ from those generated by Discoverer.

This dialog is also displayed as:

Summary Wizard: Step 3 dialog

For more information, see "Creating summary folders manually"

Select an external summary table

Use the Select button to display the "Choose user or table/view dialog", where you select a table within the current database.

Available Items

Use the drop down list to select the business area that you want to map to the external summary table.

Use the field to map EUL items (i.e. for the current business area) to corresponding database columns in the external summary table displayed in the Mapped Items field.

Map items in one of the following ways:

Drag and drop

Drag an item from the Available items field into the corresponding database column in the Mapped items field.

Drag a folder from the Available items field into the Mapped Items field to map all the columns in the external summary table to End User Layer items in a single operation. Discoverer automatically matches the items of similarly named database columns in the external summary table. Repeat this procedure for multiple folders if the external summary table maps to items in more than one folder in the EUL.
Include button

Select a database column in the Mapped Items field and a corresponding item in the Available items field and click the include button (right arrow) and Discoverer matches both in the Mapped Items field.
Double click

Select an database column in the Mapped Items field and then double click the corresponding item in the Available items field.

Mapped Items:

The database columns in the external summary table mapped to corresponding items in the EUL

Item

The item in the EUL mapped to a corresponding database column in the external summary table.
Database Column

The database column in the external summary table mapped to a corresponding item in the EUL.
Datatype

Data type and size of the database column.

Using Help

Oracle Business Intelligence Discoverer Administrator provides comprehensive online context sensitive Help and reference information.

For more information, see "About Discoverer Administrator documentation and online help".

Values dialog

Use this dialog to select one or more values to use when you create or edit a condition.

For more information, see:

"About the tabs in the Workarea window"

Discoverer displays this dialog when you choose the Select Multiple Values option from the drop down list in the Values field of the New/Edit Condition dialog.

Select values:

Select one or more check boxes next to corresponding values to include the selected values in the Value(s) field in the Conditions dialog.

Use the Select All button to select all the values displayed in the Select Values field.

Use the Select None button to clear all the values displayed in the Select Values field

The value(s) you select here are used in the current condition statement of this condition.

Workarea: Data tab

Use the Data tab to view the business areas, folders and items in the EUL that Discoverer end users see in Discoverer Desktop, Discoverer Plus and Discoverer Viewer. Folder items include axis items, data point items, joins, conditions, and calculated items. Discoverer Administrator displays folders and items that might be hidden to end users.

For more information, see:

"What is the Workarea?"

In the Data tab you can move items from one folder to another. You can also create, edit and delete folders, complex folders, items, conditions, joins and delete business areas.

Note: If you change the name of a primary element (i.e. a folder or item) in this tab, it might affect the name of each secondary element whose Auto generate name property is set to Yes. If you change the name of a primary element when dependent secondary elements have their Auto generate property set to Yes, Discoverer will reset the Auto generate property for each dependent secondary elements to No. For more information, see "About generating and updating EUL item names automatically".

Use the Properties dialog to examine and modify many attribute values as well as view the types and names of dependents for business areas, folders and items.

Workarea: Hierarchies tab

Use the Hierarchies tab to view the hierarchies in the EUL grouped by business area. Discoverer end users can use hierarchies in worksheets to drill down through hierarchically organized items.

For more information, see:

"About the tabs in the Workarea window"

Show

Use this drop down list to change which types of hierarchy are displayed. You can choose to view user or system defined hierarchies, and choose to display the different types of hierarchies (e.g. item, date or all hierarchies).

Notes

You can review the contents and the organization of each hierarchy and view the hierarchy templates provided by Discoverer Administrator.

Workarea: Item Classes tab

Use the Item, Classes tab to view item classes in the EUL grouped by business area.

For more information, see: