We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

BIP Bursting

Accepted answer
61
Views
2
Comments
edited Mar 18, 2020 7:06PM in Reporting & Analytics for B2B Service 2 comments

Summary

BIP Bursting

Content

Hi,

I have a requirement to send report output to different owners with the email attribute in the table. Here is what I did,

1. Create a BIP report with bursting. Here is the bursting query,

select 
bp.id as "KEY",
'xlsx' OUTPUT_FORMAT,
'EMAIL' DEL_CHANNEL,
res.email_address PARAMETER1,
'***' PARAMETER2,
'***' PARAMETER3,
'***' PARAMETER4,
'***' PARAMETER5,
'true' PARAMETER6,
'***' PARAMETER7
from SVC_REF_ENTITIES bp, jtf_rs_resource_profiles res
where bp.attribute_category = 'BP_c'
and bp.owner_resource_id = res.resource_profile_id
and res.email_address in ('***', '***')

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!