How can you make sure that each category manager can see sales of their category only and the CEO to see all sales in the same report?

How can you make sure that each category manager can see sales of their category only and the CEO to see all sales in the same report?

• A. Create one report for each category manager, with a different category filter in each report, and a separate report for the CEO.
• B. Implement Dynamic row-level security.
• C. Create a category slicer in the report.
• D. Share a single report without restrictions.

Answer: (B)

Implementing dynamic row-level security is the most effective solution in this scenario because it allows you to create a single report that can display different data based on the user's role or identity. By applying row-level security, you can control the data that each user can see while accessing the same report. For category managers, this means they would only have access to the sales data pertinent to their specific category. The CEO, on the other hand, would have permissions to view all sales data within the same report since the security rules can be defined to grant broader access for higher-level roles like that of the CEO. This approach is efficient as it avoids the need to create and maintain multiple reports, streamlining access control and reporting management. In contrast, creating individual reports for each category manager, along with a separate report for the CEO, complicates the reporting process. It requires redundant efforts in both report creation and maintenance, making it more cumbersome to manage changes across multiple reports. Using a category slicer could provide a way for users to filter the data in the report but doesn’t enforce data visibility based on roles. Anyone viewing the report would still be able to interact with the slicer and potentially access data outside of their category, not fulfilling the requirement of

Implementing dynamic row-level security is the most effective solution in this scenario because it allows you to create a single report that can display different data based on the user's role or identity. By applying row-level security, you can control the data that each user can see while accessing the same report.

For category managers, this means they would only have access to the sales data pertinent to their specific category. The CEO, on the other hand, would have permissions to view all sales data within the same report since the security rules can be defined to grant broader access for higher-level roles like that of the CEO. This approach is efficient as it avoids the need to create and maintain multiple reports, streamlining access control and reporting management.

In contrast, creating individual reports for each category manager, along with a separate report for the CEO, complicates the reporting process. It requires redundant efforts in both report creation and maintenance, making it more cumbersome to manage changes across multiple reports.

Using a category slicer could provide a way for users to filter the data in the report but doesn’t enforce data visibility based on roles. Anyone viewing the report would still be able to interact with the slicer and potentially access data outside of their category, not fulfilling the requirement of