Based on this article Advanced use cases of dataset parameters - Amazon QuickSight I created a single–column table with all unique values for my control.
But I want this control to be dynamic based on the dataset parameter I send from my embedded application.
is this something that could be achieved? filters filters-controls-and-parameters
@evgeny55 Hi I saw you have asked similar question to this, were you able to figure this out?
You pass parameter as part of the javascript sdk
in my webpage i have the following parameters and the value to be passed.
{
Name: 'pmembertype',
Values: ['member'],
}
,
{
Name: 'pstartstionname',
Values: ['Adler Planetarium'],
}
The same parameter is defined in my customsql
Default values for pmembertype is casual , pstartstionname is Eckhart Park
The dashboard displays the values which have been defined in my webpage code.
The controls are created by connecting to a different dataset which shows all the values
Changing the value in my application code , does display the same in my dashboard.
Name: ‘pstartstionname’,
Values: [‘900 W Harrison St’]
Kind regards,
Koushik
hi @Koushik_Muthanna the dataset am using to connect to the controls (in your case divvy_trip_data) is also based on a dataset parameter.
e.g. following is the query
select distinct company_name from companies where user_id=<<$UserId>> and am passing this UserId from embedded application
when I change the user_id from my application the dropdown is not having any effect, it is just loading based on default values
That is currently not supported.
1/ You would need still a dataset with all the unique values without any dataset parameters [userid and companyid].
2/ the analysis userid parameter , you can create a control and map it to the dataset in step 1
3/ the analysis companyid parameter, you can create a control and map it to the dataset in step 1
4/ set relevant values in company id control so that it displays data only for userid selected Adding filter controls to analysis sheets - Amazon QuickSight ( cascading control )
This looks like a solution, I can hide the user id parameter as well, let me try.
But I cannot expose user id of other customers to some other customer, but I will try something based on your input, thanks.
But I cannot expose user id of other customers to some other customer, but I will try something based on your input, thanks.
Use row level security in this scenario.
Hi @Oliver_Smith_Iruthay, did this solution work for you? I am marking this reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Community!
RLS is not a possible solution for my challenge, am yet to try runtime filtering.
Hi @Oliver_Smith_Iruthay,
It’s been awhile since we last heard from you. Did you have a chance to try out the runtime filtering option or were you able to find a different workaround for your solution?
If we do not hear back within 3 business days, I’ll go ahead and close out this topic.
Thank you!
Hi @Oliver_Smith_Iruthay,
Since we haven’t heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for any relevant information that may be needed.
Thank you!
