
Among other weaknesses it is worth mentioning that it is Oracle only (only Oracle native connection, no multiple data sources, other RDBMS via ODBC only) and its reporting capabilities are limited to singly block (only one graph/crosstab/table).ĭiscoverer competes with Query Studio, Analysis Studio, Report Studio (for IBM Cognos 8) and SAP BusinessObjects Web Intelligence and Desktop Intelligence. The problem with Discoverer is that its future is rather uncertain and it should be rather considered as a legacy product. The main advantages of Discoverer are Personalized Portals where worksheets can be customized at the portal level for each user, the fact that it comes in a bundle which affects its price and its technology infrastructure is generally very well received by IT. In 2006 Oracle Discoverer was repackaged along with Oracle Reports, BI Beans and other tools to form Oracle BI Standard Edition. It is very commonly used with Oracle RDMBS (most likely with the OLAP database option) and embedded in a number of Oracle Applications in the Oracle e-Business Suite.

End users can interactively navigate, drill down, slice and dice, aggregate and add calculations. Oracle Discoverer is an ad-hoc query and analysis tool which allows users to do basic query construction along with tables, cross tabs and charts. Oracle Discoverer 10g (Oracle BI Suite Standard Edition) Query & Analysis This article shows the purpose and major characteristics of each of the Oracle BI applications, also indicating similarities to IBM Cognos 8 and SAP Business Objects applications. Those tools are: Oracle Discoverer 10g (Oracle BI Suite Standard Edition), Oracle Business Intelligence Standard Edition One (for mid-market segment) and Oracle BI Suite Enterprise Edition (formerly Siebel Analytics). Oracle provides three different applications along with licensing options for Business Intelligence and Data warehousing. Oracle Business Intelligence tools overview
