ECC Dataset Migration to Blitz Report

ECC dataset queries can be imported using the menu option under Blitz Report Setup > Tools > Import . For mass imports, you should use the PL/SQL API: `XXEN_API.IMPORT_ECC_DATASET`, which takes the `p_dataset_key` as an input parameter . The key benefit here is that once imported, users can access ECC data of unlimited size and in real-time directly within Excel .

Yes, the example script `mass_import_ecc_reports.sql` is provided to automatically import all available ECC queries into Blitz Report . This simplifies the process, ensuring all underlying data models that power the ECC dashboards are available for detailed reporting through Blitz Report .

If you upgrade your Command Centers, you should use the provided cleanup script `mass_delete_ecc_reports.sql` . This script allows you to delete all previously imported ECC Blitz Reports . Once the old reports are removed, you can re-run the mass import API (`mass_import_ecc_reports.sql`) to bring in Oracle’s latest dataset queries, ensuring your Blitz Reports are synchronized with the new Command Center version .

Although the documentation does not specify the exact UI location, in principle, ECC datasets are managed through the Command Center configuration interface, which you can access via the ‘ECC Developer’ responsibility , . The dataset key (or equivalent identifier) is needed for the `XXEN_API.IMPORT_ECC_DATASET` API .