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?

• A. Map the column id Name to Part.Name in the Forecast worksheet.
• B. Change the table that the spreading worksheet is based on, from Part to IndependentDemand.
• C. Add a Date column to the spreading worksheet.
• D. Map the column id Site to Part.Site in the Forecast worksheet.

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 importResult = wsOrderChng.importData(dataArray);
• B. var removeResult = wbOrderChng.remove(wsOrderChng.getData());
• C. var executeResult = cmdDeleteData.execute();
• D. var removeResult = wsOrderChng.remove(dataArray);

You are asked to restrict a worksheet so that users can only see data for the demand of the countries that they should have permission to see. A field has been added to the IndependentDemand table, which is a reference to a custom table called Country. Each user may have permission to see the demands from one or more countries, and each country can be seen by one or more users. They should be able to see data from multiple countries in the worksheet at the same time.
In this scenario, what should you do to enable this capability?

• A. Create a $DmdCountry profile variable and assign the country names to each user. Add the expression IF ($DmdCountry = "'*'", TRUE, User::DmdCountry IN eval($DmdCountry)) to the worksheet filter.
• B. Create a $DmdCountry text workbook variable with the expression UserInGroup ($User,
  'DemandPlanners'). Add the $DmdPlanners = TRUE expression to the worksheet.
• C. Build a Responsibility definition based on the Country table and assign the users to all of the countries that they should have permission to see. Add a responsibility column to the worksheet so users can select their country.
• D. Create a $DmdCountry list workbook variable with a query generated list of values based on the Country table. Add the expression UserInGroup ($User, 'DemandPlanners') to the variable filter and then in the column properties conditionally hide the column using the $DmdCountry = False expression.

A client wants to provide their sales staff the ability to add forecasts for the global total of demand across all SKUs by each customer by month. The client wants to use their historical demand to allocate from a monthly forecast to a weekly forecast.
Which three actions would accomplish this task? (Choose three.)
Choose 3 answers

• A. Create a workbook variable for Calendar with a value of Month.
• B. Define a custom Insert Definition.
• C. Create a worksheet based on the HistoricalDemandActual table.
• D. Include only columns for Part, Site, and Customer from the HistoricalDemandActual table.
• E. Create workbook variables for Start Date and End Date.

A part has demands on 06-01, 06-04, and 06-05 as shown in the exhibit. The part source has this configuration:
* OrderGenerationRule = 'AfterPTF'
* LeadTime = 2 days
* PTFRule = Lead
* PlanningTimeFence = 2
Referring to the graphic, which table shows the resulting planned orders?

• A. II
• B. III
• C. IV
• D. I