KX3-003 試験問題を無料オンラインアクセス

You are asked to transform PlannedOrder data into new ScheduledReceipt records, assuming just one PartSource per part and no maximum quantity. You need to filter the PlannedOrder records to ensure you do not try to create any ScheduledReceipt records which already exist. The workbook includes a worksheet, LKPScheduledReceipt, on existing converted ScheduledReceipts and follows Kinaxis best practices.
In this situation, which filter expression will follow KInaixs best practices and provide the best performance to include PlannedOrder records that do not match existing ScheduledReceipt records?

• A.NOT {Part.Name, Part.Site.Value, DueDate} IN LKPScheduledReceipt!
• B.NOT IsNull ( Lookup ({Part.Name, Part.Site.Value, DueDate}, LKPScheduledReceipt!, Null(Mfg::ScheduledReceipt), Exact, LKPScheduledReceipt!Self ))
• C.NOT {Part, DueDate} IN LKPScheduledReceipt!
• D.( Lookup({Part.Name,Part.Site.Value, DueDate}, LKPScheduledReceipt!, "N", LKPScheduledReceipt!Exists) = "N" )

You are required to troubleshoot a workbook designed to spread values across a specified time horizon. The start and end bucket dates are mapped to variables used in the spreading worksheet. The bucket field is not mapped to a column in the editing worksheet.
Which two actions would solve this issue? (Choose two.)
Choose 2 answers

• A.Select the "Use same spreading worksheet values for all edits" check box.
• B.Select the "Allow editing only if all buckets are the same size" check box.
• C.Add a column to the spreading worksheet to map the bucket dates.
• D.Remove the unmapped columns from the editing worksheet.

A user wants to build a crosstab worksheet that shows historical data in daily buckets for the last two years.
Currently, historical data is stored in days.
What are two ways to accomplish this task? (Choose two.)
Choose 2 answers

• A.Enable Advanced Bucketing, select Day in the Bucket Size and 365 in the Number of Buckets, and then adjust the Anchor date by 1 Year.
• B.Enable the Bucket data by date checkbox, then select Day in the Bucket Size and 730 (365*2) in the Number of Buckets.
• C.Clear the Bucket data by date checkbox and then filter the worksheet for the last 2 years as Date >= MRPDate - 730 and Date <= MRPDate
• D.Create calendar interval, start date, and end date variables using the CalendarDate table, and then reference these variables in the worksheet that displays historical data.

You need to create a workbook to allow users to manage their demand forecast by product, customer region, and distribution site. You also want to simplify user controls and use hierarchies to allow each user to make several selections in the same hierarchy.
In this situation, which two actions should you take? (Choose two.)
Choose 2 answers

• A.Select Part as the basis for workbook filtering.
• B.Disable the default Site filter.
• C.Ensure a Hierarchy is available for users to select regional distribution sites.
• D.Enable the Include hierarchy columns option.

After the most recent planning cycle, a planner asks you why there were no new records in the HistoricalPartKPI table. They expected these records to be written as part of a scheduled automation chain.
You must determine if the automation chain has been disabled, but you are not familiar with which automation chain should perform this action. As the first step in identifying the automation chain, you need to search for any of its associated resources.
In this situation, which process would guarantee that you have the correct associated resources of the automation chain?

• A.From Administration > Administration Log: search for "HistoricalPartKPI" in Input Records and Scenarios.
• B.From Administration > Automation Log: search for "HistoricalPartKPI" in Automation Task Log.
• C.From Tools > Search Resources: search for resources based on the table "HistoricalPartKPI".
• D.From Tools > Search Resources: search for resources containing the text "HistoricalPartKPI".