3 Months Free Update
3 Months Free Update
3 Months Free Update
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?
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?
You have a worksheet based on the Part table. You want to know the total number of unique customers that have orders for each part.
Which expression accomplishes this task?
You want to enter a forecast for 6000 units of part 89-Prod0966 in the June 8 bucket. You expect that three records will be inserted into the IndependentDemand table (equal quantities of 2000 at each of the three sites); however, you get an error.
Which action would solve the error?
You want to create a workbook command that will modify the existing records on the worksheet shown in the graphic. You want the records to copy the date value in New Due Date to the DueDate field in each record.
What should you change in the worksheet to create the modify command?
The graphic shows a path to generate a list of customer prices with record counts for each table in the path. Given the following filter expression:
Part.ProductNumber.ProductGroup.ProductFamily In ('bikes','trikes')
AND Customer.Country IN ("US", "CA")
In this situation, what is the chosen line of descent from the query engine?
Given the worksheet properties shown in the exhibit, which console output would exist for the following script?
var dataForInsert = [['1','BBy-LCD37','DC-Europe','DCRequest','LCD-3735','DC-Europe','06-01-20',147]];
var wbOrderChng = rapidResponse.workbooks.get({name:'Change Orders',scope:'Private'}, {scenarios: [scenario], filter: {name: 'All Parts', scope: 'Public'}, siteGroup: {name: site, scope: 'Public'}});
var wsOrderChng = wbOrderChng.worksheets.get('ChangeOrders');
var importResult = wsOrderChng.importData(dataForInsert); rapidResponse.console.writeLine(JSON.stringify(importResult));
You shared your scheduled task, shown in the graphic, with a set of users who do not have access to all the resources used in the task.
In this situation, which statement is true?
The tables shown in the graphic are from an SQL database. Shaded fields indicate key fields in SQL.
Which three actions should you take to design this data model in RapidResponse? (Choose three.)
Choose 3 answers
You have a hierarchy called PartFamily that is based on the PartCustomer table. There is a second hierarchy in use, also based on the PartCustomer table called PartPlanner. When the PartFamily hierarchy is used, performance is noticeably worse than when the PartPlanner hierarchy is used.
In this situation, which design issue would contribute most to poor performance?
A part has demands on 06-01, 06-04, and 06-05 as shown in the exhibit. The part source has this configuration:
Referring to the graphic, which table shows the resulting planned orders?
You are developing a worksheet that will be used to run a script through a form. For the script to work properly, you will need to pass information from two columns as script arguments.
Which two actions will accomplish this task? (Choose two.)
Choose 2 answers
Referring to the graphic, the TV Family represents an MPSConfig planning BOM. No supply is available.
What will be the quantity of the planned order created for the TV family?