TrustRadius
Business Intelligence Discoverer is a business intelligence software offering from Oracle.https://media.trustradius.com/product-logos/99/UN/O3D473MNSAHT.pngDisco and OBIEEBusiness Intelligence Discoverer is being used agency wide. Our entire company supports our clients in the use and development of financial reports in it as well as the migration to Oracle Business Intelligence Enterprise Edition (OBIEE). The lack of visualization and ability to have the average users create reports is forcing our clients to look at alternative options. However, the seamless migration bath to OBIEE has helped us continue supporting our clients by delivering new and enhanced reports much faster than a full blown migration to a new product.,Detailed report generation Drag and drop report creation Exporting data for integration with other tools,Visualization Star Schema Integration with different tables,2,Tableau Prep and Tableau Desktop,9,8,NoOracle BI DiscovererIt is being used by our business as well as implemented to our clients. Business Intelligence discoverer is a tool-set for ad hoc querying, reporting, data analysis, and Web-publishing for the Oracle Database environment. Queries can be created and executed faster and the focus is aligned towards making decisions based on results rather than designing the queries.,Can be used across different levels in the organization Faster and quicker Secure and immediate across to relational and multi dimensional data sources It has intuitive user interface,I do not see anything major defects at this time With seasoning , the software will become more robust and cater to a large audience Some further improvement in performance of fetching results could be an added advantage.,8,Oracle Analytics Cloud,8,7,Not yet, but I'm interested in Oracle user groups,Microsoft 365 Business, Microsoft Power BI, Microsoft SQL ServerAwesome tool to analyze data and reportsOBIEE is a great tool by Oracle and we are using this tool to generate reports. We have more than 1000 users using this tool to analyze and build reports. Users use this tool Airforce-wide to generate multiple reports. We just migrated from Oracle Discoverer to OBIEE. This is being used across the organization and we have not seen issues so far.,Users were able to build complex queries and generate reports in a customize way. The most important benefit of this tool is users can drag and drop the fields they want to use. Users are able to schedule the reports and will generate and ready for the output.,It would be useful if users could be allowed to write subqueries. It would be helpful if there was a way for users to download the reports on their PC. Most of the functionality is awesome and I would like to see more graphics in the reports.,9,,9,9,Yes,Oracle Database 12c, IBM WebSphere Operational Decision Management (formerly ILOG JRules BRMS), IBM WebSphere Application Server on CloudGreat at-a-glance reporting toolBusiness Intelligence is used across all departments in the organization and it is used to provide analytical information to all business users which assists with business decisions in the respective departments. Users are able to get an overall picture of how the organization is performing at a glance. The executive team also uses these reports for decision making.,The ability to export to Excel and other reporting tools. The ability to allow users to create their own reports. The ability to report across different modules to show overall pictures.,Using BI 12c, the look and feel of the application can be more modern. The creation of RPD's for seamless fast reporting can be done simply as OBIEE uses the Oracle database structure. Performance issues with reporting data directly from EBS.,8,,4,1,YesData Extraction Made EasyWe use the Discoverer to extract and analyze data from our Avalon database. We are a manufacturing business and create a significant volume of test data. We need to analyze the data to look for trends and create predictions for future manufactures. Discoverer is also used to check methods of manufacture to ensure consistency in our process.,Easy to create reports which can be shared across the organization. Formulas can be created to analyze the data. Multiple sheets can be created in a single workbook.,If an error is present in a sheet, an improvement in repairing the errors would be useful. More standard data analyze tools would be useful, instead of creating formulas. Improved visual tools to show trends in the data.,9,7,10,No,Microsoft Teams, Skype for Business (formerly Lync), OneNoteA Media Customer's Review of Business Intelligence DiscovererBusiness Intelligence Discoverer is used for reporting purposes by different departments across the company. The tool helps the business gain visibility to transactional data entered in the core Oracle ERP system.,User friendly interface Ease of use Fast report building,The generated SQL queries should be standardized so that they could be re-used in TOAD Enable reading from different sources, not necessarily Oracle DB,7,Microsoft Power BI and Tableau Desktop,6,10,No,Microsoft BI, Tableau Desktop,87,2,Expand to the use to non core users,Financial transactions summary Human Resources records Payroll ReconciliationRaw Data Mining with EaseData mining is a key element for our estate and we use Business Intelligence Discoverer to mine our CRM and Portfolio Manager data. We have scheduled reports setup that are dispatched across the company to various departments. Users create ad-hoc reports when required. Our Accounting departments also use the tool. Its widely used and very well respected by staff.,Data analytics across the company, with ease. Scheduled reporting and ad-hoc queries. Clean and easy layout, very ease to use, even for lesser trained staff.,A level of SQL knowledge is required for more complex arguments. The layout of the interface could be better.,7,Sisense and Tableau Desktop,8,8,No,SisenseNot everything that can be counted counts, and not everything that counts can be counted. - EinsteinBeing used across the entire organization. We use Discoverer to help mine data from our CRM (Oracle). The tool fills a gap between the raw data and the reporting needed by various departments. Some of the reports that are run are created centrally and stored in a company-wide, company-accessible database. Other reports are created "on the fly" and stored locally.,Business Intelligence Discover does a good job mix of GUI interface for report building and access directly to the SQL for those of us who are comfortable with it. Discoverer also does a good job of making easy to create reports and linking the various tables together. I like the rules area where you can check and uncheck certain rules. This is useful to me where I may build a report and copy that same report for several reasons. I can just update the rules that I am using.,My main "wish" for Discoverer when creating a new rule....Our tables are HUGE and you must scroll through several columns before finding the one that you want selected....my "wish" would be to have a search in this area where I could start to type the name of the column and find the selection that way. When creating reports, I often ask for user input (order number, etc...). The process of setting this field to accept multiple inputs is cumbersome and not intuitive.,8,SAP Crystal and Microsoft Dynamics GP,7,9,No,Atlassian Confluence, JIRA Software, Oracle Agile PLMBusiness Intelligence Discoverer, a relatively simple and straightforward BI solutionBusiness Intelligence Discoverer was used for some departments (majorly the BI department), the main focus user group is those who don't have enough in-depth SQL or let's say database knowledge. It's also only for those databases which don't have a complex relationship, and where the business user's graphic report requirement is quite straightforward. So, the end user can quickly transfer the info buried in the Oracle database to a more understandable chart and share with team members.,It is good for quickly building some ad-hoc report on top of the data It works well with the Oracle's own database of course The drop feature is very useful for the business user who hasn't mastered the SQL knowledge Allow customization of PL/SQL functions/procedures, to add more complex data processing logic,In order to be able to add the data "processing" logic, for the basic business user without too much SQL or procedure knowledge, it is almost mission impossible. Simply hiding the complexity of basic technical things like "join" is not enough. Lack of the "hints" or "relationship explanation" when a report with complex joins is created Data visualization options are really too limited,5,TIBCO Spotfire,4,4,NoOracle BI Discoverer ia greatWe use it in accounting and IT for fast and easy querying and analysis of data.,Intuitive discovery Data analysis Simple querying,Interface could be a little more modern,8,10,10,NoDiscover your data with Discoverer!Discoverer is a great reporting tool and currently we use it across the organization but divided by business units - each business unit within the organization has their own setup for Discoverer. Discoverer puts great control in the hands of the end users. We divided user groups into Super Users and Consumers. Super Users of that group understand the data and create reports. Consumers will consume the reports and make a decision accordingly.,Discoverer puts the control in end-user hands. Super Users, who have privileges to create reports, can create and test SQL Queries in SQL Developer and then use the Custom SQL option in Discoverer to create a report based on that SQL. This means the user doesn't have to run the query every day manually, but the report is ready whenever they want to access it. Discoverer eliminates the costly developer layer. Super Users are business users who can create reports for their team on their own. This means there is no need for developers or explaining to them how to use the data. Discoverer consolidates the tables into business areas. Each business area can serve a specific set of users within a department. This helps make the management of reports and data easy.,Duplication of data. While Discoverer supports business areas, it allows a lot of duplication. The same table can exist in multiple business areas. Similar queries and reports exist in multiple places. As multiple Super Users exist in each business area, there are high chances of duplication and increased storage cost. OPatch doesn't work well with Discoverer. Patching Discoverer is a pain. OPatch may not be applicable in all scenarios. No direct path to upgrade Discoverer to OBIEE 12c. If an organization decides to upgrade their Discoverer to OBIEE12c, there is no direct path. They have to upgrade to OBIEE 11g and then to 12c, and even that process is flawed. As mentioned earlier, the duplication of business areas in each End User Layer may create a messy OBIEE RPD with a lot of duplications. It is always advisable to launch a new OBIEE project rather than migrating from Discoverer. Lack of dashboards. Unlike other BI tools, Discoverer lacks a dashboard. However, we can build one on OAS, but it needs lot of customizations and integrations. Discoverer web interface is bad at managing cache. Users frequently complain about stale data.,7,Oracle Business Intelligence Cloud Service,10,9,No,Oracle Business Intelligence Cloud Service, Oracle Analytics Cloud Day by Day, Oracle Analytics Cloud Synopsis, Amazon Web Services, Oracle Cloud Infrastructure (OCI), Oracle Cloud Infrastructure ComputeDiscoverer: Your Gateway to Database ManagementAt my previous company, I was one of only two people who knew how to manage and work with databases as we were primarily using SQL in Access. Our organization had a need for deeper database integration with the amount of data we were pulling in and so they had opted to go with Oracle Business Intelligence Discoverer as it did not require each user to know how to use or work in a database. This way, each member of the team could access the data and generate reports without needing to access the actual database.,SQL friendly which allows for fast adoption for those users who know how to write in SQL. This makes integration with other programs much easier. Accessing data is very fast even with larger data sets. The layout is clean and organized similar to a spreadsheet which allows for easier viewing and analyzing of the data.,Sometimes it can be a bit too rudimentary and rigid, not allowing users who can manage databases to customize other reports. Necessary to have a "Discoverer manager" who organizes the data and allots access to Discoverer, which requires a company to have someone on staff who is database savvy.,7,Sisense,6,8,Yes,SisenseUsing Oracle DiscovererWe use Discoverer as a way to provide self-service reporting and analytic services to our organization. It provides a graphical interface for simplifying data access.,Discoverer allows drop and drag for data elements onto reports. All technical aspects, like joins, are handled in the administration section and away from the end users. This makes it easier for them. Discoverer allows for the registering of PL/SQL functions for easily adding functionality to the reporting abilities.,The creation of calculations can be difficult for end users. SQL creation skills are needed to understand complex additions. When multiple joins are added between reporting objects, it does not give enough details regarding what the differences might make.,2,Tableau Desktop and Argos,3,1,NoDiscover the benefits of DiscovererBusiness Intelligence Discoverer has been the key user self-service reporting tool against Oracle E-Business Suite. Empowering the application users to create and run their own reports by developing a robust reporting structure has enabled application users to get the data they need when they need it without waiting on requests to the IT department. Discoverer is also used by Audit and Tax to pull data to support filings and respond to data requests.,Discoverer is a good tool for providing customer ad hoc reporting. The UI is clean and easy to use. Built in interfaces to Oracle applications seamlessly integrate reporting with application security and data access restrictions. Having a reporting environment that matches the OLTP system security simplifies compliance with various legal, regulatory, and business data access requirements. The ability to link data from one report to another and drill to detail provides detailed data analysis from high-level reports with exception reporting.,Discoverer needs better data visualization options. I would like to see built in integration with SharePoint so published management reports can more easily be delivered to users. Mobile tools for both report delivery and system maintenance would enhance usability.,8,We have used Discoverer to respond to state sales and use tax audits and saved the company more than the cost of the product. Discoverer has thus assisted in our objective of managing costs. Discoverer is used to provide reports for EEOC reporting assisting our goal of complying with all government requirements.,,SAP Business Objects, Tableau OnlineUnspecified
Business Intelligence Discoverer
547 Ratings
Score 7.7 out of 101
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>TRScore

