Forum Discussion

CatoD's avatar
CatoD
Helper II
1 year ago
Solved

RLS - Give access to all data in one specified table, ignoring RLS rules

Hi,   Problem:  There is already working RLS solution based on dimension with departments (eg. User X has access to Department D.01 etc.) The report contains many KPI's, I need to give the user a...
Need Help
  • amitchandak's avatar
    amitchandak
    1 year ago

    CatoD , Please find the file attached. You need small modifications to have other values. You can do that by subtracting the values Non All from All

     

    I have done this item. Duplicated Item as Item New( You need to use all columns, I used one for column), then I created relation between RLS -> Item ALL -> Item. 

    Hide the Item

    and used only Item all in visual 

     

     

     

Darui6's avatar
Darui6
Frequent Visitor
1 year ago

Hi,

I suppose the department table also has a relation to that other fact table, otherwise there wouldnt be a problem.

 

So you could create a second copy of that fact table, and based on that copied table you can calculate the measure. Make sure to NOT connect that copied table. The the RLS should apply to the original table, but not to the copied one. You can create a copy as a calculated table like this:

Table_Copy = Addcolumns('OriginalTable', add here the columns you need)

 

  • CatoD's avatar
    CatoD
    Helper II
    1 year ago

    Thanks for an answer

     

    Unfortunately it won't work in my situation, because, the data in fact table has to be connected to dimension of department.

    So if visualisation of fact table uses column from dimension 'department', which is connected to RLS table, it won't work.