Free Access Kinaxis KX3-003 New Release

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.

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.

If each order is associated with a single salesperson and the goal is to filter records by the salesperson's name, the most straightforward solution is to add a field directly to the DemandOrder table where orders are recorded. This avoids unnecessary joins to another table and simplifies the data model. According to database normalization principles, if the field is non-repetitive and directly related to the entity (in this case, the order), it should be placed on the same table.

ReferencesThe addition of a single attribute that is not multi-valued, non-repeating, and directly related to the primary key in the table aligns with the first normal form (1NF) in database normalization. This approach is also supported by Kinaxis best practices for efficient data retrieval.

When you share a scheduled task with other users in Kinaxis RapidResponse and the option "When other users run this scheduled task, run as: Scheduled task owner" is selected, those users will be able to run the task using the resource access rights of the task owner. This means that even if the users do not have access to all the resources used in the task, they can still run it because the task will execute with the owner's permissions.

ReferencesThe Kinaxis RapidResponse help documentation explains how sharing and permissions work, including details on what happens when scheduled tasks are shared with users who might not have access to all the necessary resources.