Leveraging Intelligent Recommendations for Operational Transformation. AMS Partners click HERE | EMEA/APJ Partners click HERE |
05/03/2024 02:50 AM
Hello Team,
We have a requirement where we have 4 attributes (Region, Market, Geo and country)
If user selects EMEA region then (NWE, CE,SE) should populate under Market and same follows for both Geo and country. To achieve this we have created dataset and it was working as expected.
Now the requirement is it should be multi select
if users selects both EMEA and Americas under region then (NWE,CE,SE and LA,NA) should populate under Market
all the four attributes should be multi select ,
How can we achieve this.
Solved! Go to Solution.
05/03/2024 03:24 AM
Hi @sk ,
You have 4 dynamic attributes. Please use the below configuration in your DA's:
DA1 | Region | SELECT DISTINCT ATTRIBUTE3 AS ID FROM dataset_values WHERE datasetname = 'Regionmarket' ORDER BY ATTRIBUTE3 ASC |
DA2 | Market | SELECT DISTINCT ATTRIBUTE2 AS ID FROM dataset_values WHERE datasetname = 'Regionmarket' and ATTRIBUTE3 in (${region}) ORDER BY ATTRIBUTE2 ASC |
DA3 | Geo | SELECT DISTINCT ATTRIBUTE1 AS ID FROM dataset_values WHERE datasetname = 'Regionmarket' and ATTRIBUTE2 in (${market}) ORDER BY ATTRIBUTE1 ASC |
DA4 | Country | SELECT DISTINCT ATTRIBUTE4 AS ID FROM dataset_values WHERE datasetname = 'Regionmarket' and ATTRIBUTE1 in (${geo}) ORDER BY ATTRIBUTE4 ASC |
Note: Assuming your country values are in attribute4 of dataset table
if this answers your question, please consider selection Accept As Solution and hit Kudos
05/03/2024 04:41 AM - edited 05/03/2024 05:04 AM
05/03/2024 05:05 AM - edited 05/03/2024 05:09 AM
05/06/2024 05:14 AM
Hi @PremMahadikar ,
The above approach is working fine but when we select 2 regions , then the entitlements were not appearing . Am I missing anything here? Please advise
05/06/2024 05:37 AM
@sk,
Are you using 'Config for Requestable Entitlement in ARS' at endpoint -> Entitlement type?
05/06/2024 06:01 AM
Hi @PremMahadikar ,
We are using the below config in ;Config for Requestable Entitlement in ARS' at endpoint
('${region}'='Americas' and ev.customproperty1='1') or ('${region}'='EMEA' and ev.customproperty1='2') or ('${region}'='Asia Pacific' and ev.customproperty1='3')
05/06/2024 06:18 AM
@sk ,
Can you save Americas, EMEA, Asia Pacific in respective entitlement CP1 and just try the below code:
ev.customproperty1 IN (${region})
if this answers your question, please consider selection Accept As Solution and hit Kudos