Forum Discussion

MaxSimes's avatar
MaxSimes
Regular Visitor
2 years ago

RLS in Chained Datasets

RLS on Upstream Semantic Model
2 hours ago

Hi Hive Mind,

 

I have been wrestling with this for a few days and am not getting anywhere so figured it was tiem to ask.

 

I have  a semantic Model 'PEPI - NOHH' with RLS set up on the table 'Meterpoint Details'

 

this is working as expected and filters dwon the data on a report that is built from thos model.

 

 

I have now created a new report that is connected to this Model as an Upstream Semantic Model along with another Upstream Model.

 

 

 

 

in this set up the RLS on PEPI - NOHH is no longer working, i cant set up RLS in Desktop as the Report is only using existing Semantic Models....

 

how can i achieve the ame RLS filtration with this setup or is this not possible?

 

Thanks in advance

 

Need Help

3 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    Your report will continue to utilize the RLS of the "other"  semantic models. Please describe what you mean by "no longer working".  How did you test?

  • MaxSimes's avatar
    MaxSimes
    Regular Visitor
    2 years ago

    Hi lbendlin 

    Let me try and give a bit more detail, we use this report emdeded in our Customer Portal, there is currently a report called PEPI - NOHH which is embeded and has been in use for a number fo years.

    The PEPI-NOHH model has the following RLS filter

    [CompanyID] = value(username()) ||
    [HQID] = value(username()) ||
    [REGIONID] = value(username())

     

    The Username() is passed in as an integer value by our portal when the report is loaded.

    I am developing a new report to replace the existing, using data from both the PEPI -  NOHH Model and the HH Data 2 Model.

    If i log into our Portal as as user the PEPI - NOHH tables are not filtrering down based on the logic in the RLS filter on PEPI - NOHH. 

     

    on that basis it appers the RLS of the "other models" is not being utilized

     

    any thoughts would be most appreciated

    • lbendlin's avatar
      lbendlin
      Super User
      2 years ago

      You seem to be passing a userid that has "full access" on that RLS.