Home › Discussions › Questions & Answers › ECC Dataset Migration to Blitz Report

ECC Dataset Migration to Blitz Report

Avatar photoCustomer Questions & Answers 7 replies

We want to use Blitz Report to access the underlying SQL queries for Oracle’s Enterprise Command Center (ECC) datasets, enabling us to export larger data volumes than typically allowed by the ECC interface. How is the ECC dataset successfully imported into Blitz Report?

7 replies

  • Support Enginatics

    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 .

  • Is there an example script available for importing all ECC datasets automatically?

  • Support Enginatics

    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 .

  • When Oracle releases a new version of Command Centers, and the underlying dataset queries change, how should I manage the update process in Blitz Report?

  • Support Enginatics

    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 .

  • If I am already in the ECC Developer responsibility and want to quickly create a report using the ECC data, how can I access the dataset key?

  • Support Enginatics

    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 .

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