Need to send BIP bursting excel output as a url in email instead of attachment

User_LJKSA

Hi

I have created a report where I can mail the excel output as an attachment. I need to mail that same excel as a url and not as an attachment. I have set "send email as url " option in admintration-> delivery configuration.

I can send pdf output as a url but not the excel one. PFB my bursting query:

SELECT DISTINCT 1 KEY,

'PayablesQueueListReport' TEMPLATE,

'en-US' LOCALE,

'xlsx' OUTPUT_FORMAT,

'EMAIL' DEL_CHANNEL,

'EMAIL_BURST_OUTPUT' OUTPUT_NAME,

EMAILID PARAMETER1,

'namita.x.singh@oracle.com' PARAMETER2,

'namita.x.singh@oracle.com' PARAMETER3,

'Payables Queue List Report' PARAMETER4,

'PFA the report.' PARAMETER5,

'false' PARAMETER6

FROM (SELECT trim(email_id) as EMAILID FROM (SELECT

 REGEXP_SUBSTR(:P_Notify, '[^;]+', 1, LEVEL) AS email_id

FROM

 dual

CONNECT BY

 REGEXP_SUBSTR(:P_Notify, '[^;]+', 1, LEVEL) IS NOT NULL))

Regards

Namita

RanaAshutosh-Oracle

Thank you for visiting the Oracle Analytics Cloud and Server Forum to seek support. 

Unfortunately, this Forum does not provide support for Oracle Analytics Publisher (BIP). 

However, you can visit Oracle Analytics Publisher (BIP) Forum to receive support from our BIP experts.

Mallikarjuna Kuppauru-Oracle

HI @ User_LJKSA

Below are the available options you can able to use.

Adding Bursting Definitions (oracle.com)

I don't think you can able to send the Attachment as URL link Using Direct Bursting Option,i hope you are trying to use the SAVE_OUTPUT output as OUTPUT_FORMAT.?

You can save the ouptput in shared path and then share the same as EMAIL .

Other comments are welcome.

Regards,

Arjun

SAHAD

Hi @User_LJKSA ,

Can you please let me know if you were able to achieve this?

Rini_Varghese-Oracle

HI @User_LJKSA and @SAHAD, kindly let us know if you were able to achieve this requirement