Siebel Analytics Server Administration Guide > Creating and Maintaining the Presentation Layer in a Repository > Presentation Layer Objects >

Working with Presentation Catalogs

In the Presentation layer, presentation catalogs allow you to show different views of a business model to different sets of users. Presentation catalogs have to be populated with contents from a single business model. They cannot span business models.

Presentation Catalog Dialog Box

The Presentation Catalog dialog box has three tabs: General, Presentation Tables, and Aliases. The functionality provided in each tab is described in Table 15.

Table 15.  Presentation Catalog Dialog Box
Tab
Comment
General
Use this tab to create or edit a presentation catalog.
Presentation Table
Use this tab to reorder or sort the Presentation layer tables in the Administration Tool workspace, and to delete tables. You can also use this tab to access the Presentation Table dialog box, where you can create and edit tables.
Aliases
Use this tab to specify or delete an alias for a catalog folder.

To create a presentation catalog

  1. In the Presentation layer, right-click and select New Presentation Catalog from the shortcut menu.

    The Presentation Catalog dialog box appears.

  2. In the General tab, type a name for the presentation catalog.
  3. Click the Permissions button to open the Permissions dialog box, where you can assign user or group permissions to the catalog folder.

    For information about assigning permissions to a presentation catalog, see Setting Permissions for Repository Objects.

  4. Select a Business Model from the drop-down list.

    After the Presentation Catalog has columns, the drop-down list becomes inactive.

  5. To expose the logical keys to other applications, select the option Export logical keys.

    This causes any columns in the Presentation layer that are key columns in the Business Model and Mapping layer to be listed as key columns to any ODBC client. This is the default selection. In most situations, this option should be selected.

    Many client tools differentiate between key and nonkey columns, and the option Export logical keys provides client tools access to the key column metadata. Any join conditions the client tool adds to the query, however, are ignored; the Siebel Analytics Server uses the joins defined in the repository.

    NOTE:  If you are using a tool that issues parameterized SQL queries, such as Microsoft Access, do not select the Export logical keys option. Not exporting logical keys stops the tool from issuing parameterized queries.

  6. (Optional) Type a description of the catalog folder.

    CAUTION:  When you move columns into presentation catalog folders, be sure columns with the same name or an alias of the same name do not already exist in the catalog.

  7. Set an Implicit Fact Column.

    An implicit fact column is a column that will be added to a query when it contains columns from two or more dimension tables and no measures. You will not see the column in the results. It is used to specify a default join path between dimension tables when there are several possible alternatives.

To delete a presentation table

  1. Click the Presentation Tables tab.
  2. Click the table you want to remove and click the Remove button, or press the Delete key.

    A confirmation message appears.

  3. Click Yes to remove the table, or No to cancel the removal.

To reorder a table in the Presentation layer

  1. Click the Presentation Tables tab.
  2. In the Name list, select the table you want to reorder.
  3. Use the drag-and-drop feature to reposition the table, or click the Up and Down buttons.

To sort all tables in the Presentation layer in alphanumeric order

  1. Click the Presentation Tables tab.
  2. Click on Name column heading.

    This toggles the sort between ascending and descending alphanumeric order.


 Siebel Analytics Server Administration Guide
 Published: 11 March 2004