Categories
- All Categories
- 145 Oracle Analytics News
- 27 Oracle Analytics Videos
- 14.7K Oracle Analytics Forums
- 5.7K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 54 Oracle Analytics Trainings
- 12 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 2 Oracle Analytics Industry
- Find Partners
- For Partners
Presentation variable issue
Hi I am using OIBIEE 12.2.1.2.0
My issue is like this
I have a prompt page, analysis and a drill down from analysis,
I have to pass one parameter from prompt page to drill report, that prompt is not shown on a report from which drill down is made, so i cant make just is prompted filter on a drill report
i am talking about checkbox and when nothing is selected my presentation variable is not filling with values,and i need that it fills with all values , how can i make some sort of override?
Like nvl((@P_PROMPT), column_values)
Notice:
It is not an option that I put all values as a default values on prompt!
Thx, Matija
Answers
-
Hi,
try a case statement on the filter so when your default {AllValues} is selected it does the equivalent of 1=1 on the filter
case when @{PresentationVariable} = 'AllValues' then TheColumnBeingFiltered else @{PresentationVariable} end = TheColumnBeingFiltered
Btw - did you abandon the other questions from yesterday - it is good form to close them as minimum, better to mark what was correct / helpful - or people do tend to stop helping you...
0 -
Hi,
Below filter will fulfill your requirement.
COLUMN_NAME in (@{PRESENTATION_VARIABLE}['@']{COLUMN_NAME}) OR
'1'= IFNULL('@{PRESENTATION_VARIABLE}['@']','1')
This will help to pick multiple values. If no value is selected, OR 1=1 will pick all values
0 -
Is your issue resolved or do you need more help on this?
0 -
Will try it tommorow
0 -
Where do I place that filter iI place it like this
OR should i place the same expression like this, it doesnt work both ways it like this
Can you tell me what i do wrong.
0 -
The latter of your two attempts, definitely NOT the function palette!!
I usually convert filter to SQL and then do this.
0 -
Thx man, it worked when i converted filter to SQL.
Best regards, Matija
0