Role security not being enforced on dashboard prompt

Content

I am using "Workforce Profiles - Person Profile Real Time" to create a list of employee certifications by manger (direct and indirect). The "Matrix Manager"."Top Manager Name" fields works when the top manager is selected. However, the prompt allows any user to select anyone in the company, no security is enforced.

I want all Line Managers to use this dashboard and we have a custom Line Manager role (FM Line Manager).

I was expecting users to only see themselves and employees that report up to them.

Any ideas why the security is not being enforced?

Also, I am using a SQL statement to fill the choice list of the prompt as there were some extra values in there I did not want to show.