Business Intelligence Tutorial

Creating a collection of objects

You can create a collection that groups different objects together so that you can access them easily. A collection is represented by an icon that is displayed in the Information Catalog window. In this exercise, you will create a collection for the objects that correspond to the dimension tables that you specified in Lesson 8, Defining data transformation and movement.

To create a collection:

  1. Click Catalog --> Create collection from the Information Catalog window. The Create Collection window opens.
  2. In the Collection name field, type a name for your new collection:
    Tutorial Star Schema
    

    Accept the default icon to represent your collection.
    The GEOGRAPHIES SELECT statement on the SQL Statement page.

  3. Click Create. The new collection icon is displayed. You can now add and delete objects to and from your collection.
  4. From the Search Results window, right-click on the LOOKUP_MARKET object.
  5. Click Copy to collection.

    The Copy to Collection window opens.

  6. From the Select a collection list, select the Tutorial Star Schema collection.
  7. Click Copy. The object is copied to the collection of objects that you selected.
  8. Click OK.
  9. Repeat steps 4 through 7 for the LOOKUP_PRODUCT, LOOKUP_SCENARIO, and LOOKUP_TIME objects.

    After you complete these steps, if you double-click the Tutorial Star Schema collection in the Information Catalog window, you see the same list of tables that were displayed in the Search Results window.

  10. Close the Information Catalog.

    In the next section, we will re-open the Information Catalog as an administrator.


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