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

A. The DeliveryRoutes being a Set data type indicates that there can be multiple Delivery Routes referencing a carrier, allowing for one-to-many relationships between a carrier and delivery routes.

C. The Shipments being a Set data type as well indicates that multiple shipments can reference a single carrier, also suggesting a one-to-many relationship.

D. The DefaultTransportationMode being a Reference data type allows for the possibility that several carriers can share the same transportation mode, as references do not enforce uniqueness.

B is not correct because the TransitCalendar being a Reference data type indicates a one-to-one relationship; each carrier can reference only one Transit Calendar. E is also incorrect because the Sources field being a Set data type implies that a carrier can be associated with multiple sources.

References:

• Kinaxis RapidResponse documentation on data modeling and table relationships.
• Kinaxis learning resources on understanding data types and their implications on table relationships.

To provide a worksheet based on the CRPOperation table that reports the destination location and to view all valid work centers that feed a given stock location:

• Statement B:Create a reference field on the CRPOperation table to the Location table. This approach establishes a direct relationship between operations and their respective locations, enabling efficient reporting and querying capabilities for the secondary requirement of viewing work centers related to a stock location.

Creating a reference field on the CRPOperation table to the Location table (B) is the most efficient way to report destination location while allowing visibility of all valid work centers that feed a given stock location.

References:

• Kinaxis RapidResponse Author Level 3 training emphasizes the importance of efficient data modeling and reference creation for performance optimization1.
• The Kinaxis RapidResponse documentation suggests that creating direct references between tables ensures better performance than creating additional lookup tables or worksheets23.

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.

The AvailableRule control table is used to define how available dates for supply and demand are calculated in Kinaxis RapidResponse. This includes the rules for when supplies are considered available for meeting demand and vice versa, such as lead times, transit times, and other considerations that might affect when a part can realistically be expected to be available.

ReferencesThe function of the AvailableRule control table and its impact on the calculation of available dates for supplies and demands is outlined in Kinaxis RapidResponse configuration settings for supply chain planning processes.

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 track which performers are late and by how much for each activity in a process orchestration scenario, you need to access data that includes information on activity assignments, due dates, and completion status. The Assignment table within the ProcOrch (Process Orchestration) namespace contains this data. You can use this table to identify the performers assigned to each activity, check the planned completion dates against actual completion dates, and calculate the delays.

By creating a worksheet based on the Assignment table, you can include columns for activity IDs, performer IDs, due dates, completion dates, and a calculated field for the delay. The delay can be calculated by comparing the due date with the completion date or the current date if the activity is not yet completed. If there is more than one performer per activity, each performer's assignment will be a separate record in the Assignment table, allowing the worksheet to show delays for each performer.

References:

• Kinaxis RapidResponse documentation on creating worksheets based on specific tables.
• Training and knowledge resources provided by Kinaxis on how to use and configure worksheets in RapidResponse for process orchestration scenarios.

To determine the total number of unique customers that have orders for each part, the COUNT function with a By qualifier is used. This counts the number of unique instances of a field within a set, which in this case is the Customer field within the IndependentDemands.

ReferencesThe COUNT function with a By qualifier is detailed in the Kinaxis RapidResponse documentation regarding aggregation functions, which specifies how to count unique occurrences of a field within a data set.

To report the date used to convert the calculated field EffectiveUnitPrice, the CONVERTONDATE function is the appropriate one to use. This function converts a measure's value from one date to the value it would have on another date. The $ConversionDate variable (or similar) would typically be used within the worksheet to reference the date to which the conversion is applied.

ReferencesThe Kinaxis RapidResponse documentation on calculated fields and conversion functions explains how the CONVERTONDATE function is used to adjust financial measures based on changes over time, which would apply to fields such as EffectiveUnitPrice.

To manage the demand forecast effectively while simplifying user controls, enabling hierarchy columns would allow users to make selections across different levels of the data hierarchy in one go. For instance, if a user wanted to select a particular product for a specific customer region and distribution site, they could do so without navigating through multiple filters. Additionally, having a hierarchy available for users to select regional distribution sites will allow them to filter data based on their particular region, which aligns with the management of demand forecast by customer region and distribution site. Disabling default filters that are not relevant to the users’ needs can also simplify the user experience but is not specifically mentioned in the given options.

ReferencesThe guidance is based on Kinaxis RapidResponse workbooks best practices, which suggest using hierarchies for filtering to simplify user experience and enable efficient data navigation, as documented in the RapidResponse Author Level 3 training resources.

References:

• Kinaxis RapidResponse documentation highlights the importance of using hierarchies to simplify user controls and enhance data management within workbooks1.
• The Certified RapidResponse Author Level 3 badge details the skills required to create and edit various types of complex workbooks, which includes managing hierarchies effectively2.

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.

B. By adding a column to map the bucket dates in the spreading worksheet, you ensure that the start and end dates of the spreading are properly defined and can be utilized in the algorithm.

D. Selecting "Use same spreading worksheet values for all edits" ensures that the values entered in the buckets are consistent across the worksheet, which is necessary for the spreading functionality to work correctly.

A is incorrect because removing unmapped columns does not solve the issue related to spreading values across the buckets. C is incorrect because allowing editing only if all buckets are the same size is a constraint that does not address the mapping issue.

References:

• Kinaxis RapidResponse support articles on troubleshooting and configuring spreading worksheets.
• Kinaxis community discussions on common issues and solutions related to worksheet design.

To resolve the issue with the workbook designed for spreading values, it is necessary to ensure that the bucket dates are properly mapped in the spreading worksheet. This allows the system to recognize and apply the correct time horizon for the spread. Additionally, selecting the option to use the same spreading worksheet values for all edits ensures consistency across the worksheet.

References:

• Kinaxis RapidResponse Author Level 3 certification materials1.
• Enhanced troubleshooting skills and best practices as mentioned in the Kinaxis Certification Program2.

The code block IV is correctly using the script execution pattern in RapidResponse. It first gets the script usingrapidResponse.scripts.get()method with the correct parameters for the name and scope, and then calls the script with.call()method, passing the necessary scenario argument. This is how you would invoke another script from within a script.

ReferencesThe use ofrapidResponse.scripts.get()andcall()methods is standard practice in Kinaxis RapidResponse for executing one script from within another, as detailed in the Kinaxis RapidResponse scripting documentation.

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.

• 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 enable data caching on a worksheet, you should minimize the dynamic content that can cause the cache to become outdated quickly. Removing hierarchy columns can improve performance because hierarchies often involve complex joins and calculations that can slow down data retrieval. Disabling the "Use As Reference" checkbox on the Part column means that changes in the Part table will not cause the cache to be invalidated, which can be beneficial if the Part data does not change frequently.

References:

• Kinaxis RapidResponse documentation on worksheet performance optimization.
• Kinaxis best practices for enabling and managing data caching in worksheets.