Войти
  • 15510Просмотров
  • 4 года назадОпубликованоME_2_CS

Bursting In Oracle BIP Report

This video explain in detail how we can add bursting in Oracle BIP. It also explains how we can create a ESS job for BIP Report. Video Link for how to create parameters in Oracle BIP: Link for bursting document: Extraction Query: SELECT SEGMENT1, VENDOR_NAME, BUSINESS_RELATIONSHIP, TRUNC(CREATION_DATE) FROM POZ_SUPPLIERS_V WHERE SEGMENT1 IN ('10001', '10003', '10004', '3997', 'DT5678') Bursting Query: SELECT BUSINESS_RELATIONSHIP KEY, 'SUPPLIER_INFO_REPORT' TEMPLATE, 'en-US' LOCALE, 'PDF' OUTPUT_FORMAT, 'EMAIL' DEL_CHANNEL, 'ME_2_CS' OUTPUT_NAME, 'recipient_email' PARAMETER1, 'no-reply@ ' PARAMETER3, 'SUPPLIER INFO' PARAMETER4, 'PLEASE FIND THE DETAIL IN THE ATTACHMENT' PARAMETER5, 'true' PARAMETER 6 FROM POZ_SUPPLIERS_V WHERE SEGMENT1 ('10001', '10003', '10004', '3997', 'DT5678')