Not everything that can be counted counts, and not everything that counts can be counted. - Einstein
December 08, 2018

Not everything that can be counted counts, and not everything that counts can be counted. - Einstein

David Lisauskas | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User

Overall Satisfaction with Business Intelligence Discoverer

Being 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.

Pros

  • 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.

Cons

  • 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.
I did not select Discoverer.....however, I do prefer it to the other tools that I have used for report creation. I do like the mix of GUI and SQL direct code avail. I have mostly used the desktop version, but migrating over to the web based version and starting to build reports there. I find Discoverer to be fairly easy to navigate and intuitive for me to build my reports.
Well suited for mining large sets of data to build reports for financials, order history, or quality mining from your database. It is less appropriate for small business where this level of tool might be too much overhead to use. For me, does not do a great job dealing with duplicate data due to cross-tabs, might be my lack of knowledge in this area, I usually clean some of this up post-data through excel.

Oracle Discoverer (discontinued) Feature Ratings

Pixel Perfect reports
Not Rated
Customizable dashboards
Not Rated
Report Formatting Templates
Not Rated
Drill-down analysis
9
Formatting capabilities
8
Integration with R or other statistical packages
Not Rated
Report sharing and collaboration
9
Publish to Web
3
Publish to PDF
Not Rated
Report Versioning
Not Rated
Report Delivery Scheduling
7
Delivery to Remote Servers
Not Rated
Pre-built visualization formats (heatmaps, scatter plots etc.)
Not Rated
Location Analytics / Geographic Visualization
Not Rated
Predictive Analytics
Not Rated
Multi-User Support (named login)
10
Role-Based Security Model
9
Multiple Access Permission Levels (Create, Read, Delete)
9
Single Sign-On (SSO)
Not Rated
Responsive Design for Web Access
8
Mobile Application
Not Rated
Dashboard / Report / Visualization Interactivity on Mobile
Not Rated
REST API
Not Rated
Javascript API
Not Rated
iFrames
Not Rated
Java API
Not Rated
Themeable User Interface (UI)
Not Rated
Customizable Platform (Open Source)
Not Rated

Comments

More Reviews of Oracle Discoverer (discontinued)