Oracle® Business Intelligence Server Administration Guide > Completing Setup and Managing Oracle BI Repository Files >
Querying and Managing Repository Metadata
You can query for objects in the repository using the Query Repository tool. If you query using the All Types option, a list appears that contains the exposed object types in the repository. The list does not contain objects such as aggregate rules, logical source folders, privilege packages, and other objects that are considered internal objects. You can use repository queries to help manage the repository metadata in the following ways:
To query a repository
- Open the Administration Tool, and then open your repository.
- In the repository, right-click any object and choose Display Related > [type of object on which you want to search].
- In the Query Repository dialog box, the type of object is prefilled.
- In the Query Repository dialog box, complete the query information using Table 20 as a guide.
Table 20 contains a description of most fields and buttons in the Query Repository dialog box.
- Click Query.
You can view the results, save the results to an external file, or make changes and overwrite the existing query or save as a new query.
To save a query results to an external file
- After running the query, in the Query Repository dialog box, click Save.
- In the Save As dialog box, type a name, choose a type of file and an Encoding value.
- To add additional columns of information to the results, click Add Columns.
- In the Select information to add to the report dialog box, select the columns you want from the list.
- You can re-order the columns by selecting a checked column and clicking Up or Down.
- Click OK
- In the Save as dialog box, select a Save as type.
- Click Save.
To save a query to run it again later
- After running the query, in the Query Repository dialog box, click Save Query As.
- In the Save Query As dialog box, type a name for the query and click Save.
- In the Query Repository dialog box, click Close.
To delete a saved query
- Open the Administration Tool, and then open your repository.
- From the Tools menu, choose Query Repository.
- In the Query Repository dialog box, click Saved Queries.
- In the Saved Queries dialog box, scroll to the right or maximize the dialog box.
- Click the delete button for the query that you wish to delete, and then click Close.
To run a saved query
- Open the Administration Tool, and then open your repository.
- From the Tools menu, choose Query Repository.
- In the Query Repository dialog box, click Saved Queries.
- In the Saved Queries dialog box, select the row that contains the query you wish to run, and then click Select.
- In the Query Repository dialog box, click Query.
You can view the results, save the results to an external file, or make changes and overwrite the existing query or save as a new query.
Table 20. Query Repository Fields and Some Buttons
|
|
Delete |
After executing a query, use this button to delete an object in the list of query results. |
Edit |
After executing a query, use this button to edit an object in the list of query results. Not all repository objects can be edited from the results list. For example privilege objects and user database sign-on objects. If an object cannot be edited from the results list, the Edit button will not be available. |
Filter |
Use this button to create or edit a filter for your query. After you create a filter, the filter criteria appear in the text box on the left of the button. For more information, refer to Constructing a Filter for Query Results. |
GoTo |
After executing a query, use this button to go to the object in the Administration Tool view of the repository. |
Mark |
After executing a query, use this button to mark the selected objects. To unmark an object click the button again. You can mark objects to make them easier to visually identify as you develop metadata. |
Name |
Allows a search by object name. You can use an asterisk ( * ) wildcard character to specify any characters. The wildcard character can represent the first or last characters in the search string. Searches are not case sensitive. |
New |
Use to request a new query. |
Parent |
After executing a query, use this button to view the parent hierarchy of an object. If the object does not have a parent, a message appears. In the Parent Hierarchy dialog box, you can edit or delete objects. However, if you delete an object, any child objects of the selected object will also be deleted. |
Query |
Use this button when you are ready to submit your query. |
Save Query As |
Opens a dialog box in which you can save a query and select or delete a previously saved query. Available only after you have created a query. |
Saved Queries |
Opens a dialog box in which you can type a new name for the query or browse existing saved queries. This button is only available if you have previously saved queries. |
Set Icon |
After executing a query, use this button to select a different icon for an object. To change the icon back to this original icon, use this button and select Remove associated icon. You can set special icons for objects to make it easier to visually identify them as having common characteristics. You may, for example, want to pick a special icon to identify columns that will be used only by a certain user group. |
Show Qualified Name |
Use this check box to display the fully qualified name of the object(s) found by the query. For example, if you query for logical tables, the default value in the Name list is the table name. However, if you select the Show Qualified Names check box, the value in the Name list changes to businessmodelname.logicaltablename.columnname. |
Type |
Select a type from the drop-down list to narrow your search to a particular type of object. |
To create a new object
- From the Administration Tool menu bar, choose Tools > Query Repository.
- In the Query Repository dialog box, in the Type drop-down list, select the type of object you want to create.
- Click New.
The dialog boxes that appear depend on the object type that you select. For more information refer to the section of this documentation that pertains to creating that object.
|