KX3-003 Questions and Answers

• Create a reference field on the ScheduledReceipt table to the WorkOrderInfo table.
• Display relevant work order data in worksheets based on the ScheduledReceipt table and the referenced WorkOrderInfo table.

Very Detailed ExplanationThe best practice in this scenario, according to Kinaxis, is to create a reference from the ScheduledReceipt table to the WorkOrderInfo table. This allows for direct linking of records between these tables. The worksheets based on the ScheduledReceipt data can then leverage this reference to display related information from the WorkOrderInfo table, ensuring that the data is accurately aligned and easily accessible for reporting and analysis.

ReferencesThis recommendation aligns with Kinaxis’s guidance for structuring worksheets and data models to efficiently report and analyze data from multiple related tables without the need for redundant worksheets or complex lookup structures.

To identify an automation chain and its associated resources, searching for resources based on the specific table involved in the automation (in this case, "HistoricalPartKPI") will help you find the correct automation chain. This approach ensures that you identify all the resources related to that particular table, including automation chains.

ReferencesThe Kinaxis RapidResponse documentation for administrators provides guidance on how to search for and identify resources associated with specific tables or actions within the system, which includes searching for resources based on table names.

To ensure that neither worksheet is taking advantage of cached results, which could skew performance comparisons, you should close the workbook and any library workbooks it depends on. By reopening the workbook after this, you force RapidResponse to reload the data and recalculate the worksheets from scratch, ensuring that you are capturing performance results without the influence of previously cached data.

ReferencesKinaxis RapidResponse performance tuning guidance suggests that to accurately test the performance impact of changes, all cached data should be cleared. This can be achieved by closing and reopening the workbooks, as indicated in the Kinaxis RapidResponse resources on performance management.

The OrderGenerationRule of 'AfterPTF' with a LeadTime of 2 days and a PlanningTimeFence (PTF) of 2 means that planned orders will be generated for demands occurring after the planning time fence period, considering the lead time for production. Table II shows negative balances past the planning time fence (06-01 and 06-02 are within the planning time fence), indicating planned orders are created after these dates to cover upcoming demands. Therefore, planned orders appear on 06-04 and 06-05, taking into account the 2-day lead time post the planning time fence.

ReferencesThis follows Kinaxis RapidResponse rules for order generation where the PlanningTimeFence and LeadTime dictate when planned orders are created in response to demand, as detailed in the Kinaxis documentation on planning strategies.

For the automated deletion of records older than a year in the HistoricalDemandActual table, the correct approach involves:

• Statement C:Utilizing an Automation Chain. Automation Chains in RapidResponse allow the creation of sequences of actions, including data deletions, that can be scheduled or triggered based on specific events. This method is essential for implementing complex automations such as deleting records based on a date condition.
• Statement D:Creating a Scheduled Task. Scheduled Tasks are crucial for setting up the automation to run on a regular interval, such as weekly, withoutmanual intervention. This ensures that the command to delete old records is executed consistently every week.

To prevent duplication of TimePhasedSafety records in cross-scenario updates:

• Statement A:Including all key and reference fields in the update is a best practice. This ensures that the database can accurately match records across scenarios, reducing the risk of duplications.
• Statement C:Listing identifying fields ahead of other columns in the update process helps in prioritizing these fields during the matching process, enhancing the accuracy of record linkage and minimizing duplication errors.

References

• Kinaxis RapidResponse documentation and best practices on Automation Chains and Scheduled Tasks.

References:The search did not yield specific documentation on best practices for cross-scenario updates in Kinaxis RapidResponse. However, these answers are aligned with general best practices for database management and updates to prevent duplication and ensure data integrity.

To ensure unique key values while saving memory, it's best to concatenate critical fields that together provide uniqueness. The expression A combines the Part Site Value and the Effective In Date, providing a string that will be unique across all parts and their effective dates. This approach is more memory-efficient than storing additional redundant data or using less discriminative fields.

B is not specific enough, as EffectiveInDate alone does not guarantee uniqueness across parts and sources. C is potentially unique, but it may not be as memory-efficient as A if Part Names are long strings. D is not specific enough, as the Source ID alone does not ensure uniqueness across parts.

References:

• Kinaxis RapidResponse documentation on data modeling, particularly regarding key construction.
• Best practices for key management in database systems as relevant to Kinaxis RapidResponse.

