-
1. Re: How to create condition with "all column values" in prompt?
960938 Dec 12, 2014 8:37 AM (in response to Debrean Helmy)Its not possible in prompt. You can create column in criteria or in rpd with your condition and use that column in prompt.
-
2. Re: How to create condition with "all column values" in prompt?
Nosenco Victor Dec 12, 2014 8:53 AM (in response to Debrean Helmy)Make your prompt province to set a presentation variable, for example var_province (details in http://gerardnico.com/wiki/dat/obiee/presentation_variable_initialization). Then you can use this variable in sql query from prompt district. Like on screenshot.
To debug a sql expression in prompt you can use "Create analysis by entering simple logical SQL" in dropdown New Analysis.
-
3. Re: How to create condition with "all column values" in prompt?
Debrean Helmy Dec 16, 2014 4:28 AM (in response to 960938)Because "All column Values" only have in Oracle, because in my data do not have all values, in propeties have check "all column values" which i used for this condition. I mean , how to create condition with i check "all column values" in this feature on obiee ?
thanks for ur answer @960938
-
4. Re: How to create condition with "all column values" in prompt?
Debrean Helmy Dec 16, 2014 4:30 AM (in response to Nosenco Victor)i was tried this one, but still not working. I mean, i called variable from variable on prompt too but the result still nothing
-
5. Re: How to create condition with "all column values" in prompt?
FTisiot Dec 16, 2014 8:08 AM (in response to Debrean Helmy) -
6. Re: How to create condition with "all column values" in prompt?
Nosenco Victor Dec 22, 2014 10:27 AM (in response to Debrean Helmy)When in prompt is selected "all column values" to variable is assigned in some cases empty string (''), and in some cases (mostly in answer) null value (ifnull(@{var}, 0) = 0) regardless default value defined in variable expression.
For example prompt sets variable p_var. When you select "all column values" the expression '@{p_var}{default value}' will equals string (''):
'@{p_var}{default value}' = ''
Have you tried to debug a sql expression in prompt in answer from logical sql query?
-
7. Re: How to create condition with "all column values" in prompt?
Felipe_Idalgo Dec 22, 2014 7:47 PM (in response to Debrean Helmy)Please, post here your logical SQL.
.. That you´re using in the prompt
Thanks