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
- In the Business Model and Mapping layer, right-click a logical table.
- From the shortcut menu, select New Object > Logical Column.
- In the Logical Column dialog box, select the General tab.
- 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.
- If you want the logical column to be derived from other logical columns, perform the following steps:
- Select the check box for Use existing logical columns as source.
- Click the ellipsis button next to the text box to open the Expression Builder.
- In the Expression Builder- derived logical column dialog box, specify the expression from which the logical column should be derived.
- Click OK.
- (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.
- Make changes and click OK.
|