Siebel Analytics Server Administration Guide > Creating and Administering the Business Model and Mapping Layer in a Repository > Creating and Administering Logical Columns >

Creating a Logical Column


Use the General tab to create or edit the general properties of a logical column. You can create a logical column object in the Business Model and Mapping layer, and then drag and drop it to the Presentation layer.

To create a logical column

  1. In the Business Model and Mapping layer, right-click a logical table.
  2. From the shortcut menu, select New Object > Logical Column.
  3. In the Logical Column dialog box, select the General tab.
  4. In the General tab, type a name for the logical column.

    The name of the business model and the associated logical table appear in the Belongs to Table field.

  5. If you want the logical column to be derived from other logical columns, perform the following steps:
    1. Select the check box for Use existing logical columns as source.
    2. Click the ellipsis button next to the text box to open the Expression Builder.
    3. In the Expression Builder- derived logical column dialog box, specify the expression from which the logical column should be derived.
    4. Click OK.
  6. (Optional) In the Logical Column dialog box, type a description of the logical column.

    NOTE:  The type and length fields are populated automatically based upon the column's source.

  7. Make changes and click OK.
Siebel Analytics Server Administration Guide