Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

Actionable Analytic- How to add multiple Entitlements

sureshchalla
New Contributor
New Contributor

Hello 

We want to create actionable analytics report to assign  2 different entitlements. is this possible?

Until now, we used Actionable Analytics to assign only one entitlement, as the entitlement value key needs to be specified in the query. If we try to specify 2 entitlement value keys, it does not work.

We need your confirmation, if it  is possible to assign multiple entitlements within the same Actionable Analytics Report.

Sample Query:

select
distinct ua.userkey as userKey,
u.username as PersonID,
u.systemusername as SystemUsername,
u.country,
u.companyname,
u.customproperty24 as CompanyCode,
u.employeetype as EmployeeType,
u.customproperty30 as UserHRsource,
u.statuskey as UserStatus,
a.accountkey as acctKey,
a.name as accName,
a.accounttype as "Account Type",
('AAA','BBB') as entvaluekey,
(
select
entitlement_value
from
entitlement_values
where
ENTITLEMENT_VALUEKEY IN ('AAA','BBB')
) as Entitlement,
case when a.endpointkey = 'X' then 'XYZ' else a.endpointkey end as 'Endpoint',
'Provision Access' as Default_Action_For_Analytics
from
users u
join user_accounts ua on u.userkey = ua.userkey
join accounts a on ua.accountkey = a.accountkey
join endpoints e on a.endpointkey = e.endpointkey
join entitlement_types et on e.endpointkey = et.endpointkey
join entitlement_values ev on et.entitlementtypekey = ev.entitlementtypekey
where
ua.userkey in (
select
distinct u.userkey
from
users
join user_accounts on users.userkey = user_accounts.userkey
join accounts on user_accounts.accountkey = accounts.accountkey
where
accounts.endpointkey = 'X'
)
and a.accountkey in (
select
distinct accountkey
from
accounts
where
endpointkey = 'X'
)
and u.customproperty30 = 'ABCD'
and u.statuskey = 1
and lower(u.customproperty5)=lower('Yes')
and not exists (
select
distinct ua1.userkey
from
user_accounts ua1
inner join account_entitlements1 ae1 on ua1.accountkey = ae1.accountkey
where
ua1.userkey = ua.userkey
and ae1.ENTITLEMENT_VALUEKEY in ('AAA','BBB','CCC')
)
and a.STATUS = 1
and a.accounttype = 'Primary'

 

Thanks 

Suresh

 

2 REPLIES 2

NM
Regular Contributor III
Regular Contributor III

Hi @sureshchalla , use union define another query with the second entitlement to be assigned

rushikeshvartak
All-Star
All-Star

Use UNION in query to show multiple entitlement value


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.