KX3-003 Certified RapidResponse Author Level 3 Exam Questions and Answers

The SalesForecast for the TV family is for 1000 units, as shown in the graphic. The MPSConfig planning BOM will generate a planned order equal to the SalesForecast quantity because there is no available supply. OptionRatio and QuantityPer indicatethe proportion of the forecast to be planned for each product type (LCD and Plasma), not the total quantity to be planned. Therefore, the planned order quantity will match the total forecasted demand, which is 1000 units.

ReferencesThis conclusion is drawn from the Master Production Schedule (MPS) and Bill of Materials (BOM) configuration rules within Kinaxis RapidResponse. When there is no supply to meet demand and forecasts are being translated into planned production, the full amount of the forecast typically becomes the planned order quantity.

To ensure that suppliers only receive reports relevant to their purchase orders, a profile variable tied to the supplier's user group is used to filter the report data. The Notify tab in the Alert properties window is used to configure the report distribution to the appropriate supplier's user group, ensuring that each supplier gets the tailored report.

References:

• Kinaxis RapidResponse documentation on creating user groups, profile variables, and configuring alerts for report distribution.
• Kinaxis training materials on workbook filter expressions and alert notification settings.

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.

Performance issues often stem from the complexity of calculations and the size of the data sets they are applied to. In this case, the use of a calculated field (NameAndDescription) in the hierarchy definition is the most likely cause of performance degradation. This field is calculated on the fly using a concatenation of the Name and Description, which is a more resource-intensive process compared to using static fields.

Calculated fields, especially those involving string operations like concatenation, can be significantly slower because they require runtime computation. This contrasts with static fields that are indexed and retrieved directly from the database without additional computational overhead.

References:

• Kinaxis RapidResponse documentation on hierarchy design and performance considerations.
• Kinaxis best practices for creating efficient hierarchies and using calculated fields.

Using a calculated field, especially one that concatenates strings like in option C, can significantly impact performance because it requires additional computation for each record. This is more resource-intensive than using a direct field value, which would explain the poorer performance when using the PartFamily hierarchy compared to the PartPlanner hierarchy.

References:

• Kinaxis RapidResponse Author Level 3 training materials1.
• Web search results and Kinaxis best practices2.

Structure II shows BuyerCode connected to Department and Department connected to Manager. This setup supports multiple departments per manager while allowing for each department to be on a specific floor. Since users may want to filter on combinations of BuyerCode, Manager, Department, and Floor, this design accommodates such queries efficiently by structuring the Department as a central entity that relates to the others. In Structure II, Department is linked to BuyerCode and Manager, enabling a query to traverse from BuyerCode to Manager through Department, making it optimal for the desired filters.

ReferencesBest practices for database design suggest structuring your data model to reflect the relationships between entities in a way that supports the expected queries and filters. In Kinaxis RapidResponse, this often means creating a logical structure that minimizes join complexity and optimizes the data model for typical user operations.

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.

When setting the bucket date in an insert definition, if the requirement is to have the record due on the last workday of the week (which is Friday or Thursday if Friday is a non-workday), then the correct approach is to configure the insert definition to use the last workday in the bucket. This will ensure that the due date falls on the correct day according to the specified requirement.

ReferencesThe Kinaxis RapidResponse documentation details how to use bucket dates and adjust them according to workdays in the insert definition setup for crosstab 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.

To create a modify command that updates the DueDate field with the New Due Date, it’s essential to simplify the worksheet. Making the Order column a reference and removing unnecessary columns like Order Site, Order Type, Control Set, and Line ensures that the modify command focuses on the relevant data for the update.

References:The search did not yield specific documentation on creating modify commands in Kinaxis RapidResponse.However, the answer aligns with general best practices for simplifying data management tasks123.

The script is performing a data import operation into a worksheet that is configured to allow importing data for the purpose of inserting records, as shown in the worksheet properties exhibit. The JSON object in the console output would reflect the result of this import operation. The object details the number of records deleted, modified, and inserted. Since the worksheet is set up only to allow insertion, and the script is importing data for insertion, the "inserted" key would have a value of 1, and"deleted" and "modified" would have a value of 0, indicating a successful insert without any deletions or modifications.

ReferencesKinaxis RapidResponse documentation for data importing and console operations would support this behavior, outlining how the importData method interacts with worksheet configurations.

When an automation chain step that runs in parallel with other steps is removed, it does not affect the operation of the remaining steps. The other steps that were originally set up to run in parallel will continue to run in parallel unless their configuration is changed manually.

ReferencesKinaxis RapidResponse's documentation on automation chains clarifies the behavior of parallel steps in an automation chain when one step is modified or removed. The behavior and configuration of the remaining steps persist until they are manually changed.

References:The answer is based on general knowledge of automation chains and parallel processing.For specific Kinaxis RapidResponse functionality, please refer to the official training materials and documentation123.

To highlight differences between scenarios, a hidden column that calculates the difference (QuantityDelta) can be created. The actual Quantity column would show the actual value, while the QuantityDelta column would calculate the difference between the baseline scenario and the comparison scenario. Conditional formatting can then be applied to the Quantity column to highlight when the QuantityDelta is not equal to zero, indicating a difference between the scenarios.

ReferencesThe method for comparing scenario data and highlighting differences using conditional formatting is a common practice in Kinaxis RapidResponse, as outlined in the application's user guide and best practices for building worksheets.

In the WhereConsumed table, the PegPart represents the item driving the need for the component. In this case, the independent demand for AAA requires components BBB and DDD to be produced. The DriverPart is the direct parent in the Bill of Material (BOM) for DDD, which is BBB. The NeedQuantity is calculated by multiplying the demand for AAA by the quantity per of BBB (100 units * 4) and then by the quantity per of DDD (400 units * 4), resulting in a NeedQuantity of 1600 for DDD.

ReferencesThis answer follows the logic of BOM explosion and the principles of MRP (Material Requirements Planning) that can be found in the Kinaxis RapidResponse documentation, which outlines how to calculate the required quantities of each item in the BOM based on the independent demand.

To optimize performance when creating a worksheet that contains fields from four tables, the worksheet should be based on:

• Table 1

Table 1 is connected to Table 3 with a one-way arrow, indicating a one-to-many relationship where Table 1 is the primary table. This setup typically allows for more efficient data retrieval and better performance.

• References

The decision is supported by the diagram showing the relationships between the tables, where “Arrow Head = 1” and “Arrow Base = Many” indicates the direction of the relationship and the primary table.

To optimize performance, the worksheet should be based on the top-level table from which you can access related data via references. This is because starting from the top level allows you to utilize indexed lookups, which are faster than traversing from many-to-one relationships. Given the data model design, Table 1 is the topmost table with one-to-many relationships to Table 3, which in turn links to Table 4, and it can also indirectly access data from Table 2 through the many-to-one relationship back to Table 1.

References:

• Kinaxis RapidResponse documentation on worksheet creation and data model traversal.
• Kinaxis guidelines on optimizing worksheets for better performance.

To pass information from columns in a worksheet to a script, the form controls used to collect input from users need to be mapped to the script arguments. This mapping allows the script to receive the column data as arguments. Additionally, making sure the names of the script arguments match the ID of the form controls is necessary for the script to correctly identify and use the data passed from the form.

ReferencesKinaxis RapidResponse documentation and best practices for forms and scripting indicate that mapping form controls to script arguments and ensuring the argument names match the control IDs are critical for passing data to scripts.