Bookshelf Home | Contents | Index | Search | PDF |
Siebel Analytics Server Administration Guide > Working in a Repository's Presentation Layer > 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 9.
To create a presentation catalog
- In the Presentation layer, right-click and select New Presentation Catalog from the shortcut menu.
The Presentation Catalog dialog box appears.
- In the General tab, enter a name for the presentation catalog.
- 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.
- Select a Business Model from the drop-down list.
- 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.
- (Optional) Enter 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.
To delete a presentation table
- Click the Presentation Tables tab.
- Click the table you want to remove and click the Remove button, or press the Delete key.
A confirmation message appears.
- Click Yes to remove the table, or No to cancel the removal.
To reorder a table in the Presentation layer
- Click the Presentation Tables tab.
- In the Name list, select the table you want to reorder.
- 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
- Click the Presentation Tables tab.
- Click on Name column heading.
This toggles the sort between ascending and descending alphanumeric order.
Bookshelf Home | Contents | Index | Search | PDF |
Siebel Analytics Server Administration Guide Published: 23 June 2003 |