In this scenario, what should you do to enable this capability?

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 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.
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 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.

View Answer

Answer: D

Explanation:

This setup allows for flexible data visibility based on user permissions. By creating a profile variable that contains the allowed countries for each user, you can then apply a filter expression to the worksheet that evaluates this variable. If a user is permitted to see all countries (indicated by an asterisk ‘*’), the expression returns TRUE, otherwise, it checks if the demand’s country is in the user’s permitted list.

References:

Kinaxis RapidResponse documentation on configuring data visibility through profile variables and worksheet filters.

Kinaxis training materials on setting up user permissions and responsibility definitions.