Automating Discoverer to Blitz Report Migration

For mass migration of individual Discoverer worksheets based on usage history, you should utilize the PL/SQL procedure `xxen_api.import_discoverer_worksheet`. This API allows you to specify parameters like the workbook and worksheet names, along with the EUL (End User Layer). To filter based on recent usage, you should run a precursor script, such as the provided `mass_import_discoverer_worksheets.sql` example, and adjust its criteria to restrict the import to reports accessed within the past 180 days. Note that this process is incredibly efficient, often taking only about 10 minutes for 1000 reports.

Yes, consolidation is a key feature, especially when migrating from older tools like Discoverer. Instead of importing individual worksheets, you should use the `xxen_api.import_discoverer_folders` API or the corresponding menu option, ‘Discoverer Folders’. This process consolidates reports by importing only distinct folder or view object combinations. If multiple workbooks share the same foundation, they will be converted into a single Blitz Report with multiple templates representing the different column selections from the original workbooks, greatly simplifying maintenance.

The ‘Expand Views’ option controls whether the underlying view definitions are converted into subqueries within the imported Blitz Report SQL. Setting this to ‘All’ means that folders based on database views will have their view definition SQL imported directly into the Blitz Report as a subquery, instead of simply selecting from the view name. This is beneficial because it allows you to maintain and modify the SQL directly within the Blitz Report form, eliminating the need to recompile the view in the Oracle database whenever changes are needed.

Yes, proper prerequisite configuration is essential. The Blitz Report Discoverer import relies heavily on execution statistics collected by Discoverer, which populate the database table `EUL5_QPP_STATS`. To ensure these statistics are properly collected, you need to verify two critical profile settings in the Discoverer server configuration file (`pref.txt`) under the `[Database]` section: `QPPEnable` must be set to `1` and `QPPCreateNewStats` must also be set to `1`. Furthermore, users must properly exit Discoverer Desktop or Plus using the File>Exit menu to write the history information to the table.

Yes, Blitz Report provides APIs for migrating several reporting technologies. BI Publisher reports can be migrated programmatically using the PL/SQL procedure `xxen_api.import_concurrent_program`, specifying the application short name and the concurrent program name. There is an example script, `mass_import_bi_publisher_reports.sql`, available for importing all custom BI Publisher reports with a data source starting with `XX%`. Similarly, reports from Excel4apps Reports Wand and Oracle Enterprise Command Center datasets can also be imported using APIs.