User IP Address Row Level Security
Hi all, I have a situation where I want to restrict what a user (sales rep) sees based on a site location. For example, if the user logs on from home or Site A, they see all sales; if they log on from Site B, they only see their sales. It's a case where the user is being mentored into a management role, but when at Site B, they don't want prying eyes (open office) to notice that they have more access than everyone else. I was wondering if I could somehow get the IP address where they are logged on, and I could restrict what they see. Any ideas? Thanks Steve
Manage Security Roles - Row Level Security summary figures
Hi all, My dashboard shows sales and call figures for by postcode, territory, region and national levels. I have assigned Sales reps who can only view sales and calls by their territory, whilsts Regional Sales reps can view sales and calls by their region and the split by territory whilst a select group can view all sales and calls by each region and territory. Is there a way where the Sales rep can still only view their territory but can see the total for their region and the total national figure, and the same for Regional sales reps, can they view their full region breakdown but also the national roll up? The purpose is so that each viewer can see how they are comparing to 1. National Figures and 2. Their Region. Thank you in advance!!
Static Row Level Security
Hello, I have created row level security roles based on products on the Desktop. On the server, after uploading the report, setting the security configurations, I have configured some of the users to each role. But, I realised that me and my collegues are not assigned to a specific role can not view the report. Instead they receive the message "This visual contains restricted data: to view this visual contact the dataset owner to request acess to the data behind it" How can I configure it and the back-officers view the report filtered to the product they are responsible for (roles) and all the other viewers (managers, directors and my team) to all the data? Thank you in advance, Eleftheria
Data is not restricted after applying RLS
I have a master data table and a user group dimension table. And they are joint together in the data model. The use case is, I want to give certain viewer only partial data visiablity to a specific group(usergroup). I was trying to do so by applying RLS (row level security). For example, I created a role where group(aka. usergroup, a column in user group dimension table) = "Technical Team". Then I tested this role by 'View As' function. You can see from the screenshot, the drop down content of group(usergroup) slicer is indeed being limited to "Technical Team". However, the data didn't actually change or say being limited until I clicked on "Technical Team". For some reason, this Role is working superficially, not restricting the data in an automated way.
