Oracle Business Intelligence

Products Banner

OBIEE Presentation Variable in Prompt

Received Response
2
Views
3
Comments

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

Answers

  • 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?

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

    Version Number:

    imageVersion.jpg

    Prompt:

    imagePrompt.jpg

    Filters in Analysis:

    imageAnalysis.jpg

    Resulting "where" clause in SQL:

    WHERE

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

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

  • 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.