Filtering and Consolidating Discoverer Report Imports

The Discoverer import features rely on the History Days parameter to filter reports based on recent execution . This information is derived from the `EUL5_QPP_STATS` table, which stores worksheet query execution statistics upon exiting Discoverer . When using the ‘Discoverer Worksheet’ import option, the LOV defaults to showing worksheets run within the specified number of History Days . For API-based mass migration, such as using `XXEN_API.IMPORT_DISCOVERER_WORKSHEET`, you should adjust the example script’s logic to filter by your desired timeframe (365 days) .

The ‘Discoverer Worksheet’ option imports individual worksheets, resulting in a one-to-one conversion to Blitz Reports , . The ‘Discoverer Folders’ import option is recommended when you need consolidation . It imports only distinct folder or view object combinations . If multiple worksheets rely on the same underlying folders, they are consolidated into a single Blitz Report with multiple templates, significantly reducing the maintenance overhead , .

When consolidating via ‘Discoverer Folders’, the different workbooks and their respective selected columns are converted into Blitz Report templates associated with the consolidated report . If a folder combination was used by just one worksheet, the imported Blitz Report name will be ‘Workbook Name: Sheet Name’ to aid recognition .

During the Discoverer worksheet import, Blitz Report automatically derives the parameter types by examining the Discoverer EUL items . It then automatically creates List of Values (LOVs) for the specific item classes utilized by those workbook parameters .