Dynamic Default Parameter not working

Q&A
, ,
1

Hi all,
I am trying to set up a DDP on my data. But whenever setting it up for a user it doesn’t work (it does work whenever I try to set it up for a group)

This is what my DDP dataset looks like:

image
image1340×188 10.7 KB

I uploaded it into Quiksight as a dataset. (I know this is not a problem because the DDP works when using groups)

image
image1230×1070 61.6 KB

Whenever logging in with my test account (mateoile41@gmail.com), I see all the data as a default (the DDP is not working)

So I have a few ideas of what might have gone wrong while setting up the DDP.

  1. I think it might have to do with the username:
    I am getting the username from the top right of the Quick Sight page:

    image
    image594×270 9.42 KB

  2. It might have to do with the fact that that dataset has RLS at a group level.
    Does having RLS at a group level prevent you from having DDPs at a username level.

Pls lmk what you think!

2

Hello @mateoleon210, I am not certain applying dynamic defaults on a username will function as expected when Group Level RLS is applied, but I think it should work.

I have 2 recommendations for this:

  1. Are you able to check what the usernames look like from the Manage Quick Sight tab? I suppose it is possible that your username would look like that, but it doesn’t seem likely. Maybe try it with just a single email rather than the 2 emails separated by a “/”.
  2. Quick Sight can be rather specific about naming conventions, so I would change the column name from Viewed-by to UserName (Case sensitive). It is likely that using an alternative name for a UserName field will cause an issue since I know it does when applying RLS.

Let me know if either of these suggestions help! I may be able to work up a test for this locally because the only factor I am not certain about is applying user level dynamic defaults with RLS applied at the group level.

3

Hi @WLS-DM,
After more testing on my end, I realized that RLS and DDPs can work together, even if one of them is at a group level and the other is at a username level.
I believe that it had to do with the fact that the user name column should have been called UserName and not Viewed_by like they recommend here. Creating parameter defaults in Amazon QuickSight - Amazon QuickSight

Thanks for your prompt response!

4

Hello @mateoleon210, I am glad you were able to resolve the issue, thank you for letting me know it worked!