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

Working with Presentation Columns


The presentation column names are, by default, identical to the logical column names in the Business Model and Mapping layer. However, you can present a different name by clearing both the Use Logical Column Name and the Display Custom Name check boxes in the Presentation Column dialog box.

To provide a convenient organization for your end users, you can drag and drop a column from a single logical table in the Business Model and Mapping layer onto multiple presentation tables. This allows you to create categories that make sense to the users. For example, you can create several presentation tables that contain different classes of measures—one containing volume measures, one containing share measures, one containing measures from a year ago, and so on.

The Presentation Column dialog box has the following tabs:

  • General. Use this tab to create or edit a presentation columns.
  • Aliases. Use this tab to specify or delete an alias for a presentation column.

To create or edit a presentation column

  1. Right-click a presentation table in the Presentation layer, and then select New Presentation Column from the shortcut menu.

    The Presentation Column dialog box appears.

  2. To specify a name that is different from the Logical Column name, do the following:
    1. Type a name for the column.
    2. Clear the Use Logical Column check box.
  3. To use the name of the logical column for the presentation column, select the Use Logical Column check box.

    The name of the column and its associated path in the Business Model and Mapping layer is displayed in the Logical Column Name field.

  4. Click the Permissions button to open the Permissions dialog box, where you can assign user or group permissions to the column.
  5. If you want to examine or change the properties of the logical column in the Business Model and Mapping layer, click the Edit button to open the Logical Column dialog box.
  6. Click OK when you are finished to return to the Presentation Column dialog box.
  7. (Optional) Type a description of the presentation column.
  8. To define any aliases for the logical column, click the Aliases tab.

To delete a presentation column

  1. Right-click a presentation table in the Presentation layer, and then select Properties.
  2. Click the Columns tab.
  3. Select the column you want to delete.
  4. Click Remove, or press the Delete key.

To reorder a presentation column

  1. Right-click a presentation table in the Presentation layer, and then select Properties.
  2. Click the Columns tab.
  3. Select the column you want to reorder.
  4. Use the drag-and-drop feature to reposition the column, or click the Up and Down buttons.
Siebel Analytics Server Administration Guide