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
Tagged:
0