Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

Oracle BI Publisher, ​Email bursting, attach the report and formatted text in the body of the email

Received Response
618
Views
4
Comments
Gabriele Bertaina
Gabriele Bertaina Rank 2 - Community Beginner
in Oracle Analytics Cloud and Server

Summary

Oracle BI Publisher, ​Email bursting, attach the report and formatted text in the body of the email at the same time.

Content

Oracle BI Publisher, ​Email bursting, attach the report and formatted text in the body of the email at the same time.

​​At the moment I can attach my report, for example as pdf or excel, but the body of the email, is plain text. (Parameter5)

​

​Any suggestion?

​

​Can we have a report as email body and a different report as attachment? At the same time?

​​Why the report can be the body of the email OR the attachment?

​

Thanks G.

Answers

  • Gabriele Bertaina
    Gabriele Bertaina Rank 2 - Community Beginner

    Hi Brajesh,

    Thanks for your answer.

    I have tryed to put in the parameter5 (body) formatted html, but the attribute is not rendered correctly, it shows the html syntax.

    image

    I'm not sure of what you mean with use the body as HTML.

    This is a sample of my bursting query:

    SELECT DISTINCT

    :P_TEMPLATE as TEMPLATE,

    'en-AU' LOCALE,

    'pdf' OUTPUT_FORMAT,

    :P_OUTPUT_NAME as OUTPUT_NAME,

    'EMAIL' del_channel,

    :P_EMAIL_TO PARAMETER1,

    :P_EMAIL_CC PARAMETER2,

    :P_EMAIL_FROM  PARAMETER3,

    :P_EMAIL_SUBJECT PARAMETER4,

    :P_BODY as PARAMETER5,

    'true' PARAMETER6,

    :P_REPLY_TO PARAMETER7,

    :P_EMAIL_BCC PARAMETER8

    FROM DUAL

    if I put "html" as OUTPUT_FORMAT the report will be rendered an not attached; even if I have true as parameter6.

    Could you please give me a sample?

  • Brajesh Shukla-95078
    Brajesh Shukla-95078 Rank 7 - Analytics Coach

    Hi,

    If you want attachment as message body, then you can use your message body as HTML tags and from the HTML you can call PDF  file to embed that as body.

    Let me know if you face issue in syntax?

    Regards,

    Brajesh

  • Mdibrahim Karur
    Mdibrahim Karur Rank 2 - Community Beginner

    Hi,

    Use the below code in control file message section.

    <xapi:message id="12345678" to="${CP_TO_ADD}" cc="${CP_CC_ADD}" attachment="true" content-type="text/html" subject="sfagsgsdgsdga" >

    Thanks

    Md Ibrahim

  • Mdibrahim Karur
    Mdibrahim Karur Rank 2 - Community Beginner

    Hi,

    Check the control file used for bursting , that it allow html data also.

    If required any help, share your control file here. mdibrahim.karur@gmail.com

    Regards,

    Md Ibrahim