Business Intelligence Discoverer Reviews

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
Business Intelligence Discoverer
547 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 7.7 out of 101

Do you work for this company?

Overall Rating

Reviewer's Company Size

Last Updated

By Topic

Industry

Department

Experience

Job Type

Role

Filtered By:

Reviews (1-14 of 14)

Companies can't remove reviews or game the system. Here's why.
Sherif Said profile photo
September 16, 2019

Disco and OBIEE

Score 2 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Detailed report generation
  • Drag and drop report creation
  • Exporting data for integration with other tools
  • Visualization
  • Star Schema Integration with different tables
Read Sherif Said's full review
No photo available
October 17, 2019

Oracle BI Discoverer

Score 8 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Can be used across different levels in the organization
  • Faster and quicker
  • Secure and immediate across to relational and multi dimensional data sources
  • It has intuitive user interface
  • I do not see anything major defects at this time
  • With seasoning , the software will become more robust and cater to a large audience
  • Some further improvement in performance of fetching results could be an added advantage.
Read this authenticated review
No photo available
Score 9 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Users were able to build complex queries and generate reports in a customize way.
  • The most important benefit of this tool is users can drag and drop the fields they want to use.
  • Users are able to schedule the reports and will generate and ready for the output.
  • It would be useful if users could be allowed to write subqueries.
  • It would be helpful if there was a way for users to download the reports on their PC.
  • Most of the functionality is awesome and I would like to see more graphics in the reports.
