Forum Discussion

PhilC's avatar
PhilC
Resolver I
5 years ago
Solved

Multi use dataset and Row Level Security

Hi,   I am creating a dataset to use for multiple reporting purposes.  There are a considerable number of measures being created as well. (I am using DataFlows as the main source of data, not sure ...
Need Help
  • PhilC's avatar
    PhilC
    5 years ago

    After some discussions on a blog post (cannot locate link), determined my use case is probably not possible in a single model.

     

    Workaround approach is to create a dataset/model with RLS included, and consider this the master version.  Any model changes will hapen in this file.  Once it is saved and published, the Security Group will be removed, Save As, then published as a second dataset/model.

     

    Reports then then be built against the appropriate model, either with RLS in place or the one without it.

     

PhilC's avatar
PhilC
Resolver I
5 years ago

After some discussions on a blog post (cannot locate link), determined my use case is probably not possible in a single model.

 

Workaround approach is to create a dataset/model with RLS included, and consider this the master version.  Any model changes will hapen in this file.  Once it is saved and published, the Security Group will be removed, Save As, then published as a second dataset/model.

 

Reports then then be built against the appropriate model, either with RLS in place or the one without it.

 

  • v-xulin-mstf's avatar
    v-xulin-mstf
    Community Support
    5 years ago

    Hi PhilC

     

    Okay, if the issue has been solved, please adopt your solution to help others.

     

    Best Regards,

    Link