In this situation, what is the chosen line of descent from the query engine?

The graphic shows a path to generate a list of customer prices with record counts for each table in the path.

Given the following filter expression:

Part.ProductNumber.ProductGroup.ProductFamily In (‘bikes’,’trikes’)

AND Customer.Country IN ("US", "CA")

In this situation, what is the chosen line of descent from the query engine?
A . Country > Country_Customers > CustomerPrices
B . ProductFamily > ProductFamily_ProductGroups > ProductGroup_ProductNumbers > ProductNumber_Parts > CustomerPartPrices
C . CustomerPartPrices > ProductNumber_Parts > ProductGroup_ProductNumbers > ProductFamily_ProductGroups > ProductFamily
D . CustomerPrices > Country_Customers > Country

View Answer

Answer: B

Explanation:

The filter expression contains a path that starts from ProductFamily, going down to ProductGroup, then ProductNumber, and Part, and finally linking to Customer prices. This path represents a ‘line of descent’ where the query engine filters down from the highest level of hierarchy (ProductFamily) to the desired records (CustomerPartPrices), respecting the AND logic to include only those records where the ProductFamily is either ‘bikes’ or ‘trikes’ and the Customer’s Country is "US" or "CA". This is the logical path of filters applied in sequence according to the hierarchy laid out in the filter expression.

ReferencesIn Kinaxis RapidResponse, filter expressions are used to specify the subset of data that you want to retrieve. The reference to ‘line of descent’ reflects how the RapidResponse query engine processes the filters along the hierarchy of related tables. This is consistent with the Kinaxis RapidResponse Author Level 3 documentation on advanced filtering and data retrieval strategies.

References:

The filter expression indicates a top-down approach, starting from the product hierarchy and moving towards customer-related data1.

Kinaxis RapidResponse documentation suggests that the query engine follows the path from the broadest category down to the specific records that match the criteria2.