KX3-003 - Certified RapidResponse Author Level 3 Exam

In the context of creating a metric worksheet for calculating the number of late orders, you want to group by DueDate to consolidate orders that are due on the same day, and then sum the Count for each of these groups to get the total number of late orders per day. Therefore, DueDate should be the grouping column, and Count should use the Sum function to add up all instances of late orders for each DueDate.

References:

• Kinaxis RapidResponse documentation on creating metric worksheets.
• Kinaxis learning resources on the use of expressions and functions for grouping and aggregation in worksheets.

A. Enabling the Bucket data by date checkbox and setting the Bucket Size to Day and the Number of Buckets to 730 would directly create a view that organizes daily historical data into daily buckets spanning the last two years (since there are 365 days in a year, multiplied by 2).

C. Creating calendar interval, start date, and end date variables using the CalendarDate table allows for the configuration of a custom time range in the worksheet. These variables can be referenced to display historical data for the desired period.

B is not correct because adjusting the Anchor date by 1 year would only provide data for the last year, not two. D is not correct because it suggests a method of filtering data by date without bucketing, which does not align with the requirement to show historical data in daily buckets.

References:

• Kinaxis RapidResponse documentation on bucketing data by date.
• Kinaxis support resources on configuring worksheets with date variables and bucketing.

Given that the control table setting for OrderPriority.AllocationRule is FairShare and all demands are the same priority, the available supply quantity will be allocated evenly among the demands. The graphic shows there are demands due on Monday, Tuesday, and Wednesday with planned orders due on each day as well. If the total supply on Thursday is not specified in the question, we assume it is enough to meet or exceed the demand. Since all demands have the same priority and the allocation rule is FairShare, the entire supply quantity for Thursday will be evenly distributed. Without the exact supply quantity, the best assumption is that the full quantity needed for the demand due on Wednesday will be allocated.

ReferencesThis explanation is based on the FairShare allocation rule which distributes available supply evenly across all demands when they have the same priority, as per the Kinaxis RapidResponse documentation on supply allocation.