Using dashboard prompts on multiple-subject area analysis

Summary:

Using dashboard prompts on multiple-subject area analysis

Content (required):

Hi all,

I created an analysis to track a specific group of managers (narrower than the default definition tracked by the "manager flag", because I need managers of employees only, both permanent and fixed-term) using the "Work relationship real time" subject area and the "Person real time" to get the gender of these managers. I used a logical SQL query to join the two.

I added the analysis to a dashboard and also included a prompt linked to the Business Unit and Department fields in "Work relationship real time". However, when I run the dashboard, the prompt doesn't work at all. Should I use a variable instead?