Employee hierarchy under a manager - need help passing manager person number as a prompt

Summary:

I am writing a report to show all reports (direct or indirect) under a manager. I am getting the list by hard coding the manager ee# in my OTBI report. Since it is used at multiple places, I want to take manager person number as an input prompt and then pass to my query. Let me know if any suggestions. Thanks.

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):