OBIEE Presentation Variable in Prompt

Question

Hello,

We have a prompt on a column that sets a presentation variable, pv_XYZ.

In the analysis, we have two columns and we want to set a filter like this:

(   column1 is equal to @{pv_XYZ)

or  column2 is equal to @{pv_XYZ}  )

When we run this, we select the value of "turkey" for pv_XYZ.

The results SQL looks like this:

(   column1 is equal to "turkey"

or  column2 is equal to @{pv_XYZ}  )

Any idea why column2 shows literal string for the presentation variable?

Thanks!

Dennis

Dennis Hancy · Answer

We found the answer.

We were using a column prompt which is only associated with one particular column.

But we later learned that a variable prompt is more generic.  It is not attached to just one column and can be used more freely.

Dennis Hancy · Answer

Here are the screen shots of our set-up.  Let me know if this help.  Thanks!

Version Number:

Prompt:

Filters in Analysis:

Resulting "where" clause in SQL:

WHERE

(    
((    "table"."COLUMN_1" ='turkey')

OR ("table"."COLUMN_2" ='@{pv_1}')))

[Deleted User] · Answer

1.) What exact version? Not "12c", not "12.2.1.2" - what's the exact version like 12.2.1.4.200830"

You're paraphrasing a lot there so I can't really believe that behaviour.

Is the OR normal configuration or did you convert to a SQL filter? Can you screenshot what you really have configured?