Kinaxis Certified RapidResponse Author Level 3 : KX3-003

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. 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.
• B. 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.
• C. 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.
• D. Create a $DmdCountry text workbook variable with the expression UserInGroup ($User,
  'DemandPlanners'). Add the $DmdPlanners = TRUE expression to the worksheet.

Explanation: Only visible for TestPDF members. You can sign-up / login (it's free).

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 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.
• B. 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.
• C. 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.
• D. 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.

Explanation: Only visible for TestPDF members. You can sign-up / login (it's free).

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?

• A. From Administration > Administration Log: search for "HistoricalPartKPI" in Input Records and Scenarios.
• B. From Administration > Automation Log: search for "HistoricalPartKPI" in Automation Task Log.
• C. From Tools > Search Resources: search for resources based on the table "HistoricalPartKPI".
• D. From Tools > Search Resources: search for resources containing the text "HistoricalPartKPI".

Explanation: Only visible for TestPDF members. You can sign-up / login (it's free).

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

Explanation: Only visible for TestPDF members. You can sign-up / login (it's free).

A user wants to build a crosstab worksheet that shows historical data in daily buckets for the last two years.
Currently, historical data is stored in days.
What are two ways to accomplish this task? (Choose two.)
Choose 2 answers

• A. Enable Advanced Bucketing, select Day in the Bucket Size and 365 in the Number of Buckets, and then adjust the Anchor date by 1 Year.
• B. Create calendar interval, start date, and end date variables using the CalendarDate table, and then reference these variables in the worksheet that displays historical data.
• C. Enable the Bucket data by date checkbox, then select Day in the Bucket Size and 730 (365*2) in the Number of Buckets.
• D. Clear the Bucket data by date checkbox and then filter the worksheet for the last 2 years as Date >= MRPDate - 730 and Date <= MRPDate

Explanation: Only visible for TestPDF members. You can sign-up / login (it's free).