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 reproduce the issue where a user can browse data for the United States but not Canada, despite belonging to both roles, you should attempt to browse data for Canada. Steps: 1. In the Adventure Works dimension editor, under 'Country' in 'Member Properties', ensure 'Canada' is…

Configure and maintain an analysis services database

Question

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.

Explanation

To reproduce the issue where a user can browse data for the United States but not Canada, despite belonging to both roles, you should attempt to browse data for Canada.

Steps:

In the Adventure Works dimension editor, under 'Country' in 'Member Properties', ensure 'Canada' is selected or checked.
Observe the results to verify that no data or restricted data is shown for Canada, thus reproducing the problem.

Topics

#dimension security#role testing#SSMS#multiple roles

Community Discussion

No community discussion yet for this question.

Full 70-466 Practice