The Oracle BI Administration Tool is a Windows application that you can use to create and edit repositories.
This section describes the Administration Tool main window, how to set preferences, menus, and other related information.
This section contains the following topics:
Learn how to open the Oracle BI Administration Tool.
To open the Administration Tool, choose Start > Programs > Oracle Business Intelligence > BI Administration.
Note:
Do not open the Administration Tool by double-clicking a repository file. The resulting Administration Tool window is not initialized to your Oracle instance, and errors will result.
You can also launch the Administration Tool from the admintool
utility. The location of the admintool
utility is:
ORACLE_HOME/bitools/bin
.
You can use the Options dialog to set preferences and options for the Administration Tool.
To set Administration Tool options:
Learn how to edit objects in the repository.
This section provides information about editing, deleting, and reordering objects.
To edit objects, double-click an object, or right-click an object and select Properties. Then, complete the fields in the dialog that is displayed. In some dialogs, you can click Edit to open the appropriate dialog.
To delete objects, select one or more objects and click Delete, or press the delete key. You can also right-click an object and select Delete.
To reorder objects, drag and drop an object to a new location. Note the following:
Reordering is only possible for certain objects and in certain dialogs.
In some dialogs, you can use an up or down arrow to move objects to a new location.
In the Oracle BI Administration Tool main window, you can drag and drop an object onto its parent to duplicate the object. For top-level objects like business models and subject areas, drag and drop the object onto white space to duplicate it.
You can learn about the repository object naming requirements.
All repository object names must follow these requirements:
Names that are 128 characters or less
Names that do not contain leading or trailing spaces
Names that do not contain characters such as single quotes, hash marks, question marks, or asterisks
Note:
Repository object names can include multibyte characters.
You use the Browse dialog to find and select an object.
The Browse dialog appears in many situations in the Administration Tool.
The Browse dialog is accessible from several dialogs that let you make a selection from among existing objects.
The left pane of the Browse dialog lets you browse the tree view for a particular object. It contains the following parts:
A tree listing all of the objects in the Presentation layer, Business Model and Mapping layer, or the Physical layer of a repository.
Tabs at the bottom of the left pane let you select a layer. Some tabs might not appear if objects from those layers are not appropriate for the task you are performing.
The right pane of the Browse dialog lets you search for the object you want. It contains the following parts:
Query enables you to query objects in the repository by name and type. The Name field accepts an asterisk (*) as the wildcard character, so you can query for partial matches.
The Show Qualified Names option lets you identify to which parents an object belongs.
View lets you view properties of a selected object in read-only mode.
The exception to this is the Synchronize Contents feature, which lets you synchronize an object from the query results list with the tree view. This feature is a helpful contextual tool that locates a particular object in the tree view.
Task | Description |
---|---|
Querying for an object |
Follow these steps to query for an object:
|
Selecting an object |
Use the tree view in the left pane or the filtered view in the right pane to locate the object you want, then double-click the object. The Browse dialog closes, and the object is displayed in the previous dialog. |
Synchronizing an object in the query results list with the tree view |
Select an object in the Query list and then click the Synchronize Contents button. The object you selected is highlighted in the tree view in the left pane. |
Finding multiple occurrences of an object in the tree view |
Select an object in the tree view, such as a logical column, then click the down arrow button. The next occurrence of that object is highlighted in the tree view. |
In the Oracle BI Administration Tool, you can change the icon that represents a particular object in the repository.
Changing the icon for a particular object does not have any functional effect, and is not visible in Answers or other clients. Changing the icon is a useful way to visually distinguish objects for the convenience of repository developers.
For example, you can:
Use a special icon for objects that are in the Business Model and Mapping layer, but not the Presentation layer, for easier maintenance of the repository.
Mark objects that are logical calculations with a separate icon.
Choose an icon to visually distinguish tables in the Presentation layer that appear as nested folders in Answers.
Use an icon to denote objects in a logical table that pertain to a specific functional area, or that are sourced from a particular logical table source.
You can only change the icon for individual objects. You cannot globally change the icon for all objects of a particular type.
To change the icon for a particular repository object:
Many dialogs in the Administration Tool show lists of objects, such as a list of physical columns in the Physical Table dialog, a list of logical levels for Preferred Drill Path in the Logical Level dialog, and a list of presentation hierarchies in the Presentation Table dialog.
You can click the header to sort the objects in ascending or descending order. An up arrow or down arrow icon is displayed next to the header name, indicating how the list has been sorted.
Each list also has a default order that is persisted from session to session. The default order appears when you view a list in a dialog for the first time each session. The default order is displayed when there is no ascending or descending arrow icon in the header. Click the header three times to toggle between ascending, descending, and default order. In some cases, the default order is the ascending or descending order.
Some dialogs provide the capability to move items up or down in a list. In these dialogs, if you click Up or Down while the list is sorted in ascending or descending order, the selected item moves, and the resulting order becomes the new default order. Clicking the header eliminates any manually determined order.
Some features and options in the Oracle BI Server are for use by organizations that have the Oracle Marketing Segmentation product. For information about these features and options, see Oracle Marketing Segmentation Guide.
Additional information about Oracle Marketing Segmentation features is provided in the Oracle BI Presentation Services Help.