Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
OBIEE promt with 'ALL colunmn values' based on a condition is not applying to report

Hi,
My Prompt value which has 'ALL column values' is not applying ot the report.
I have three prompt in report. First prompt is text box and other two prompt is depends up on the first one. second prompt value will change based on the first prompt and it contains 'All column values';
And first and second prompt are from different dimensions.
One my report will run based on second prompt and not on the first.
so when based on first prompt , second prompt has three values and it comes under all column values. but those three values in second prompt are not passing to my report.Since all column values got selected , it applies all the values comes form the second view, irrespective of the items retried though the first prompt.
How to pass the values tot he report when it comes all column values selected.
Answers
-
create a second prompt using the sql statement
select Column value from table where column name = @{Fistpromptval} (Presentation variable)
hope this will help you
0