Categories
- All Categories
- 75 Oracle Analytics News
- 7 Oracle Analytics Videos
- 14K Oracle Analytics Forums
- 5.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 40 Oracle Analytics Trainings
- 59 Oracle Analytics Data Visualizations
- 2 Oracle Analytics Data Visualizations Challenge
- 3 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
OBIEE Presentation Variable in Prompt
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?
0 -
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}')))
0 -
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.
0