Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

USER ACCESS SETTING FOR VIEWING CERTAIN ACTIVITIES

Hi! I need help with the following issue: I have -a table with the groups to which users belong; (AD_GDWH_GROUPS ) - a table of statuses. (AD_GDWH_GROUP_STATUS) Each employee is part of a grou...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous ,

     

    If the amount of data is relatively small , you could try Static RLS that can be used to restrict data access for given users.

     

    Please follow these steps:

    1. Go to Modeling-->Manage roles to add roles with status filter like this:

    [STATUS] IN {"A","C","D"}
    [STATUS]="B"

    2. Publish the report after creating some visuals.

    3. Select the More options -->Serurity for this dataset, now you could add members/groups(groups are created in Office365).

     

    Best Regards,
    Eyelyn Qin
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous ,

 

If the amount of data is relatively small , you could try Static RLS that can be used to restrict data access for given users.

 

Please follow these steps:

1. Go to Modeling-->Manage roles to add roles with status filter like this:

[STATUS] IN {"A","C","D"}
[STATUS]="B"

2. Publish the report after creating some visuals.

3. Select the More options -->Serurity for this dataset, now you could add members/groups(groups are created in Office365).

 

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.