Oracle BI Foundation Suit - Good or bad
November 02, 2017

Oracle BI Foundation Suit - Good or bad

Sumeet Saraf | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User

Modules Used

  • Enterprise BI Platform
  • Scorecard and Strategy Management
  • Mobile BI

Overall Satisfaction with Oracle BI Foundation Suite

Oracle BI Foundation Suite is implemented for an automobile industry in Sydney and has been used by its major departments. The main purpose of the tool is to manage, load and extract data from its DB to its own BI tool which makes it faster, reliable and easy to manage. It mainly addresses the problem of extensions of existing reports to major reports or dashboards, SQL based reports with complex outputs, etc.
  • It allows easy extension of reports from simple to complex dashboards
  • The tool goes well with Oracle DB and has great performance
  • Since the base is built on Java, it is supported to run on different platforms and portable devices
  • The tool does not support all the external databases, just works perfect with Oracle DB and few others
  • Since it is based to run on JVM, there are few new systems that has stopped using JVM and has switched to ajax and other platforms. Hence the right plugins are required to be installed in addition
  • The tool is not easy to use. A new user can not work on it unless trained or is highly techy person.
SAP Business Object license is not cheap and was a bigger pain for the client to implement and adapt a new tool. QlikView is mainly used for dashboards and is not the best fit for reporting and ad-hoc reports. Since the client was using an Oracle tool set for their application and DB, we found Oracle BI was a much appropriate tool for them.
If the client is using Oracle based tools like the DB, ETL and application, Oracle BI Foundation Suite is one of the best fit for the client.
For e.g. The automobile industry where we had implemented OBI, there was a cube built at the ETL level for calculating aggregations of their financial data. The client was using one another non-oracle tool to extract data from this cube to get their financial data but they were facing a lot of performance issues. We switched this reporting from the non-oracle to Oracle BI suit and the performance came down from 6 min to 40 seconds. That was just amazing what the client was looking for.

Oracle Analytics Server Feature Ratings

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