3 Replies Latest reply on Apr 13, 2017 2:48 PM by Gianni Ceresa

    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