Create an Aggregation Selector

Follow this task to create an aggregation selector. Use aggregation selectors to define aggregation groupings using matrices.

Procedure

  1. In Aggregation Selectors, click New Aggregation Selector.
  2. In Create New Aggregation Selector:
    1. In Name, enter a unique name.
    2. (Optional) In Description, enter descriptive information about the item.
    3. (Optional) In External ID, enter any alphanumeric character to serve as a unique ID on this pricing object. The external ID can be used for any reason that is meaningful to your implementation of MATRIXX Engine. External IDs are saved to the pricing configuration file and loaded into the Pricing database.
    4. Click Create.
  3. In Start Date/Time, use the date picker to select the date on which the object becomes active in the Pricing database and is first available for use, or enter the date in the format YYYY-MM-DD. Optionally, enter a time for when the object becomes active. The default start date/time is 2000–01–01 00:00:00. If applicable, the range in which the start date/time must fall is listed. For example:
    • Select a date on or before 2021–12–01.
    • Select a date on or after 2020–01–27.
    • Select a date between 2000–01–02 and 2021–10–04.
    Note: If you are creating a new revision of this object, the start date/time must be after the start date/time of the preceding revision and before the start date/time of the next revision. If you are making a copy of this object, the start date/time is not copied. The new object is the first revision, so it has the default start date/time of 2000–01–01 00:00:00.
  4. Click Save.
  5. In the Aggregation Selector Tables pane, click New Aggregation Selector Table.
  6. In Create New Aggregation Selector Table:
    1. In Name, enter a unique name.
    2. (Optional) In Description, enter descriptive information about the item.
    3. (Optional) In External ID, enter any alphanumeric character to serve as a unique ID on this pricing object. The external ID can be used for any reason that is meaningful to your implementation of MATRIXX Engine. External IDs are saved to the pricing configuration file and loaded into the Pricing database.
    4. Click Create.
  7. In Default Result, enter a default result value. The default is SKIP.
  8. In the Decision Table pane, do one of the following.
    • To add an existing decision table, click Select Decision Table, click the name of the decision table to add, and click Select.
      Tip: To filter the list of decision tables available, enter the decision table ID or name in the Search field.
    • To create a new decision table, click Create New Table and define the new decision table.
      • For each normalizer to add to the decision table, click Add Column, select the normalizer from the list, and click Add.
      • For each possible combination of the normalization parameter values you want the decision table to normalize on, click Add Row, and click the cell in each normalizer column and select a parameter value from the list. If needed, you can clone or delete any row that has been added.
      • To clone one or multiple rows, click in the check box of each row you want to clone (to clone all rows, click the check box in the table header), and then click Copy Rows. The clones are added to the decision table.
      • To delete one or multiple rows, click in the check box of each row you want to delete (to delete all rows, click the check box in the table header), and then click Delete Rows.

    The decision table is successfully created with the multiple-parameter condition set you defined.

  9. In Decision Table, click in the Aggregation field for each row and enter the aggregation string to be used if this row is executed.
    Note: During rating, the decision tables are examined in the order they are listed in the Aggregation Selector Tables pane. To change the order in which tables are listed, click and drag a table to the new position in the list.