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 group. And the group has access to a list of statuses.


How should I create the formula so that it returns all the statuses that a user has access to?
Expected Result:
ENTER USER ANDY -> STATES TO WHICH HE HAS ACCESS: A, C, D.
ENTER TED USER -> STATES TO WHICH HE HAS ACCESS: B.

 

I made this measure, but returns only one status:

#View =

LOOKUPVALUE (
DIM_FLOW_STATUS[STATUS_NAME],
DIM_FLOW_STATUS[STATUS_NAME],
LOOKUPVALUE (
AD_GDWH_GROUP_STATUS[STATUS_NAME],
AD_GDWH_GROUP_STATUS[GROUP], LOOKUPVALUE ( AD_GDWH_GROUPS[GROUP], AD_GDWH_GROUPS[USER], USERNAME () )
)
)

 

 

~~Thank youu!!

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.

2 Replies

  • 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.