Categories
- All Categories
- 127 Oracle Analytics News
- 23 Oracle Analytics Videos
- 14.5K Oracle Analytics Forums
- 5.5K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 47 Oracle Analytics Trainings
- 7 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 8 Oracle Analytics Industry
- Find Partners
- For Partners
How to show blank records with Headers displayed for all columns on Conditional basis in OACAgents

Hi,
please let me know if it is possible to send attachment with Blank report included with report headers when 'no records' retrieved rather than sending blank e-mail when delivering an email attachment through agent/ibot in OACS.
Tried conditional basis but it does not allow any attachment when condition is false
Thanks.
Answers
-
You might be able to approach it two ways.
- Have a condition wherein the analysis is not sent if there is no data. (i.e. a condition ROWCOUNT('analysis') > 0 )
- Try and add a custom message in the analysis
To create a custom message to alert users to no data in the results of an analysis:
Edit the analysis to which you want to add a custom message.
Click the "Analysis editor: Results tab."
Click the Analysis Properties toolbar button. The "Analysis Properties dialog" is displayed.
In the No Results Settings box, select Display Custom Message.
In the Header field, enter the text of the header for the custom message.
In the Message field, enter the explanatory text.
Click OK.
Other comments welcomed.
0 -
Thanks Steve for your response, but my requirement is when there are no records, output should be something like below with all headers and no output sent as attachment through mail
Thanks,
Viswanath.
0