Skip to main content

Top 5 Discoverer Conversion Questions

The Top 5 Discoverer Conversion Questions

Don’t be fooled by other vendors!

Many vendors in the Discoverer Conversion space take the SQL behind the Discoverer Workbooks and import to the new product.  There are some real impacts to taking this route when moving from Discoverer to a supported product.

If you look at this type of conversion, you might wonder how this affects me.

Converted reports run just the SQL brought in to the new product which may seem like the easiest, quickest and potentially most cost-effective way to proceed. But is it really?

If you go this route, the report will be static and NOT retain functionality from Discoverer.

  • Users CANNOT add or remove columns
  • Users CANNOT add or change filters or parameters
  • Users CANNOT copy the report to create a new report

Though moving the SQL to a new tool might seem the best solution, doing so will take away the functions that most Discoverer users want like Self-service reporting and copying and/or modifying existing reporting.  If you cannot change a converted report, what is the cost to build a NEW report just to get minor changes.  Suddenly, the savings to convert is eaten up in man hour costs to do business.

What can you ask vendors being reviewed for Discoverer Conversion to be sure you have the full understanding of the solution they are offering?

  1. Does the solution take the entire infrastructure from the EUL?
    • Import the EUL
    • Import the Business Areas
    • Import the Workbooks and Worksheets
    • Import the Users
  2. Will the converted reports have the same or better functionality as was in Discoverer?
    • So, what you see in Discoverer today, will you see in the new solution with full functionality?
  3. Can we edit the report once converted?
    • Users in Discoverer expect to be able to edit exiting workbooks on the fly. If you bring in only SQL and create a static report.  What is the cost to build a new report just to make a minor change to a report that can’t be modified?
  4. Can we copy a report and pull in new columns and change parameters and filters?
    • A big value of Discoverer is the self-service capabilities. Taking an existing report, copying it and making changes quickly to get a new result set.  What is the cost again of having to build a new report to gain this functionality?
  5. Does the solution provide a Conversion Utility that will allow internal conversion without external consulting?
    • If you convert SQL, is there a utility my company can use to save on consulting costs?
    • Finding a Discoverer Conversion solution that give you an option to do the conversion yourself is key to cost savings. Why pay someone to convert when you can convert yourself?

Protect your investment to see which BI tool can:

  • Migrate your current workbooks
  • Offer Speed and Accuracy
  • Is available at least Cost
  • Deliver solutions (Self Service Reporting, Dashboards and Discoverer Conversion Utility), not just a product.


We often hear that “My EUL is unique and has a lot of complexity.”  Having worked with numerous customers over several years, we have found many complexities in the market.  Here are a few that you want your BI tool to solve out of the box.

  1. Object Level Calculations
  2. Totals/Sub Totals
  3. Calculation column inside another un-used calculation columns
  4. Group BY
  5. Color Codes
  6. Disabled calculation columns, conditions and parameters(un-checked)
  7. Date format mask
  8. Workbook Security/share
  9. Custom Folders with complex query
  10. Match Case/case insensitive filters
  11. Cross Tab Layout
  12. Exclude/Include Joins
  13. Item Classes/LOVS
  14. Page Items
  15. Complex calculation formulas with Analytical Functions like PARTITION BY.
  16. Object Level Filters
  17. Report Sets
  18. Replace NULL value with
  19. Fan-Trap

The goal of customers to migrate from the de-supported Discoverer to a new product is to save the investment they have made so what you see in Discoverer today is what you will get in the new product with new feature functions that will grow with the business.  Good luck, and happy converting!


Related Posts

Unleashing the Power of Data: A Comprehensive Guide to Real-Time Analytics for Business Success 3BlogOracle CloudOracle E-Business Suite
May 24, 2023

Unleashing the Power of Data: A Comprehensive Guide to Real-Time Analytics for Business Success

Real-time data is critical to staying ahead in the rapidly evolving business landscape....
Oracle EBS to Fusion Cloud Migration? Best Practices for Consistent Reporting 4BlogOracle CloudOracle E-Business Suite
April 17, 2023

Oracle EBS to Fusion Cloud Migration? Best Practices for Consistent Reporting

Costs related to data ownership are up to 50% lower with Oracle Fusion Cloud Applications...
Talent Retention Woes? See How People Analytics Can Help 5BlogSplashHR
March 3, 2023

Talent Retention Woes? See How People Analytics Can Help

The Great Resignation. Quiet quitting. Not so quiet quitting. Retrenchments. The past few years...