Forum Stats

  • 3,836,991 Users
  • 2,262,217 Discussions
  • 7,900,173 Comments

Discussions

Discoverer Replacement Options

3597072
3597072 Member Posts: 1
edited Sep 13, 2018 1:43PM in Discoverer

We use Discoverer to provide many of our Oracle EBS reports. However, Oracle has announced that it is withdrawing support for Discoverer and so we are seeking an alternative solution. The alternative solution should:

  • Understand the relationships between the information held in out EBS v12 instance i.e. should understand how to drill-down from say a GL Trial Balance report to the AR transactions
  • Integrate with Oracle R12 security
  • Provide audit trail of user access to reports
  • Provide off-the-shelf reports for common scenarios
  • Provide ad-hoc reporting capability for expert users
  • Allow report templates to be created by expert users and shared with others
  • Allow reports to be scheduled for unattended execution

What solution options should we consider?

Tagged:
rade.pobulicAndy HaackAlexander PavlikSanketZTony_DaGiau

Answers

  • sbeck-Oracle
    sbeck-Oracle Member Posts: 116 Employee
    edited Feb 1, 2018 8:47AM

    Customers are being directed to Oracle BI Enterprise Edition (OBIEE).  However, it is best to discuss your site needs with your Oracle Salesperson.

  • John_K
    John_K Member Posts: 2,498 Gold Trophy
    edited Feb 27, 2018 6:52AM

    Despite the official line from Oracle, OBIEE is completely different from Discoverer. For what most organizations use Discoverer for - producing large data extracts for offline manipulation in Excel etc - OBIEE is inefficient, difficult to extend, and geared towards data warehouse solutions (of course it can query live data, however it works a lot better with an OLAP environment).

    Ultimately - there is no replacement. Oracle want companies to go OBIEE - although they'll probably try and push BICS now because...well... it's Cloud.

    Tony_DaGiau
  • sbeck-Oracle
    sbeck-Oracle Member Posts: 116 Employee
    edited Feb 27, 2018 7:16AM

    Discoverer is an Ad Hoc query tool.  It was never designed to be a Data Extraction tool.  The feature of export to other formats was added to assist customers to review data offline.  Not to populate another data storage system (Excel, etc.).  Reports in Discoverer are meant to be "humanly consumable".  If the worksheet (report) returns more data than a human can read, it is not being used as designed.


    OBIEE is more complex and not as simple as Discoverer; however, too functions as an Ad Hoc query tool.

    There are other tools available.  Please discuss with your Oracle Salesperson the options.


    Regards,
    Sharon

  • Vipul Patel
    Vipul Patel Member Posts: 45 Blue Ribbon
    edited May 14, 2018 1:18PM

    Hello,

    Try demo of qlik has in memory concept faster performance but costly.

    Thanks

    Vipul

  • StephenCloete
    StephenCloete Member Posts: 3
    edited Jun 11, 2018 3:07PM

    Hello,

    I thought I'd might throw a spanner in the works and recommend considering Oracle Application Express with the packaged application called Data Reporter. It is 100% free with your Oracle Database and develops within your Web Browser

    Regards

    Stephen

    rade.pobulic
  • Alexander Pavlik
    Alexander Pavlik Member Posts: 44 Blue Ribbon
    edited Sep 12, 2018 3:18AM

    Hello!

    You can try Blitz report from Enginatics

    Regards,

    Alex

    Andy Haack
  • user2605123
    user2605123 Member Posts: 1
    edited Sep 13, 2018 1:43PM

    You should look at Excel4apps - Reports Wand and GL Wand as not only a replacement for Discoverer but even more flexibility with all reporting being done within excel.  All your requirements listed above can be met with Excel4apps.  Let me know if you would like more information?

This discussion has been closed.