Forum Discussion
Manage Security Roles from A Report
We have numerous reports that link to a particular semantic model. This semantic model limits the user to only seeing data for accounts they own. However, one of these reports is a heat map, and we'd...
Hi! You could create another table with aggregated data so that you can still create the map (i.e. aggregate at whatever level you are mapping on, i.e. zip, state, etc), but do not apply your RLS filtering rules to this table that will be used for the map. For example, if you have a sales person tables with a relationship to your fact table and the filter is on the salesperson table, when you make the new summarized table, do not join it to the salesperson table.