Home › Discussions › Questions & Answers › BI Publisher Conversion: Blitz Report for Rapid Migration and XML Template Elimination

BI Publisher Conversion: Blitz Report for Rapid Migration and XML Template Elimination

Avatar photoCustomer Questions & Answers 5 replies

Modifying existing Oracle BI Publisher (BIP) reports requires specialist developer resources and time-consuming XML layout redesign, slowing our critical operational reporting process down significantly. We need a method to bypass this complex template development and migrate the underlying BI report logic directly to a tool capable of rapid report development with instant Excel output. How effective is Blitz Report’s import function for transitioning our BI Publisher reports, such as the ‘All Inventories Value’ report?

5 replies

  • Support Enginatics

    The complexity and time sink associated with BIP’s XML template designs are major issues, often delaying changes by several days. Blitz Report offers a significantly faster method by allowing you to directly import the SQL logic from standard Oracle BI Publisher reports, drastically reducing development time to mere minutes.

  • When importing a complex report like ‘All Inventories Value’ (which uses the `CSTRAIVR_XML` package), does Blitz Report handle the parameters and assignment automatically?

  • Support Enginatics

    Yes, during the import process, the underlying SQL query from the BI Publisher package is captured, and the original Oracle report parameters and assignments are automatically converted by Blitz Report. This ensures functional consistency while allowing immediate testing and modification in the new environment.

  • If we need to make simple changes, like removing unnecessary columns, does this still require accessing the underlying SQL code?

  • Support Enginatics

    Minor changes, such as removing or re-sequencing columns, can be handled by non-developers using the Blitz Report Column Template function in the Options menu, without touching the underlying SQL. This highly flexible feature reduces IT dependency and enhances user control over the final report layout.

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