Kinaxis Certified RapidResponse Author Level 3 : KX3-003

You have a report based on an InventoryTransfer table. Due to currency fluctuation, you are asked to report the difference between the future EffectiveUnitTransferCost and the cost to transfer it today.
Which expression will accomplish this task?

• A. EffectiveUnitTransferCost - (CONVERTONDATE(TransferCost, today) / Quantity)
• B. EffectiveUnitTransferCost - (TransferCost / Quantity)
• C. CONVERTONDATE(EffectiveUnitTransferCost, today) - (TransferCost / Quantity)
• D. EffectiveUnitTransferCost - (CONVERTONDATE(TransferCost, ShipDate) / Quantity)

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. Disable the default Site filter.
• B. Ensure a Hierarchy is available for users to select regional distribution sites.
• C. Enable the Include hierarchy columns option.
• D. Select Part as the basis for workbook filtering.

You are asked to create a worksheet that shows which process orchestration activity performers are late and how much they are late for each activity. There could be more than one performer per activity.
How would you accomplish this task?

• A. Create a worksheet based on the ProcessInstance table in the Mfg namespace.
• B. Create a worksheet based on the Activity table in the ProcOrch namespace.
• C. Create a worksheet on the Activity table in the Mfg namespace.
• D. Create a worksheet based on the Assignment table in the ProcOrch namespace.

var dataArray = [[line, orderNo, site, orderType, partName, site, dueDate, quantity]]; var dataSettings = {scenarios: [scenario], filter: fAllParts, siteGroup: sgSite} var wbOrderChng = rapidResponse.workbooks.get({name:'Change Orders', scope:'Private'}, dataSettings); var cmdDeleteData= wbOrderChng.commands.get('DeleteData'); var wsOrderChng = wbOrderChng.worksheets.get('ChangeOrders') Which two lines of code would potentially delete records in a table if they appeared after the code shown in the exhibit? (Choose two.) Choose 2 answers

• A. var executeResult = cmdDeleteData.execute();
• B. var importResult = wsOrderChng.importData(dataArray);
• C. var removeResult = wsOrderChng.remove(dataArray);
• D. var removeResult = wbOrderChng.remove(wsOrderChng.getData());

You have a worksheet based on the IndependentDemand table that includes columns for key fields plus multi-scenario columns for Quantity and EffectiveDemand. You want to highlight the Quantity fields where the value in the comparison scenario is different from the corresponding value in the workbook's baseline scenario. You want your worksheet to be able to highlight differences in several scenarios.
How would you achieve this highlighting?

• A. Define the Quantity column to show Difference, select the scenario comparison filtering option to show Only records with different comparison values, then define conditional formatting for the Quantity column when the respective value is not equal to 0.
• B. Define the Quantity column to show Actual value; add a hidden multi-scenario column, QuantityDelta, to show Difference; then define conditional formatting for the Quantity column when their QuantityDelta field is not 0.
• C. Add a hidden multi-scenario column, RecordID, as show Differences; then define conditional formatting for the Quantity column where RecordID is not equal to 0.
• D. Define the Quantity column to show Actual value, and define an additional hidden column, Quantity0, as !Quantity#0 using "Calculate using grouped results in the previous row or other results"; then define conditional formatting where the Quantity column is not equal to Quantity0.