OTBI Dashboard Prompt with Presentation Variable - dependent

Summary:

Trying to create multiple prompts using presentation variable. goal is that prompt 2 will be dependent to filter values from prompt1 but using the variables. Is this possible or what is the correct syntax approach.

Content (required):

Goal is to filter the position LOV using under the person.

prompt 1 person

prompt2: position

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

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

 SELECT "Position"."Position Name" FROM "Workforce Profiles - Person Profile Real Time" 

  WHERE "Worker"."Employee Name" = '@{P_EMP_NAME}['@']'

  FETCH FIRST 65001 ROWS ONLY