Prompt filtering based on another prompt

Vasco

Hi,

I have 2 prompts as presentation variables.

The first one is COURSE_COUNTRY:

and the SQL statement is the following:

SELECT "Workforce Learning - Learning Management Real Time"."Course Specific Details"."WLF_LI_COURSE_DESC_COUNTRY_"

 FROM "Workforce Learning - Learning Management Real Time"     

 where "Workforce Learning - Learning Management Real Time"."Course Specific Details"."WLF_LI_COURSE_DESC_COUNTRY_" is not null 

FETCH FIRST 65001 ROWS ONLY

The second one is COURSE_COUNTRY:

and the SQL statement is the following:

SELECT "Workforce Learning - Learning Management Real Time"."Offering Specific Details"."Course Name"FROM "Workforce Learning - Learning Management Real Time"

WHERE "Learning Evaluations"."Response List LongText" IS NOT NULL
AND "Course Specific Details"."WLF_LI_COURSE_DESC_COUNTRY_" IN (@{COURSE_COUNTRY})

FETCH FIRST 65001 ROWS ONLY

I want the second prompt to filter when selecting a country on the first one, I tried "AND "Course Specific Details"."WLF_LI_COURSE_DESC_COUNTRY_" IN (@{COURSE_COUNTRY})" but it doesn't seem to work for some reason.

Can someone advise?

Raghavan p-Oracle

Hi,

Check this thread if it helps:

https://community.oracle.com/customerconnect/discussion/546466/creating-dependent-prompt-in-otbi-analysis

Regards,

Raghavan