Business Intelligence Tutorial

Searching the information catalog

In this exercise, you will search for the objects that correspond to the dimension tables that you specified in Lesson 8, Defining data transformation and movement.

To search for objects in an information catalog:

  1. Double-click the New search icon in the Information Catalog window.

    The Define Search window opens.

  2. Scroll through the Available object types list. This list displays all of the object types that are defined in your information catalog.
  3. Select the Relational tables and views object type.
  4. Click > to add the selected object type to the Search for object types list.
  5. From the Properties/Values list, click Name.
  6. In the Enter value for selected property field, type the following value:
     LOOKUP
    
  7. Click Enter. The value is displayed in the Value column of the Properties/Values list.
  8. Select the Ignore case check box to search all occurrences of the value, regardless of case.
  9. From the Search options list, click beginning with.

    The Information Catalog Manager will search for objects that begin with the value that you specified in the Value column.
    The GEOGRAPHIES SELECT statement on the SQL Statement page.

  10. Click Search. The Information Catalog Manager searches for objects of the type that you specified and displays the results in the Search Results window.
    The GEOGRAPHIES SELECT statement on the SQL Statement page.


[ Top of Page | Previous Page | Next Page | Table of Contents ]