Bookshelf Home | Contents | Index | Search | PDF

Siebel Analytics Server Administration Guide > Setting Up and Working with a Repository >

Managing Repository Metadata

---

You can use the Query Repository dialog box to do the following:

Examine and update the internal structure of the repository. For example, you can search for objects in the repository based on name, type (such as Catalog, Complex Join, Key, and Level), or on a combination of name and type. You can then edit or delete objects that appear in the Results list. You can also create new objects, and view parent hierarchies.
View reports that show such items as all tables mapped to a logical source, all references to a particular physical column, the content filters for logical sources, dimensional hierarchies, and security and user permissions.

For example, you might want to run a report prior to making any physical changes in a database that might affect the repository. The report results are generated using Universal Database Markup Language (UDML) and can be viewed online or copied and pasted into a program such as Windows Notepad. The results can also be saved to a file in comma-separated value (.csv) format. This file could then be imported into or opened in a program such as Microsoft Access to create a table of the results, making them available for querying through Siebel Answers.

To access the Query Repository dialog box

In the Administration Tool, select Tools > Query Repository.

To search for objects based on name

In the Query Repository dialog box, enter the text to search for in the Name field, and then click Query.

You can use an asterisk ( * ) wildcard character to specify any characters. The wildcard character must be the last character in the search string. For example, to search for all objects beginning with the letter `o', enter the following:

o*

NOTE:  Searches are not case sensitive.

To narrow your search to a particular type of object

Select the type of object from the Type drop-down list, and then click Query.

To display fully qualified names in the Results pane

Select the option Show Qualified Name.

This functionality is useful in seeing which physical table a particular physical column belongs to.

To see the parent of an object

Select an object in the results list, and then click Parent.

The Parent Hierarchy dialog box appears for the selected object. (If the object does not have a parent, a message displays instead). Using this feature, you can display the full parent hierarchy for any object that has a parent.

From the Parent Hierarchy dialog, you can edit and delete objects:
Click Edit to open the appropriate dialog box for the type of object you are editing.
Click Delete to delete the selected object. Any child objects of the selected object will also be deleted.

To create a new object

In the Type drop-down list, select the type of object you want to create.

The New button becomes active.

Click New to open the appropriate dialog box for the type of object you want to create.

To edit an object in the Results list

Select the object, and then click Edit.

The appropriate dialog box opens for the object.

NOTE:  Not all repository objects can be edited from the Results list; examples include privilege objects and user database sign on objects, among others. If an object cannot be edited from the Results list, the Edit button will not be available.

To report on an object and view the results online

Select the object, and then click UDML.

The UDML window appears.

To copy the results to the Windows clipboard, click Copy.
Open a program such as Windows Notepad and paste the results.

NOTE:  You can also paste UDML into the Execute UDML utility window and use it to create an object in the repository.

Bookshelf Home | Contents | Index | Search | PDF