Chained Prompt in OBIEE 12c doesn't work — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Chained Prompt in OBIEE 12c doesn't work

Received Response
11
Views
4
Comments
Sory
Sory Rank 1 - Community Starter

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

Answers