Q17. You are tasked with creating a dashboard for sales data. Different users from various regions should only see data relevant to their specific region. How can you restrict the data users see based on their region while using filters?
Ans: To restrict the data that users can see based on their region in SAP SAC, we can use the concept of Data Access Control and Row Level Security. Here’s how we can do it using filters and security settings:
– Enabling data access control in the model by finding the dimension to determine the access control.
– Now assign the region access using the data access control table one for read access and other for write access.
– Use the input controls or story filters on optional basis, if required. We can add input control on the basis of region.
– Validate the role testing by using the “view as” option to simulate different users for using the stories and validate the data restriction.
This is true data restriction where users can’t even query or see the data they aren’t authorized for.
I am going to post new Real-Time Scenerio Based SAC – Q/A for next 30 days. Check it out on acorporateguy.com – Prepare For Your Next Interview !!
Schedule your SAC Mock Interview Session/How to prepare for Interviews” with ME: https://topmate.io/vartika_gupta11/1375779
Get your “33 Real Time Scenerio Based Ques & Ans” PDF – part 1 now: https://topmate.io/vartika_gupta11/1523015
Get your “33 Real Time Scenerio Based Ques & Ans” PDF – part 2 now: https://topmate.io/vartika_gupta11/1523041
Get your “150 Common Questions only list for SAC Interview Preps” now: https://topmate.io/vartika_gupta11/1089505