Home Discussions Questions & Answers Reducing Administrative Overhead with Blitz Report

Reducing Administrative Overhead with Blitz Report

Avatar photoCustomer August 23, 2023 at 10:44 am

As a System Administrator, manually registering every new custom report as a Concurrent Program, defining its executable, parameters, and request group membership is a major bottleneck. When we create a report using Blitz Report’s simple SQL interface, do we completely bypass this manual registration overhead?

Viewing 8 reply threads
  • Author
    Replies
    • Support August 23, 2023 at 8:12 pm  

      Yes, this is a core efficiency feature of Blitz Report. A key benefit is the ability to create new operational reports quickly without the hassle of registering new concurrent programs and reports. The report runs immediately through the concurrent requests mechanism, and you do not need to register the report in system admin.

    • Avatar photoCustomer August 24, 2023 at 9:13 am  

      So, how is the report execution actually managed by the Concurrent Manager if it’s not a registered program?

    • Support August 25, 2023 at 9:22 am  

      Blitz Report is implemented as an add-on that utilizes the application foundation functions, including the Concurrent Request framework. Instead of registering each individual report as a unique program, Blitz Report leverages its own highly optimized execution engine which is already integrated, allowing it to interpret the saved SQL definition and execute it as a concurrent request seamlessly.

    • Avatar photoCustomer August 27, 2023 at 6:54 am  

      Does this apply equally to reports created from scratch via SQL, and reports imported from legacy tools like Discoverer or BI Publisher?

    • Support August 28, 2023 at 2:12 am  

      It applies universally. Whether you create a new report in minutes or import a complex BI Publisher report complete with parameters , the key administrative benefit holds true: there are no new concurrent programs to register per report. This dramatically simplifies the maintenance workload for IT teams.

    • Avatar photoCustomer August 30, 2023 at 12:31 am  

      What other administrative functions are automated besides registration?

    • Support September 1, 2023 at 3:30 pm  

      In addition to zero concurrent program registration, Blitz Report handles version control automatically for every report definition, preventing duplication and maintaining a stable codebase with audit history. This is essential for maintaining control over custom SQL assets.

    • Avatar photoCustomer September 3, 2023 at 7:19 am  

      If a DBA needs to quickly check patch status using a SQL function like AD_PATCH.IS_PATCH_APPLIED, they can define and save that as a report without registration?

    • Support September 4, 2023 at 7:04 pm  

      Precisely. Defining and saving that utility report within Blitz Report allows the DBA to execute it directly from the Forms interface without needing database login or OAM navigation , showcasing the simplicity Blitz Report brings to DBA tasks.

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

Login with: