OBIEE 12c chained prompts doesn't work

Sory Apr 12, 2017 9:11 PM

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

1. Re: OBIEE 12c chained prompts doesn't work

Gianni Ceresa Apr 12, 2017 9:18 PM (in response to Sory)

Why don't you let OBIEE make the work by using the "limit values by" checkbox? As long as your model is correct OBIEE will automatically limit values of your second prompt based on the first one.
Like Show 1 Likes(1)

Actions
2. Re: OBIEE 12c chained prompts doesn't work

FTisiot Apr 13, 2017 2:46 PM (in response to Sory)

+ 1 to Gianni Ceresa
The usage of presentation variables in prompts works only if the selectors are in different prompts objects.
e.g. if you want to influence Product Group by the Brand selected you'll have to put Brand in a separate prompt.
But...You have the "limit values by" feature by default... why don't you use that?
Like Show 0 Likes(0)

Actions
3. Re: OBIEE 12c chained prompts doesn't work

Gianni Ceresa Apr 13, 2017 2:48 PM (in response to Sory)

(for reference)
double posting with Chained Prompt in OBIEE 12c doesn't work

So now that both threads are in the same forum it makes it more obvious why it isn't a smart idea to double post ...
Like Show 0 Likes(0)

Actions

Go to original post

Incoming Links

Re: Chained Prompt in OBIEE 12c doesn't work