The worksheet properties shown in the graphic indicate how to calculate the change in theAvailableDateofIndependentDemandbetween a child and its parent scenario. Configuration II shows the expression[:AvailableDate#0 - :AvailableDate#1 Workday], where#0refers to the child scenario and#1refers to the parent scenario. This expression calculates the difference in workdays between theAvailableDateof the independent demand in the child scenario and the parent scenario.

The worksheet should be set to calculate using the final results from other columns, ensuring that it takes into consideration the latest available data from the child and parent scenarios for accurate calculation of the workday difference.

References:

• Kinaxis RapidResponse documentation on worksheet expressions and scenario comparison.
• Kinaxis training materials on configuring worksheets for scenario analysis.

Considering that Demand 2 has a higher priority than Demand 1 (as indicated by "High" versus "Medium"), it will be allocated available supplies before Demand 1, following the priority rules. SR1 is scheduled for Monday and will likely be allocated to Demand 1, being the first demand of the week. For Demand 2, SR2 is the nextavailable and will fulfill 200 units. Since Demand 2 requires 300 units and SR2 only supplies 200, the next available SR, which is SR3, will cover the remaining 100 units needed.

ReferencesAllocation of supplies to demands in Kinaxis RapidResponse takes into account both the chronological order of the scheduled receipts and the priority of the demands. This is consistent with Kinaxis's allocation rules as outlined in the RapidResponse documentation.

References:

• The Kinaxis RapidResponse documentation indicates that scheduled receipts are allotted based on priority and availability, with earlier dates being allocated first to meet high-priority demands12.

Line A withcmdDeleteData.execute();would execute a command to delete data in RapidResponse, which, if configured correctly, would delete records. Line C withwsOrderChng.remove(dataArray);is a method that would also potentially delete records from the worksheet if the dataArray contains the correct keys for the records that need to be removed.

ReferencesThe Kinaxis RapidResponse scripting and workbook API documentation explain the methodsexecute()for running commands andremove()for removing data from worksheets. Both can be used to delete records when executed with the proper context and data.

A filter based on the IndependentDemand table would improve the performance of a worksheet based on the WhereConsumedForDemand table, assuming that the demand is what drives the consumption. By filtering on IndependentDemand, you reduce the number of records the worksheet needs to process, thus improving load times and responsiveness, especially if there are a large number of records in the WhereConsumedForDemand table.

ReferencesThe Kinaxis RapidResponse documentation suggests that filtering based on driving factors such as demand can significantly enhance performance by narrowing down the data set to the most relevant records.

The migration of the Supplier.Id filter to the secondary filter expression box allows for enabling caching because it is a user-specific filter. Moving user-specific or session-specific expressions to the secondary filter ensures that the primary filter canbe cached independently of user sessions. This way, the overall data set can be cached, and the user-specific filtering is applied afterward, improving performance.

References:

• Kinaxis RapidResponse documentation on primary and secondary worksheet filters.
• Kinaxis support resources on caching strategies and performance improvements for worksheets.

Referring to the graphic, it appears that there is a target allocation ratio between Supplier 1 and Supplier 2 (not visible in the image, but this can be inferred from the allocation quantities). When a new demand for 800 units is introduced, the SourceRule.AllotmentRule set to OnGoing will distribute the demand based on the ongoing target ratio. Since Supplier 1 has a running total that far exceeds Supplier 2, and both have a 'Multiple Qty' of 250, the next allotment will attempt to balance the ongoing total closer to the target ratio. It's likely that the new demand will be allocated by filling up to the nearest multiple of 250 that does not exceed the demand. Therefore, Supplier 1 gets 250, and the remaining 550 units would go to Supplier 2. Since Supplier 2 also must supply in multiples of 250, it rounds up to 750 units.

ReferencesThis understanding is derived from the Kinaxis RapidResponse concepts for managing supply allocations and the behavior of ongoing rules as described in the Kinaxis RapidResponse documentation.

References:

• The Kinaxis RapidResponse documentation on SourceRule.AllotmentRule indicates that ongoing allotment is based on the target ratios set for suppliers1.
• The Certified RapidResponse Author Level 3 materials cover the configuration and implications of SourceRule.AllotmentRule settings2.