Task: Oracle Discoverer replacement
Audience: DBA’s, IT consultants and business operations
1 Customers Facing Oracle Discoverer Replacement Challenges
2 Discoverer Analytical Reports
2.1 Here’s an Example for the Business Areas
3 Import Procedure
3.1 Discoverer Worksheet Import Option
3.2 Mass Import Using Our API
3.3 User Interface and IT Support
3.4 Summary
Background
Oracle de-supported Discoverer in 2017, which poses a significant challenge for EBS users. The Enginatics team has developed an Oracle Discoverer replacement utility with automated functionality to import Discoverer worksheets together with their security assignments and parameters.
The Blitz Report’s Discoverer report import feature allows automated migration of worksheet SQLs. The migration process can be done individually or on mass using our API / program interface.
The Blitz Report software is free to use for up-to 30 reports, which means you can import your worksheets and use them in Blitz Report completely free of charge. In addition, we provide a library of 200+ reports that include core process areas such as R2R, P2P, O2C, and SCM and Planning.
1 Customers Facing Oracle Discoverer Replacement Challenges
One of our customers, the Raiffeisen Bank International relied on Oracle Discoverer to export data directly to Excel worksheets for their EBS reporting needs. However, when Oracle ended support for Discoverer it forced RBI to look into Discoverer alternatives. They selected a third-party Oracle reporting tool as a replacement, but unfortunately, the product was unable to convert a small number of valuable, yet complex reports. This meant they had to continue using Discoverer despite the increased costs. They evaluated several solutions in their quest for a more comprehensive tool and challenged Enginatics to demonstrate how Blitz Report could replace their remaining Discoverer reports and improve overall Oracle E-Business Suite reporting speed. RBI was able to import all of their workbooks together with the assignments, security, and parameter settings and they were up and running in minutes.
To read more about how RBI migrated their Discoverer reports, read their case study here.
2 Discoverer Analytical Reports
Before starting the import, we recommend running our analytical reports to assess the Discoverer configuration and status of the existing workbooks and folders.
There are several Blitz Reports available to analyze your current Discoverer usage and end-user layer setup as highlighted in the table below. These can be reviewed in more detail in our library
Reports overview
| Report name | Description |
|---|---|
| DIS Access Privileges | Discoverer access privileges |
| DIS Business Areas | A summary report showing Discoverer business areas, with an access account showing how many times a business areas folder was last used. Use the parameter past 'x' number of days. |
| DIS Folders, Business Areas, Items and LOVs | Overview report that shows Discoverer business areas, folders, creation dates, and the last execution date. Use the parameter 'Show Active Only' to restrict folders that have been accessed by worksheet executions within the last 'x' number of days. |
| DIS Import Performance | A simple query to review Discoverer worksheet to Blitz Report import performance, when running the mass migration script. |
| DIS Users | Discoverer end-user layer displays different user types, e.g. application user, responsibility, database user |
| DIS Worksheet Execution History | Discoverer worksheet access statistics, including folder objects, used. Parameter 'Show Folder Details' switches between aggregate and list view of used folder objects. |
| DIS Worksheet SQL's | Discoverer worksheet SQL queries. |
| DIS Workbooks, Folders, Items and LOV's | Discoverer workbooks, their owners, folders, items, and item class LOVs, derived from dependency table eul5_elem_xrefs. |
2.1 Here’s an Example for the Business Areas
The report output shows the access-count for each business area report together with the last accessed/run date.
3 Import Procedure
There are two methods to import your Discoverer worksheets:
- Individually using the Blitz Report form import option.
- As a script using our Discoverer application programmable interface (API).
Note: There are also import options for BI Publisher, Discoverer, Excel4Apps, Oracle concurrent programs, or for migration of Blitz Reports between environments.
3.1 Discoverer Worksheet Import Option
Here we can import single worksheets of type Discoverer, BI Publisher, Excel4apps, etc.. You will find that the reports run faster with Blitz Report, as our Excel generation is highly optimized for maximum performance.
3.2 Mass Import Using Our API
In this example, a single SQL script is run from a SQL development tool such as SQL Developer. The process typically takes 10 minutes for 1000 reports, you can monitor the performance using the DIS Import Performance report.
Use the suggested script from the mass import section of the user manual and adjust it according to your requirements. For example, modify the number of historical days to only import reports which were run in the past 6 months.
3.3 User Interface and IT Support
Blitz Report uses the same user interface as EBS, making it easier for business users to adopt. A user can report to CSV, Excel, or other file types suitable for importing to Tableau or Microsoft Power BI. A Blitz Report user has the capability to add, reposition, or remove report columns with just a few mouse clicks, thereby reducing IT dependency.
All reports run through the concurrent request mechanism with enhanced delivery options. Report definitions exist in a version-tracked Blitz Report table, making it a simple task for IT teams to manage, especially as there are no new concurrent programs to register per report.
3.4 Summary
- Download and install Blitz Report into your EBS environment – (typically 20 minutes).
- Run the Discoverer analysis reports to identify which reports need to be migrated.
- Import your Discoverer reports individually using the Blitz Report import menu option or instead use the mass import API utility.
Typically, once the Discoverer migration analysis has been completed, your entire set of reports can be imported in minutes.
If you would like to try the Discoverer worksheets import process yourself, you can use our EBS demonstration instance, or we can arrange a demonstration in your own EBS environment. We regularly run webinars for Discoverer replacement at Oracle User Groups, please review our events calendar for these as we will be scheduling our next event in September 2020.
Don’t forget you can use Blitz Report for life, and free of charge for up to 30 reports.
Please refer to the Blitz Report user guide for more information on Oracle Discoverer replacement and detailed usage instructions or watch this video:
Eye Movement Desensitization and Reprocessing Therapy for Veterans and Dealing with Trauma Following Military Service
Government service could expose individuals in order to any wide assortment regarding potentially traumatic experiences, from combat-related events in order to interpersonal violence and also accidents. Pertaining to many veterans, this psychological aftermath of trauma can easily continue in order to impact their mental as well as emotional well-being prolonged following leaving this military. Eye Movement Gradual Desensitization and Desensitization EMDR treatment provides a promising approach intended for approaching trauma-related concerns among veterans, supporting their journey toward healing and recovery.
In this forum post, most of us explore the actual application connected with EMDR therapy with veteran populations and also discuss its potential benefits regarding addressing trauma-related symptoms and promoting resilience and well-being.
A single from the primary challenges faced by veterans can be the actual prevalence connected with post-traumatic stress disorder (PTSD) in addition to other trauma-related conditions, which in turn can greatly impair their quality associated with life and also functioning. EMDR therapy possesses been shown for being effective throughout reducing symptoms associated with PTSD and associated difficulties, including nightmares, hypervigilance, along with avoidance behaviors.
Additionally, EMDR therapy can easily address the underlying aspects contributing in order to veterans’ trauma symptoms, like moral injury, survivor guilt, and issues concerning reintegration back into civilian life. By providing a safe as well as supportive space intended for processing traumatic memories in addition to covering associated beliefs along with emotions, EMDR therapy empowers veterans. to make sense linked with their experiences as well as move forward upon the path to help healing.
Moreover, Eye Movement Desensitization and Reprocessing therapy’s relatively short duration in addition to focus with symptom reduction make it suitable regarding veterans that could be hesitant to be able to engage within long-term therapy as well as who have limited access to behavioral health services. By giving excellent in addition to easily accessible trauma treatment, EMDR therapy encourages this well-being associated with veterans along with honors their service in addition to sacrifice.
Adolescent trauma resilience
81167db