Multiple Values in Same Attribute

[Sbachu]

I am trying to implement below solution using a value we enter in CP65 (these are scrum teams) 

Tech Rule:

If Users.Custom Property 65 NOT EQUALS "Null"
Then
Assign ROLE::${user.customproperty65}_CFT

Our issue is we have users part of multiple scrum teams. How can we implement same without using multiple Custom properties

Saviynt Suggestion: 

This scenario provides details about assigning an enterprise role to a user based on the dynamic value of 'City' to which the user belongs. For example, let’s assume there are three cities such as: 'LA', 'SFO' and 'Bangalore'. Analogous to these cities, there are three Enterprise Roles defined specifically for each of these 3 cities such as: 'LAFinance', 'SFOFinance', and 'BloreFinance' respectively already available under Roles list page. Now, based on the user's city, which can be 'LA', 'SFO' or 'Bangalore', you want to assign the respective Enterprise Role: 'LAFinance', 'SFOFinanace', and 'BangaloreFinance' to user when a user is created or updated in EIC. To achieve this, define the following parameters in the technical rule:

• Condition:
  • Object: Users
  • Attribute: City
  • Condition: Not Equals
  • Value: null
• Action
  • Object Type: Enterprise Roles
  • Object: ${user.city}Finance
  • Attribute: Assign

[rushikeshvartak]

Value should be unique to match 

[Sbachu]

in your example, lets say the same user is member of multiple cities like LA and SFO at the same time. how would you solve this problem. 

[rushikeshvartak]

Use analytics report

[Sbachu]

can you elaborate on how we can achieve this using analytics report

[rushikeshvartak]

• get values comma seprated using SQL query
• use provision access 
• schedule the report

[dgandhi]

What will be stored in customproperty65? Like LA,SFO,Banglore? and if yes then you want to assign 3 roles to the user?

[Sbachu]

yes, in CP 65 we will store scrum team names like ABC, XYZ, DEF etc.... and based on value we will assign role like ABC_ScrumTeam, XYZ_Scrum team and so on.... 

but the situation we are trying to solve is what if a user is part if multiple scrum teams. i don't want to use one CP for ABC and other for XYZ and create two technical rules. 

ideally i would like to include both in one CP and provision respective roles 

[rushikeshvartak]

Prepare query to exact value this will resolve

[Sbachu]

how to include ABC, XYZ and DEF team names in same CP and ensure user is added to 3 different roles. 

[rushikeshvartak]

You need to add it from source

[Sbachu]

can you suggest what seperator i can use to separate values in same attribute

[rushikeshvartak]

You can use ~

[Sbachu]

any solution for this @dgandhi