Oracle9i Discoverer Administrator Administration Guide Version 9.0.2 Part Number A90881-02 |
|
Use this dialog to configure item properties. For example, to change the name or formula of an item.
For more information, see:
"Maintaining items and item classes"
The Item Properties dialog contains two tabs:
Use this field to change the name of the item.
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.
(Read only) This 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.
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 may 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 not editable).
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.
Use this field to specify whether the item is visible to Discoverer end users:
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 may contain data such as primary and foreign keys or sensitive data such as salary information.
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.
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.
Use this field to change where the item is positioned by default on worksheets.
Use this field to change the aggregate type for the item (if numeric).
Use this field to change the heading of the column that is displayed on worksheets. By default, the heading is the item's column name, which is derived from the item name.
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. You can specify the Euro currency symbol in the format mask using Discoverer Plus. For more information, see the Oracle 9iAS Discoverer Plus User's Guide.
Use this field to change the alignment of data displayed in Discoverer Plus. Select an alignment from the pull down menu. The default selection, General, right aligns numeric data, and left aligns date and text data.
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.
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.
Use this field to change how items are displayed in workbooks.
Use this field to change the item's default width (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).
Use this field to change how null characters are displayed. For example, null = We're out... order now!, null = 0, null = nothing visible, or space.
Use this field to specify whether the item can be used to launch an external application. Choose FILE if the data item contents require a helper application to run, such as Microsoft Excel. Choose NONE if the data type does not require a helper application.
If the item is a BLOB (binary large object), the file extension determines the application (.exe executable file) used 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, or a drill out image (e.g. a HTML icon indicating a drill out to a Web report), choose 'NONE' (for more information, see Chapter 9, "About drilling out to other applications").
Use this field to specify the maximum amount of characters retrieved in a SQL call to the database. This option is particularly useful for LONG data types. The purpose of limiting the total amount is that sometimes there are hundreds, perhaps thousands of characters in a data element and it would be inefficient or unnecessary to retrieve the entire data element.
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 (also known as Conceptually Identical Objects).
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 data Discoverer manager about exactly where the data came from.
This tab displays two columns (Type and Name) that clarify the extent to which other objects (Folders, Joins, Items, Item Classes, Summaries, Conditions, Calculations etc.) are dependent on the selected Item.
This field displays one or more object types (E.g. Folders, Items etc) that have a dependency on the selected Item
This field displays the name of each object listed in the Type column
|
Copyright © 2002 Oracle Corporation. All Rights Reserved. |
|