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?
see data from multiple countries in the worksheet at the same time.
In this scenario, what should you do to enable this capability?
- AOption A:
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
- BOption B:
Create a $DmdCountry text workbook variable with the expression UserInGroup ($User,
'DemandPlanners'). Add the $DmdPlanners = TRUE expression to the worksheet. - COption 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. - DOption 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.
Show answer and explanation
Correct answer: D