Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 39 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 276 Oracle Analytics and AI News
- 50 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 102 Oracle Analytics and AI Trainings
- 17 Oracle Analytics and AI 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
