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
Customizing Prompt value in BI Publisher rtf report
Summary
Prompt value for All option shoud show text - 'ALL' isntead of all the values from the prompt
Content
Hello All,
I got a requirement in BI Publisher Reporting.The users wants to see the prompts that are selected on top of the page in output. Currently they're seeing the selected prompt values. But the latest requirement is when they select 'All' option in the Prompt they're getting all the values in the output which is very huge and users are not interested to see such output which is kinda confusing. So they want to see 'ALL' as text in the output when they select 'All' in the prompts. I'm trying to find a way to get this done.
Is there anyway to do this?. I need some suggestions from you Gurus.
Thank you.
Answers
-
Hi Bhanu.
I'm assuming you will transform your Prompt to bring NULL if ALL is selected.
If that is the case check the post below
Handling null values in bi publisher rtf template
Hope it helps.
Cheers.
Fernando
0 -
Bhanu,
if you check the option 'ALL' then you need to change your code accordingly:
AND (DEPT.DEPT_NAME IN (:p_dept_name) OR 'ALL' IN (:p_dept_name || 'ALL'))
Cheers
1 -
Thank you Fernando. I modified the SQL accordingly and then change the Prompts as you suggested.
Thanks again for the link you suggested.
0