In Salesforce Revenue Cloud, when configurable products are ordered (e.g., internet service with upload/download speeds), the configured values are stored at the Order Product Attribute level. These are linked to the corresponding Order Product, which represents the actual product ordered.
To generate a report that includes both:
The ordered item (Order Product)
Its specific configurations (upload/download speeds)
You need to use a custom report type that includes:
Order Products
Order Product Attributes
While Product Attribute Definition (mentioned in Option B and C) defines the possible attributes at the product catalog level, it does not store the selected values made during quoting or ordering. The actual values chosen are stored in the Order Product Attribute object.
This approach ensures that your report includes actual selections made by customers, not just the available options.
Exact Extracts from Salesforce Revenue Cloud Documents:
Subscription Management Implementation Guide – “Order Product Attribute Usage”:“Order Product Attributes store the selected values from the product configuration process and are linked directly to the corresponding Order Product.”
CPQ Data Model Reference – “Attributes and Orders”:“Reporting on configurable products requires joining Order Product with Order Product Attribute to retrieve both the product and its configured values.”
[References:, Subscription Management Implementation Guide, Salesforce CPQ and Billing Data Model Guide, Revenue Cloud Reporting and Analytics Guide, ===========]
