Forum Stats

  • 3,853,696 Users
  • 2,264,256 Discussions
  • 7,905,434 Comments

Discussions

OBIEE 12c chained prompts doesn't work

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

Tagged:
Thomas Dodds

Answers

This discussion has been closed.