Powerful - recommended for large businesses
Anonymous | TrustRadius Reviewer
December 13, 2017

Powerful - recommended for large businesses

Score 9 out of 10
Vetted Review
Verified User
Review Source

Modules Used

  • Oracle Business Intelligence Enterprise Edition (OBIEE) 11g
  • Oracle Business Intelligence Enterprise Edition (OBIEE) 10g

Overall Satisfaction with Oracle BI Foundation Suite

The Oracle BI Foundation Suite is primarily used by the data analytics team of my organization. In particular, OBIEE 11g is used. Although the tool is primarily used and managed by the data analytics team, the use cases of OBIEE 11g apply to various departments and pillars across the entire organization. Reports generated by OBIEE are the primary source of actionable insights for most business decisions on a much higher level.
  • Can be used by business folk as well, without any in-depth knowledge of writing queries.
  • Automation of a lot of functions makes it very handy to avoid heavy mechanical tasks.
  • Offers great level of control in terms of data access and restrictions.
  • Provides diverse scheduling options - time triggered, event triggered, data dependent, etc.
  • Some issues that require the assistance of support at Oracle can be time-consuming and difficult to solve.
  • Upgrade from 10g to 11g has made the OBI Foundation Suite very performance intensive. Requires much better hardware support now.
  • Initial setup is not as straightforward as that of previous versions.
While Oracle BI Foundation Suite (esp. OBIEE 11g) outperforms most other business intelligence tools available on the market (Looker, Cognos, etc), it falls behind on a few fronts. One of the primary features where OBIEE falls behind is the reporting and visualization tools. Most other tools with similar range capabilities either offer great in-built visualization tools or easy integration with other visualization tools. OBIEE offers neither.
Oracle Business Intelligence Enterprise Edition 11g (and 10g as well) allows reports to source data from multiple data sources and combine them to form aggregate tables seamlessly. Businesses that deal with data in large volumes, as well as velocity, can leverage this feature of OBIEE as well. Reports can be updated in an almost real-time manner.
The scheduling features available on OBIEE 11g are simply great. Report generation can be triggered in many ways - scheduling based on time, event-based triggers, data-driven triggers that are enabled based on certain fields or criteria, etc. While the scheduling features are quite well developed, the visualization tools, however, leave much to be desired for. OBIEE could really incorporate several charting tools available in most other business intelligence tools available.
For an organization that deals with a wide range of reporting needs and also has to handle huge volumes of data that are required for sourcing these reports, Oracle Business Intelligence Foundation Suite provides a great tool in terms of both performance and usage. The layered approach to usage allows both data analysts as well as business analysts to be able to use OBIEE comfortably. However, the premium licensing cost of OBIEE makes it difficult for most startups and low-budget business to afford.

Oracle Analytics Server Feature Ratings

Pixel Perfect reports
Not Rated
Customizable dashboards
8
Report Formatting Templates
8
Drill-down analysis
9
Formatting capabilities
8
Integration with R or other statistical packages
Not Rated
Report sharing and collaboration
8
Publish to Web
10
Publish to PDF
10
Report Versioning
10
Report Delivery Scheduling
10
Delivery to Remote Servers
Not Rated
Pre-built visualization formats (heatmaps, scatter plots etc.)
7
Location Analytics / Geographic Visualization
Not Rated
Predictive Analytics
Not Rated
Multi-User Support (named login)
10
Role-Based Security Model
8
Multiple Access Permission Levels (Create, Read, Delete)
8
Single Sign-On (SSO)
Not Rated
Responsive Design for Web Access
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