Question 1 of 5 | Certs4All

Question 1 / 5

--:--

Question 1

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?

Create a $DmdCountry list workbook variable with a query generated list of values based on the

in the column properties conditionally hide the column using the $DmdCountry = False expression.

Country table. Add the expression UserInGroup ($User, 'DemandPlanners') to the variable filter and then

Create a $DmdCountry text workbook variable with the expression UserInGroup ($User,

'DemandPlanners'). Add the $DmdPlanners = TRUE expression to the worksheet.

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.

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.

Correct Answer

Correct Answer:

You're on the free plan. Get Full Exam Access Unlock all questions, detailed explanations and more.

Get Premium →