A SQL Server Analysis Services (SSAS) cube has roles to define dimension data security.
A role named USA allows users to browse data pertaining to the United States.
A role named Canada allows users to browse data pertaining to Canada.
A user can browse sales data pertaining to the United States but cannot browse sales data pertaining to
Canada.
You validate that the user belongs to the USA and Canada roles.
You need to reproduce the issue in SQL Server Management Studio (SSMS).
Which option should you select? To answer, select the appropriate action in the answer area.Hot Area:
Answer: 