Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Chained Prompt in OBIEE 12c 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
Answers
-
Are you trying it on an actual dashboard rather than just the prompt editor? Don't hold me to it but from memory you won't see the values refresh unless it's on a dashboard
0 -
It will work for sure if the two columns reside in two distinct prompt objects rather than being two columns in one object.
0 -
@Sory : what's the point in replying if you then open a new thread (double posting !!) and do not follow up?
0 -
Good catch. @Sory this isn't how forums work. Close one thread and manage only the other one. Do not double post.
0