Home Discussions Questions & Answers Oracle Enterprise Command Center administration and enriched dashboard data export to Excel

Oracle Enterprise Command Center administration and enriched dashboard data export to Excel

Avatar photoCustomer March 5, 2020 at 6:16 pm

We rely on Oracle Enterprise Command Center (ECC) for data visualization, but when our data analysts attempt to pull the underlying, ‘enriched’ data sets, the native ECC export function limits the volume and only provides plain CSV files, making post-analysis difficult. How does Blitz Report offer a solution for high-volume, formatted ECC data extraction?

Viewing 6 reply threads
  • Author
    Replies
    • Support March 7, 2020 at 3:10 am  

      Blitz Report is the ideal tool for ECC administration and data extraction, specifically designed for business users and DBAs supporting ECC dashboards. Our solution focuses on the replication of the ECC dashboard views directly within EBS. This allows for the extraction of the full data set to perfectly formatted Excel reports, unlike the restricted CSV files provided by the dashboard views.

    • Avatar photoCustomer March 8, 2020 at 6:34 pm  

      So, instead of relying on the ECC application layer for export, we use the original SQL queries that feed the ECC visualizations?

    • Support March 9, 2020 at 2:50 am  

      Precisely. By leveraging the standardized ECC SQL queries that drive the dashboards , Blitz Report runs those proven queries against the EBS data sources. This ensures the output is assured and, crucially, means there are no data limits on the Excel output, overcoming the fundamental volume limitations of the ECC dashboards themselves.

    • Avatar photoCustomer March 9, 2020 at 5:42 pm  

      Is this capability part of the broader toolkit mentioned for EBS projects and upgrades?

    • Support March 10, 2020 at 7:28 pm  

      Yes, mass exporting volume data, such as from ECC dashboards, is categorized as a key component in the Blitz Report Toolkit, specifically designed as a ‘Data management report’. This ensures your team can handle large operational and ECC data extracts effectively.

    • Avatar photoCustomer March 11, 2020 at 4:47 pm  

      We need to implement this immediately. What is the typical setup time for a new user to start running ECC data extracts?

    • Support March 13, 2020 at 1:21 am  

      Blitz Report can be implemented in less than an hour. It requires no additional functional training since it operates using existing EBS commands and follows the standard EBS security framework and concurrent request mechanism.

Viewing 6 reply threads
  • You must be logged in to reply to this post.

Login with: