Siebel Pricing Administration Guide > Creating Attribute Adjustments >

Example of Creating an Attribute Adjustment Based on Product Attributes


This topic gives one example of how to create attribute-based pricing based on product attributes. You may use this feature differently, depending on your business model.

In this example, adjustments are applied to the price of automobiles based on two attributes:

  • Interior color has the possible values red, green, and blue.
  • Transmission has the possible values automatic and manual.

Because of current market and inventory conditions, you want to create the three price adjustments shown in Table 9. These price adjustments will apply only to vans sold to retail customers.

Table 9. Attribute-Based Price Adjustments in the Example
Interior Color
Transmission
Adjustment Type
Adjustment Amount

Green

Automatic

% Discount

$10

Red

Manual

% Markup

$10

Blue

Manual

Price Override

$22,000

This example assumes that you have already created the class Horizon Autos, the product Van, and the price list Retail. For information about creating classes and products, see Siebel Product Administration Guide. For information about creating price lists, see Creating and Assigning Price Lists. This example also assumes that you have set up variable maps, as described in Using Variable Maps in Attribute Adjustments.

Creating the Attribute Adjustment Record

First, create the Attribute Adjustment record. The type must be multiple, because the price adjustments depend on more than one attribute. It must be associated with the class Horizon Autos, which includes these attributes.

To create the attribute adjustment record

  1. Navigate to the Administration - Pricing screen > Attribute Adjustments view.
  2. In the Attribute Adjustments list, add a new record and complete the necessary fields.

    Some fields are described in the following table.

    Field
    Value

    Name

    Horizon Autos Retail Van Adjustments

    Class

    Horizon Autos

    Type

    Multiple Dimension

Specifying Dimensions and Domains

Next, set up the dimensions that you want to use in the attribute adjustments. You must add two condition dimensions for the attributes that are the basis of price adjustments (Interior Color and Transmission).

You must also add two result dimensions that determine the amount of the price adjustment (Adjustment Amount and Adjustment Type), which are added automatically when you click Create Result Dimensions.

You also enter the domains for each of these dimensions, and you select the Bounded check box in the Dimension records. This controls data entry in the Rules list, so only valid values can be entered in the columns for these dimensions.

To enter the result dimensions and their domains

  1. In the Attribute Adjustments list, click Create Result Dimensions.
  2. Click the Pricing Dimensions view tab.

    Records have already been added to the Dimensions list for the two result dimensions, Adjustment Amount and Adjustment Type.

  3. In the Pricing Dimensions list, select the record for adjustment type, and click Create Domain.

    Records are added to the Domain list for the five possible values of adjustment type.

To enter the condition dimensions and their domains

  1. Add a record to the Dimensions list to represent the Interior Color attribute and complete the necessary fields, as described in the following table.
    Field
    Value

    Dimension Type

    Condition

    Name

    Int Color

    Operator

    =

    Variable Map Type

    XA

    Data Type

    Text

    Domain Type

    Attribute

    Bounded

    Y

    Attribute

    Interior Color

    Sort Order

    1

    Sort Method

    Ascending

  2. Click Create Domain.

    The three values for this domain (red, blue, and green) appear in the Domain list.

  3. Add a record to the Dimensions list to represent the Transmission attribute and complete the necessary fields, as described in the following table.
    Field
    Value

    Dimension Type

    Condition

    Name

    Transmission

    Operator

    =

    Variable Map Type

    XA

    Data Type

    Text

    Domain Type

    Attribute

    Bounded

    Y

    Attribute

    Transmission

    Sort Order

    2

    Sort Method

    Ascending

  4. Click Create Domain.

    The two values for this domain (automatic and manual) appear in the Domain list.

Adding Pricing Conditions

After you have set up the dimensions of the attribute adjustment, you can add conditions. The Conditions list has a column for each of the dimensions that you created.

Because you are creating conditions for only three price adjustments, you add the Conditions records manually instead of using the Generate Rules button.

To add pricing conditions

  1. Click the Conditions view tab.
  2. Add a record to the Conditions list and complete the necessary fields, as described in the following table.
    Field
    Value

    Sequence

    1

    Int Color

    Green

    Transmission

    Automatic

    Adjustment Type

    % Discount

    Adjustment Amount

    10

  3. Add a second record to the Conditions list and complete the necessary fields, as described in the following table.
    Field
    Value

    Sequence

    2

    Int Color

    Red

    Transmission

    Manual

    Adjustment Type

    % Markup

    Adjustment Amount

    10

  4. Add a third record to the Conditions list and complete the necessary fields, as described in the following table.
    Field
    Value

    Sequence

    3

    Int Color

    Blue

    Transmission

    Manual

    Adjustment Type

    Price Override

    Adjustment Amount

    22,000

Associating the Attribute Adjustment with a Product and Price List

After you have created the attribute pricing conditions, you must associate them with a product on a price list to make them effective. These conditions apply to vans sold to retail customers.

To associate the attribute adjustment with a product and price list

  1. Navigate to the Administration - Pricing screen > Price Lists view.
  2. In the Price Lists list, select the record for the price list named Retail.
  3. Click the Price List Line Items view tab.
  4. In the Price List Line Items list, in the record for the product named Van, in the Attribute Adjustment field, select Horizon Autos Retail Van Adjustments.
Siebel Pricing Administration Guide Copyright © 2006, Oracle. All rights reserved.