Conga Product Documentation

Welcome to the new doc site. Some of your old bookmarks will no longer work. Please use the search bar to find your desired topic.

Use Case: Creating Attribute Value Matrices

Ensure that you have met the following prerequisites:

  • Product attributes (for example, Color, HDD, RAM, Screen Size, and Fingerprint Reader) are created in the Product Attribute Value object.
  • Product attributes are assigned to a Product Attribute Group and associated with the target product or category.
  • You have administrative permissions to create product rules and execute maintenance jobs in Conga CPQ.

This use case provides an example of how to create attribute value matrices to drive product selection. Your implementation may vary. For more about creating attribute value matrices, see Creating Attribute Value Matrices.

Business Context

To simplify complex product configurations and prevent ordering errors, organizations use Attribute Value Matrices within Conga CPQ. Attribute Value Matrices associate up to five product attributes to establish a compatibility table of valid combinations. Because attributes in the matrix are bi-directional, selecting a value for one attribute dynamically filters the available options for all other associated attributes in real time, ensuring that sales representatives and customers select only feasible product configurations.

Actors

  • CPQ Administrator: Configures product attributes, builds the Attribute Value Matrix compatibility table, and executes maintenance jobs.
  • Sales Representative / Customer: Selects product attributes in the shopping cart during product configuration.
  • CPQ System: Evaluates matrix constraints bi-directionally and dynamically updates attribute picklist options.

Scenario

A sales administrator at Amttus, a laptop manufacturer, wants to set up an Attribute Value Matrix to guide product selection for laptops. The manufacturer offers laptop models (A-560, A-560m, A-440, A-440m, A-320, and A-320m) characterized by five primary attributes: Color, HDD, RAM, Screen Size, and Fingerprint Reader.

The valid product and attribute relationships are defined as follows:

ProductColorHDDRAMScreen SizeFingerprint Reader
A-560Black1 TB8 GB14 HDYes
A-560mBlack2 TB16 GB14 HDYes
A-440White500 GB4 GB15Yes
A-440mWhite500 GB8 GB15 HDYes
A-320Black1 TB8 GB14No
A-320mWhite1 TB16 GB14 HDYes
  1. Create an Attribute Value Matrix header.

    Navigate to CPQ Admin, select Product Rules > Attribute Value Matrices, and click New Attribute Value Matrix. Specify a matrix name and associate the target product or product scope.

  2. Select target attributes for the matrix.

    Select up to five attributes to associate in the matrix: Color, HDD, RAM, Screen Size, and Fingerprint Reader.

  3. Define valid attribute value combinations in the compatibility table.

    Add rows to the matrix compatibility table corresponding to valid product specifications. Enter the picklist values for each row as defined in the product matrix table (for example, Row 1: Color = Black, HDD = 1 TB, RAM = 8 GB, Screen Size = 14 HD, Fingerprint Reader = Yes).

  4. Save and activate the Attribute Value Matrix.

    Set the matrix status to Active and save the configuration.

  5. Run Criteria Maintenance to apply matrix rules.

    Navigate to CPQ Admin > Maintenance Jobs and execute Criteria Maintenance to update the rule evaluation cache.

The Attribute Value Matrix is created and active. When a user selects Color = Black from the picklist menu during product configuration in the shopping cart, CPQ dynamically filters the remaining attribute options:

  • HDD: 1 TB and 2 TB
  • RAM: 8 GB and 16 GB
  • Screen Size: 14 and 14 HD
  • Fingerprint Reader: Yes and No

Invalid attribute combinations are automatically hidden or constrained, eliminating invalid configurations and streamlining quote generation.

Navigate to the CPQ shopping cart, add a laptop product to the cart, click Configure, and test bi-directional attribute filtering by selecting various attribute values.