Read this authenticated review
No photo available
Score 8 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • The ability to export to Excel and other reporting tools.
  • The ability to allow users to create their own reports.
  • The ability to report across different modules to show overall pictures.
  • Using BI 12c, the look and feel of the application can be more modern.
  • The creation of RPD's for seamless fast reporting can be done simply as OBIEE uses the Oracle database structure.
  • Performance issues with reporting data directly from EBS.
Read this authenticated review
No photo available
Score 9 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Easy to create reports which can be shared across the organization.
  • Formulas can be created to analyze the data.
  • Multiple sheets can be created in a single workbook.
  • If an error is present in a sheet, an improvement in repairing the errors would be useful.
  • More standard data analyze tools would be useful, instead of creating formulas.
  • Improved visual tools to show trends in the data.
Read this authenticated review
Rob Bates profile photo
Score 7 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Data analytics across the company, with ease.
  • Scheduled reporting and ad-hoc queries.
  • Clean and easy layout, very ease to use, even for lesser trained staff.
  • A level of SQL knowledge is required for more complex arguments.
  • The layout of the interface could be better.
Read Rob Bates's full review
David Lisauskas profile photo
Score 8 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Business Intelligence Discover does a good job mix of GUI interface for report building and access directly to the SQL for those of us who are comfortable with it.
  • Discoverer also does a good job of making easy to create reports and linking the various tables together.
  • I like the rules area where you can check and uncheck certain rules. This is useful to me where I may build a report and copy that same report for several reasons. I can just update the rules that I am using.
  • My main "wish" for Discoverer when creating a new rule....Our tables are HUGE and you must scroll through several columns before finding the one that you want selected....my "wish" would be to have a search in this area where I could start to type the name of the column and find the selection that way.
  • When creating reports, I often ask for user input (order number, etc...). The process of setting this field to accept multiple inputs is cumbersome and not intuitive.
