Click HERE to see how Saviynt Intelligence is transforming the industry. |
04/30/2024 04:05 AM
Hello Team,
We have a requirement where when an enduser selects a region(EMEA, AMERICA, ASIA PACIFIC),
if user selects EMEA region then it should show (GA,GC) under market, if user selects America region then it should show (NA,LA)
If user selects GA under market then it should show (BALTICS,BULGARIA) under geo, if user selects GC under market then it should show (AFRICA) under geo
Attribute1 - Region
Attribute1- market
Attribute3- Geo
how can we achieve this through data sets.
can someone help on this
Solved! Go to Solution.
04/30/2024 02:49 PM
Hi @sk,
1. Have one to one combination of each record (csv file of UTF-8 encoded max 10,000 records) and upload below combinations
2. Follow the documentation to upload the datasets - Creating Datasets (saviyntcloud.com)
3. Once done, Preview screens
4. Now access the data in dynamic attributes
Single Select SQL Query | ||
DA1 | Region | SELECT DISTINCT ATTRIBUTE3 AS ID FROM dataset_values WHERE datasetname = 'Regionmarket' ORDER BY ATTRIBUTE1 ASC |
DA2 | Market | SELECT DISTINCT ATTRIBUTE2 AS ID FROM dataset_values WHERE datasetname = 'Regionmarket' and ATTRIBUTE3 = '${region}' ORDER BY ATTRIBUTE1 ASC |
DA3 | Geo | SELECT DISTINCT ATTRIBUTE1 AS ID FROM dataset_values WHERE datasetname = 'Regionmarket' and ATTRIBUTE2 = '${market}' ORDER BY ATTRIBUTE1 ASC |
Configure parent and child DA to achieve selected combinations!
If you find the above response useful, Kindly Mark it as Accept As Solution and hit Kudos
05/01/2024 03:51 AM
Hi @PremMahadikar ,
THanks for the response.
I have tried with the above approach but the values are not populating under dropdown for Market and Geo
Could you please let me know if I am missing anything here
05/01/2024 04:11 AM - edited 05/01/2024 05:00 AM
@sk ,
I see the dataset value in region DA, which mean the values are retrieved from dataset table. I believe, the query would be correct in other DA as well.
Please make sure, you have proper parent child mapping.
1. My region DA config
2. My market DA config
Small change in query, use the below. This is working for me.
DA1 | Region | SELECT DISTINCT ATTRIBUTE3 AS ID FROM dataset_values WHERE datasetname = '<your dataset name>' ORDER BY ATTRIBUTE1 ASC |
DA2 | Market | SELECT DISTINCT ATTRIBUTE2 AS ID FROM dataset_values WHERE datasetname = '<your dataset name>' and ATTRIBUTE3=${region} ORDER BY ATTRIBUTE1 ASC |
DA3 | Geo | SELECT DISTINCT ATTRIBUTE1 AS ID FROM dataset_values WHERE datasetname = '<your dataset name>' and ATTRIBUTE2=${market} ORDER BY ATTRIBUTE1 ASC |
If you find the above response useful, Kindly Mark it as Accept As Solution and hit Kudos
05/01/2024 04:54 AM - edited 05/01/2024 05:17 AM
It was working fine, Thank you
05/01/2024 05:00 AM
@sk ,
I missed to mention above, small change is 'remove quotes' in child DA. Its ${region} and not '${region}'
SELECT DISTINCT ATTRIBUTE2 AS ID FROM dataset_values WHERE datasetname = 'Regionmarket' and ATTRIBUTE3=${region} ORDER BY ATTRIBUTE1 ASC
If you find the above response useful, Kindly Mark it as Accept As Solution and hit Kudos
05/01/2024 05:27 AM - edited 05/01/2024 05:32 AM
@sk,
Thats great it worked! Please click the 'Accept As Solution' button on the reply (or replies) that best answered your original question.
For the new requirement,
It works!
If you find the above response useful, Kindly Mark it as Accept As Solution and hit Kudos
05/01/2024 05:17 AM
We have one more requirement
Geo | country (for visibility only) |
Adriatics | Croatia |
Adriatics | Montenegro |
Adriatics | Serbia |
Africa | Slovenia |
If the user select Geo as 'Adriatics' then it should show country('Croatia',Montenegro,Serbia)
if the user selects Geo as ' Africa' then it should show country ('Slovenia')
The country should be for the visibility purpose only no need of selection
could you please advise