Active Organization Name for Prompt

Summary:

Hi - I have a BI report that we're using for a dashboard along with some prompts for filtering the report. We have a Business Area (Division) filter but I wanted to take it a step further and only show the active Business Areas in the prompt. It looks like this is not a field that can be reported on in OTBI from what I can see. Any ideas on what I can do?

This is the current SQL that I'm using for the dashboard prompt:

SELECT SUBSTRING("Organization Hierarchy"."Level 02 Organization Name" FROM POSITION(' ' IN "Organization Hierarchy"."Level 02 Organization Name")+1 FOR 40) FROM "Workforce Management - Worker Assignment Real Time" WHERE "Organization Hierarchy"."Level 02 Organization Name" IS NOT NULL FETCH FIRST 65001 ROWS ONLY