Read David Lisauskas's full review
yixiang Shan profile photo
Score 5 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • It is good for quickly building some ad-hoc report on top of the data
  • It works well with the Oracle's own database of course
  • The drop feature is very useful for the business user who hasn't mastered the SQL knowledge
  • Allow customization of PL/SQL functions/procedures, to add more complex data processing logic
  • In order to be able to add the data "processing" logic, for the basic business user without too much SQL or procedure knowledge, it is almost mission impossible. Simply hiding the complexity of basic technical things like "join" is not enough.
  • Lack of the "hints" or "relationship explanation" when a report with complex joins is created
  • Data visualization options are really too limited
Read yixiang Shan's full review
No photo available
Score 7 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Discoverer puts the control in end-user hands. Super Users, who have privileges to create reports, can create and test SQL Queries in SQL Developer and then use the Custom SQL option in Discoverer to create a report based on that SQL. This means the user doesn't have to run the query every day manually, but the report is ready whenever they want to access it.
  • Discoverer eliminates the costly developer layer. Super Users are business users who can create reports for their team on their own. This means there is no need for developers or explaining to them how to use the data.
  • Discoverer consolidates the tables into business areas. Each business area can serve a specific set of users within a department. This helps make the management of reports and data easy.
  • Duplication of data. While Discoverer supports business areas, it allows a lot of duplication. The same table can exist in multiple business areas. Similar queries and reports exist in multiple places. As multiple Super Users exist in each business area, there are high chances of duplication and increased storage cost.
  • OPatch doesn't work well with Discoverer. Patching Discoverer is a pain. OPatch may not be applicable in all scenarios.
  • No direct path to upgrade Discoverer to OBIEE 12c. If an organization decides to upgrade their Discoverer to OBIEE12c, there is no direct path. They have to upgrade to OBIEE 11g and then to 12c, and even that process is flawed. As mentioned earlier, the duplication of business areas in each End User Layer may create a messy OBIEE RPD with a lot of duplications. It is always advisable to launch a new OBIEE project rather than migrating from Discoverer.
  • Lack of dashboards. Unlike other BI tools, Discoverer lacks a dashboard. However, we can build one on OAS, but it needs lot of customizations and integrations. Discoverer web interface is bad at managing cache. Users frequently complain about stale data.
