Home › Discussions › Questions & Answers › Ensuring BI Publisher Data Triggers Run Before SQL Execution

Ensuring BI Publisher Data Triggers Run Before SQL Execution

Avatar photoCustomer Questions & Answers 5 replies

I have an imported BI Publisher report where the main SQL selects from global temporary tables (GTTs). The GTTs are populated by a beforeReportTrigger. How does Blitz Report execute this logic?

5 replies

  • Support Enginatics

    When a report is imported from BI Publisher, the original data definition XML is stored in the BIP Code field. If this field is populated, Blitz Report automatically executes the dataTrigger section, such as beforeReportTrigger, before running the primary report SQL.

  • Avatar photoCustomer

    So the BIP Code field is vital for any report that relies on PLSQL preprocessing?

  • Support Enginatics

    Yes, it is crucial for reports that rely on PLSQL code, such as those populating temporary tables, to ensure data is prepared before the main query is executed.

  • Avatar photoCustomer

    Is there an easy way to verify the content of the XML template stored there?

  • Support Enginatics

    Yes, you can double click onto the BIP Code field in the report setup window to download and view the associated XML data definition template.

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