4 Replies Latest reply on Apr 13, 2017 8:10 AM by Christian Berg

    Chained Prompt in OBIEE 12c 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