Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

edited Aug 19, 2024 11:09PM in Reporting & Analytics for Fusion 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!