Home › Discussions › Questions & Answers › Execution of BI Publisher Pre-Report Triggers

Execution of BI Publisher Pre-Report Triggers

Avatar photoCustomer Questions & Answers 3 replies

Many of our BI Publisher reports rely on `beforeReportTrigger` to populate temporary tables. How does Blitz Report handle and execute this trigger logic during or before the report execution?

3 replies

  • Support Enginatics

    When a BI Publisher report is imported, the original data definition XML is stored in the BIP Code field of the Blitz Report setup. When this field is populated, Blitz Report automatically executes the `dataTrigger` section, such as the `beforeReportTrigger`, of the associated XML template before it executes the primary report SQL.

  • Avatar photoCustomer

    So, reports that depend on data preprocessed into global temporary tables are supported?

  • Support Enginatics

    Yes, this feature allows running BI Publisher report SQLs that rely on PLSQL code to populate data into global temporary tables prior to execution.

  • You must be logged in to reply to this post.