Read this authenticated review
Joseph R. Sweeney profile photo
Score 7 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • SQL friendly which allows for fast adoption for those users who know how to write in SQL. This makes integration with other programs much easier.
  • Accessing data is very fast even with larger data sets.
  • The layout is clean and organized similar to a spreadsheet which allows for easier viewing and analyzing of the data.
  • Sometimes it can be a bit too rudimentary and rigid, not allowing users who can manage databases to customize other reports.
  • Necessary to have a "Discoverer manager" who organizes the data and allots access to Discoverer, which requires a company to have someone on staff who is database savvy.
Read Joseph R. Sweeney's full review
No photo available
October 31, 2017

Using Oracle Discoverer

Score 2 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Discoverer allows drop and drag for data elements onto reports. All technical aspects, like joins, are handled in the administration section and away from the end users. This makes it easier for them.
  • Discoverer allows for the registering of PL/SQL functions for easily adding functionality to the reporting abilities.
  • The creation of calculations can be difficult for end users. SQL creation skills are needed to understand complex additions.
  • When multiple joins are added between reporting objects, it does not give enough details regarding what the differences might make.
Read this authenticated review
Glen Norman profile photo
Score 8 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Discoverer is a good tool for providing customer ad hoc reporting. The UI is clean and easy to use.
  • Built in interfaces to Oracle applications seamlessly integrate reporting with application security and data access restrictions. Having a reporting environment that matches the OLTP system security simplifies compliance with various legal, regulatory, and business data access requirements.
  • The ability to link data from one report to another and drill to detail provides detailed data analysis from high-level reports with exception reporting.
  • Discoverer needs better data visualization options.
  • I would like to see built in integration with SharePoint so published management reports can more easily be delivered to users.
  • Mobile tools for both report delivery and system maintenance would enhance usability.
Read Glen Norman's full review

Feature Scorecard Summary

Pixel Perfect reports (10)
6.9
Customizable dashboards (11)
6.7
Report Formatting Templates (12)
7.2
Drill-down analysis (14)
8.0
Formatting capabilities (14)
7.2
Integration with R or other statistical packages (8)
6.6
Report sharing and collaboration (12)
8.3
Publish to Web (13)
7.4
Publish to PDF (12)
8.2
Report Versioning (11)
6.5
Report Delivery Scheduling (14)
7.8
Delivery to Remote Servers (10)
6.1
Pre-built visualization formats (heatmaps, scatter plots etc.) (10)
6.1
Location Analytics / Geographic Visualization (9)
6.8
Predictive Analytics (9)
6.8
Multi-User Support (named login) (14)
8.2
Role-Based Security Model (12)
7.5
Multiple Access Permission Levels (Create, Read, Delete) (13)
7.7
Single Sign-On (SSO) (10)
8.1
Responsive Design for Web Access (9)
7.1
Dedicated iOS Application (5)
6.3
Dedicated Android Application (4)
6.8
Dashboard / Report / Visualization Interactivity on Mobile (5)
6.5
REST API (5)
5.3
Javascript API (5)
5.5
iFrames (5)
4.6
Java API (4)
5.3
Themeable User Interface (UI) (4)
6.0
Customizable Platform (Open Source) (4)
6.3

About Business Intelligence Discoverer

Business Intelligence Discoverer is a business intelligence software offering from Oracle.