BIP Bursting

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 ('****', '****')

2. Create a report with the BIP data model from #1