OBIEE 12c chained prompts doesn't work

Sory

I have three field in a dashboard prompt: Carrier, Region, End Period. I want only show the existing Region; I want chain Region to Carrier. I try to do that making Carrier a presentation variable and use in the selection of the values in region in the following way:

SELECT "REGIONS"."REGION"  

FROM "Special_Coverage"."CARRIER","Special_Coverage"."DETAIL SPECIAL COV FACTS","Special_Coverage"."REGIONS" 

WHERE "Special_Coverage"."CARRIER"."NAME CARRIER"= (‘@{CAR}’) FETCH FIRST 65001 ROWS ONLY

But the query doesn’t take the value of the carrier and doesn’t make the filter

Gianni Ceresa

Why don't you let OBIEE make the work by using the "limit values by" checkbox? As long as your model is correct OBIEE will automatically limit values of your second prompt based on the first one.

FTisiot

+ 1 to @Gianni Ceresa

The usage of presentation variables in prompts works only if the selectors are in different prompts objects.

e.g. if you want to influence Product Group by the Brand selected you'll have to put Brand in a separate prompt.

But...You have the "limit values by" feature by default... why don't you use that?

Gianni Ceresa

(for reference)

double posting with Chained Prompt in OBIEE 12c doesn't work

So now that both threads are in the same forum it makes it more obvious why it isn't a smart idea to double post ...