Configuring Baseline Custom Fields for Category Aggregation

You can add a custom baseline field to the category aggregation process. This field must be based on an extension column.

To configure a custom baseline field for category aggregation

  1. Log in to Siebel Tools.

  2. Create the column for the custom field in the applicable tables (S_PROD_BASELINE and S_CG_CAT_BASELN) by performing the following steps:

    1. In the Object Explorer, select the Table object, and in the Object List Editor, query for the applicable table

    2. In the Object Explorer, select the Column child object, and create the column.

    3. Click Apply/DDL, select the Apply action, and click OK.

    For more information about extending columns in tables, see Configuring Siebel Business Applications.

  3. Create the custom field in the following business components:

    • CG SVP Product Baseline

    • CG SVP Product Baseline - Aux

    • CG SVP Product Baseline - for Adding Data

    • CG SVP Category Baseline

    • CG SVP Category Baseline - Aux

    • CG SVP Category Baseline - for Adding Data

    To create the custom field, perform the following steps:

    1. In the Object Explorer, select the Business Component object, and in the Object List Editor, query for the business component.

    2. In the Object Explorer, select the Field child object, and create the custom field.

  4. Create the list column for the custom field in the following applets:

    • CG SVP Product Baseline List Applet

    • CG SVP Category Baseline List Applet

    • CG SVP Account Product Baseline List Applet

    • CG SVP Account Category Baseline List Applet

    To create the list column, perform the following steps:

    1. In the Object Explorer, select the Applet object, and in the Object List Editor, query for the applet.

    2. In the Object Explorer, select the List child object, select the List Column child object, and create the list column for the custom field.

  5. Create the user property for the custom field in the CG SVP Product Baseline-Aux business component by performing the following steps:

    1. In the Object Explorer, select the Business Component object, and in the Object List Editor, query for the CG SVP Product Baseline-Aux business component.

    2. In the Object Explorer, select the Business Component User Prop child object, and create a new user property with a name of the next available Build Tree name (for example, Build Tree 10) and a value of the custom field name.

    Note: You can use the Category Aggregation Field user properties to configure category aggregation for custom fields.
  6. Deploy your changes to the Siebel Runtime Repository.