USER ACCESS SETTING FOR VIEWING CERTAIN ACTIVITIES

[ANM_97]

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!!

[v-eqin-msft · Accepted solution]

Hi @ANM_97 ,

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.

[amitchandak]

@ANM_97 ,Measure/formula Not very clear. See if this blog can help

https://www.blue-granite.com/blog/using-dynamic-row-level-security-with-organizational-hierarchies