Try our Free Demo Practice Tests for Comprehensive KX3-003 Exam Preparation

You are creating an insert definition to insert records using a crosstab worksheet, which contains weekly buckets that begin on Monday. You want the inserted records to be due on Friday of that week but if Friday is a non-workday, you want the inserted record to be due on Thursday. In this situation, how would you set the bucket date in the insert definition?

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

You want to create a composite worksheet using two component worksheets. The group by columns in both worksheets are Part.Name, Part.Site, Order.ID, Order.Site, Order.Type, Order.Type.ControlSet, and Line. How would you improve performance of the composite worksheet?

You want to control how available dates are calculated for your vendor managed parts' supplies and demands. In this situation, which control table would you need to configure?

You want to control how available dates are calculated for your vendor managed parts' supplies and demands. In this situation, which control table would you need to configure?