KX3-003

You have a worksheet showing work orders. You are asked to report the date used to convert the calculated field EffectiveUnitPrice. Which expression will accomplish this task?A . DATEVALUE(EffectiveUnitPrice)B . CONVERTONDATE(EffectiveUnitPrice, $ConversionDate)C . DATETIMEVALUE(EffectiveUnitPrice)D . ASSOCIATEDDATE(EffectiveUnitPrice)View AnswerAnswer: B Explanation: To report the date used to convert the calculated field EffectiveUnitPrice,...

You have a crosstab, bucketed worksheet that shows forecast records. There are forecast records on the first workday of every month for 18 months from the Planning Date. The bucket settings are set for 52 Weeks from the Planning Date. You want to improve performance for this worksheet, but still...

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?A . Group the component worksheets by Part.Name, Part.Site and Order.ID. In the composite worksheet...

You want to compare the performance of two similar worksheets in a private scenario, but you need to ensure that neither worksheet takes advantage of cached results. In this situation, before capturing the performance results, how would you accomplish this task?A . Close the workbook and reopen it.B . Close...

You are asked to create a workbook that identifies the change in IndependentDemandAvailableDate in workdays from a child scenario to its parent. Which worksheet properties shown in the graphic identifies the correct configuration and expression?A . IB . IIC . IIID . IVView AnswerAnswer: B Explanation: The worksheet properties shown...

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 need to create a new custom field to be used for record filtering that will be populated with the salesperson's name. Each order will have a single associated salesperson's name. Following database design principles and Kinaxis best practices, which action accomplishes this task?A . Create a new Salesperson table...

You have a new demand for 800 units of a product. SourceRule.AllotmentRule for this part is set to OnGoing. Referring to the graphic, which planned order results will be created to satisfy this demand?A . Supplier1: quantity 250 Supplier2: quantity 750B . Supplier1: quantity 750 Supplier2: quantity 250C . Supplier1:...

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?A . AvailableRuleB . DemandTypeC . OrderPolicyD . SupplyTypeView AnswerAnswer: A Explanation: The AvailableRule control table is used to define how available dates...