Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

How to show blank records with Headers displayed for all columns on Conditional basis in OACAgents

Received Response
82
Views
2
Comments

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.

Tagged:

Answers

  • You might be able to approach it two ways.

    1. Have a condition wherein the analysis is not sent if there is no data. (i.e. a condition ROWCOUNT('analysis') > 0 )
    2. 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.

  • Viswanath-Oracle
    Viswanath-Oracle Rank 4 - Community Specialist

    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.