Skip to main content
TrustRadius
Oracle Analytics Server

Oracle Analytics Server
Formerly Oracle BI Foundation Suite

Overview

What is Oracle Analytics Server?

Oracle Analytics Server, replacing the former Oracle BI Foundation Suite is a business intelligence reporting and analytics platform. It provides users with a series of integrated tools for ad-hoc query and analysis, dashboard and scorecard creation, enterprise reporting, mobile analytics,…

Read more
Recent Reviews

Fantastic BI Solution

10 out of 10
March 03, 2022
Incentivized
Multiple departments use Oracle Analytics Server for Data visualization and Operational Data Modeling. It is lightning-fast for accessing …
Continue reading

Great BI Software

8 out of 10
December 26, 2018
Incentivized
At our cyber services consulting firm we have been long-term customers of Oracle Enterprise products. We purchased the Oracle BI …
Continue reading

Comprehensive BI suite

8 out of 10
December 24, 2018
Incentivized
We have been using a number of Oracle products at our company and recently purchased the BI Foundation Suite to address our analytics and …
Continue reading
Read all reviews

Awards

Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards

Popular Features

View all 28 features
  • Publish to PDF (38)
    9.2
    92%
  • Multi-User Support (named login) (38)
    9.2
    92%
  • Formatting capabilities (38)
    8.1
    81%
  • Report Formatting Templates (38)
    7.1
    71%
Return to navigation

Pricing

View all pricing
N/A
Unavailable

What is Oracle Analytics Server?

Oracle Analytics Server, replacing the former Oracle BI Foundation Suite is a business intelligence reporting and analytics platform. It provides users with a series of integrated tools for ad-hoc query and analysis, dashboard and scorecard creation, enterprise reporting, mobile analytics,…

Entry-level set up fee?

  • No setup fee

Offerings

  • Free Trial
  • Free/Freemium Version
  • Premium Consulting/Integration Services

Would you like us to let the vendor know that you want pricing?

20 people also want pricing

Alternatives Pricing

What is Microsoft Power BI?

Microsoft Power BI is a visualization and data discovery tool from Microsoft. It allows users to convert data into visuals and graphics, visually explore and analyze data, collaborate on interactive dashboards and reports, and scale across their organization with built-in governance and security.

What is Spotfire?

Spotfire® is a data visualization platform that utilizes predictive analytics. In addition to data viz, it includes data wrangling capabilities, predictive analytics, location analytics, and real-time streaming analytics. Spotfire® is a business unit of Cloud Software Group, formerly known as…

Return to navigation

Product Demos

OAS (Oracle Analytics Server)and DV (Data Visualization)

YouTube
Return to navigation

Features

BI Standard Reporting

Standard reporting means pre-built or canned reports available to users without having to create them.

8.4
Avg 8.2

Ad-hoc Reporting

Ad-Hoc Reports are reports built by the user to meet highly specific requirements.

8.2
Avg 8.1

Report Output and Scheduling

Ability to schedule and manager report output.

9.1
Avg 8.4

Data Discovery and Visualization

Data Discovery and Visualization is the analysis of multiple data sources in a search for patterns and outliers and the ability to represent the data visually.

8.5
Avg 8.1

Access Control and Security

Access control means being able to determine who has access to which data.

8.8
Avg 8.6

Mobile Capabilities

Support for mobile devices like smartphones and tablets.

7.3
Avg 8.0

Application Program Interfaces (APIs) / Embedding

APIs are a set of routines, protocols, and tools for used for embedding one application in another

7.7
Avg 7.9
Return to navigation

Product Details

What is Oracle Analytics Server?

Oracle Analytics Server (OAS) supersedes the Oracle Business Intelligence (BI) Foundation Suite. It is an on-premises self-service visualization and augmented AI analytics platform. It provides a full range of capabilities including AI that surfaces key insights in datasets, data enrichment features that automatically recommend new elements for analysis, machine learning capabilities for both traditional and citizen data scientists, data visualizations for dashboards and reporting.

Customers that choose this self-managed on-premises or private cloud deployment can manage upgrades on their schedule and implement customization options such as custom skins/styles, metadata, messaging and more.

Key features

  • Easy to use ad-hoc query and analysis
  • Comprehensive suite of data visualizations
  • High quality enterprise reporting
  • Scalable multidimensional OLAP server for forward-looking analysis
  • Mobile app optimized for touch interactions
  • Geospatial mapping and visualization
  • Integrated scorecard and strategy management
  • Ability to act on insight by invoking business processes from within BI
  • Common Enterprise Information Model
  • Machine Learning
  • Natural Language Query

Oracle Analytics Server Technical Details

Operating SystemsUnspecified
Mobile ApplicationNo

Frequently Asked Questions

Oracle Analytics Server, replacing the former Oracle BI Foundation Suite is a business intelligence reporting and analytics platform. It provides users with a series of integrated tools for ad-hoc query and analysis, dashboard and scorecard creation, enterprise reporting, mobile analytics, multidimensional OLAP, and predictive analytics.

Microsoft BI (MSBI), MicroStrategy Analytics, and SAP BusinessObjects Business Intelligence are common alternatives for Oracle Analytics Server.

Reviewers rate Report Delivery Scheduling highest, with a score of 9.8.

The most common users of Oracle Analytics Server are from Enterprises (1,001+ employees).
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews and Ratings

(464)

Attribute Ratings

Reviews

(1-25 of 30)
Companies can't remove reviews or game the system. Here's why
February 17, 2022

OAS Review for fun!

George Yates | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Incentivized
To look at internal usage data and figure out new ways to optimize the user experience. This helps us solve the problems inherent with siloed data and to create one unified pane of glass for all of our reporting needs, whether it be to executives or presenting to the product organization.
  • Connecting to a myriad of data sources
  • Providing easy to use data visualization options
  • Building report ready dashboards that update automatically
  • Design is a little archaic/dated
  • Ease of use could be better
  • Missing some functions present in newer platforms
Oracle Analytics Server is really well suited to being able to build a wide variety of dashboards that can be detailed enough to communicate deep insights, while also being visually well prepared enough to be ready to present to an executive level team. It struggles with outside of the norm visualizations and more complex scenarios.
Score 10 out of 10
Vetted Review
ResellerIncentivized
We are looking to both use and sell products that help us monitor and aggregate data for us and our clients. Oracle's name and reputation are one that is not surpassed. We believe using advanced analytical programs, like Oracle's, will help us stay on top of emerging technologies as well as accomplish our goal of utilizing the data of our company and clients to its fullest.
  • Find anomalies.
  • Understand anomalies.
  • Fix anomalies.
  • Help prevent the problems that it shows us.
  • More AI but with human back up.
  • Less mumbo jumbo so even IT guys/gals can more easily work.
  • More statistics (math) and orientation for those not familiar with it.
  • More live as well as virtual (live) show casing of real situations in business.
Oracle, for anyone that is slightly interested in the goings-on within companies, especially large influential ones on a world scale, know that like IBM and such, is soo admired, that even entities larger than it, have tried to 'knock it' down. But as in life and with man, it is impossible to keep a good thing 'down'. :)
Wiliam de Faria | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
We needed an AI analytics platform to provide a full range of capabilities, including AI that quickly presented key insights into your datasets, data enrichment capabilities that automatically recommended new elements for analysis, and machine learning capabilities to the insurance company's data scientists.
  • Natural language query.
  • Machine learning on data.
  • Data enrichment features.
  • Dashboard.
  • Data enrichment has slower new data discovery performance and its configuration is difficult.
  • News templates for dashboard.
Recommendation for the artistic composition of multiple corporate dashboards and filmmaker's data work. Not recommended as a PII or GDPR data discovery source.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
We used the tool for Analytics purposes on HR data of employees of a huge financial institution (bank). The tool served as an excellent solution to Analytical questions the organisation wanted to ask. HR problems were solved using the BI Answers . Our scope of use case is pretty bast given that the data source was considerably huge
  • Adhoc reports
  • Graphs and Map features
  • Wide data connectivity options
  • Semantic layer
  • UI design
  • More Graphic solutions
  • Drill across implementation
It's an Excellent BI tool for mainly large organisations looking for a single source of truth for BI purposes. Its wide range of features can be used for an entire organization with very good control of Authentication implementation without hassles. Also caters the use of medium sized organization well . Not so worthy of the data source is less and the users are less(usually smaller companies with size less than 1000)
Score 9 out of 10
Vetted Review
Verified User
Incentivized
We use OBIEE with Oracle EBS. Our Finance department uses our OBIEE reports. Our problem is that our EBS data models for the database are not smooth.
  • Proactive detection and alerts.
  • Interactive dashboards.
  • Office integration.
  • User-friendly.
  • Difficulty of use.
  • Data blending.
  • Speed of change.
Adding a new column or a new calculated field or a new table in OBIEE could take several days to months depending on each company’s processes.
Combining data from OBIEE with other external data is not possible for an end-user or superuser.
Aissam Drai | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Oracle BI Foundation is used in our procurement and human resources departments. We also use a custom interface using Oracle BI DW and ODI to report on key metrics for the management to gain visibility to enterprise data. The main goal behind using BI is to gain visibility to data for better decision making.
  • Data Security - Who should see what
  • Seamlessly integrates with Oracle Applications
  • Built in Analytics (OBIA) based on best practices
  • User Interface could be improved to provide the user with a better user experience and better visuals
Oracle BI Foundation is well suited for enterprise data visibility in the format of dashboards. Oracle BI Foundation is less suited for operational reporting that needs to be generated instantly to manage the day-to-day operations in an enterprise.
Oracle BI Foundation is suited to report across platforms and bringing information from different sources.
September 19, 2019

BI Unchained

Score 10 out of 10
Vetted Review
Verified User
Incentivized
The solution is targeted for use across the whole organization. It addresses revenue collection trends, analyses areas of improvement where revenues could be developed further. It also assists management in decision making with regards to expenditure.
  • Being a web based application that runs on an active production environment, it is amazingly light on network utilization and overall resources consumption on the server running it.
  • It has thousands of customizations to generate literally any dataset. This makes it overwhelmingly robust and adaptable.
  • The cloud option cuts acquisition costs by more than half in terms of overheads as compared to on-premise installations.
  • You now don't need to be an Oracle forms developer to be able to customize this powerful tool.
  • It has a fantastic and user friendly GUI.
  • For extremely large databases, data pulling tends to take awhile longer than expected.
  • It is already affordable but we could all use better discounts for the complete edition.
It is best suited for ALL reporting and analytic scenarios really. I can't think of a scenario where it less appropriate or not appropriate to the best of my knowledge. It is simply to die for. It is especially best suited for customer facing scenarios especially.
Score 7 out of 10
Vetted Review
Verified User
Incentivized
Oracle Business Intelligence Foundation Suite, which I will refer from hereon as OBIEE has been heavily used by my current company. We have been using OBIEE for a while but in a limited area. In 2015 thru the 1ADM project, JDE was implemented as an ERP system in ADM. Then OBIEE and its suite of products were chosen for the reporting, data and analytics portion. OBIEE is being used by the whole organization. Some are heavy users and others are moderate. Adhoc query, robust dashboards and enterprise-level reporting are some of the most used features in our company. OBIEE has helped us to solve many business issue and concerns but the main area where it brings value is in operation thru the timely supply of vital information.
  • OBIEE does the ad-hoc query very well. as long as the data is governed, the ad-hoc query is a robust and heavily used feature.
  • OBIEE has one of the best dashboard feature in enterprise level reporting.
  • It has a robust feature for the analytics and data analysis.
  • If scorecards are designed and implemented properly, OBIEE can become every department's go-to tool for reporting.
  • It is expensive to implement.
  • It is time consuming to implement.
  • The learning curve is not as flat as some of the other products in the market for general users.
For a larger sized company that is very process-oriented, this tool can be a blessing. Governed data will give good results, otherwise, it can be a waste of time and money. Compared to the cost and time of implementation and training, participation and buy-in from all departments are important to see the ROI.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Oracle BI is being used by the majority of our organization if not by all. It helps address gaps in our organization through data analysis on dashboards. It helps in understanding the progress of different departments across the organization and gives real-time updates on the performance of various reports that were customized and created using this tool.
  • Oracle helps with easy customization of reports.
  • It helps with the creation of dashboards and the integration of different data sources.
  • Oracle BI was a package used for multiple users across our organization - publishing and distributing reports was a breeze.
  • The tool requires coding and training.
  • The UI is not as intuitive as it should be - there can be improvements to make the reports sharp.
  • The mobile experience should be in-built and automated. The plugins should be available so that the primary focus will be left on reports.
The tool is still very good considering the complexities in data that can be modified within the tool using SQL queries. It can be used with advanced coding to integrate data from non-coherent sources. The only place where it is slightly less appropriate is where there is not a crisp UI. The UI and mobile experience could be more intuitive.
December 24, 2018

Comprehensive BI suite

Score 8 out of 10
Vetted Review
Verified User
Incentivized
We have been using a number of Oracle products at our company and recently purchased the BI Foundation Suite to address our analytics and reporting needs. Presently we are on version 12 of the software product. We use it in our IT department to generate monthly reports for our marketing and sales teams.
  • Can create pixel-perfect reports for mobile phone usage as well.
  • It has best in its class integration capabilities with a wide multitude of software tools and middleware components.
  • Oracle BI has support for intelligent dashboards that can be customized for individual users.
  • Real-time report collaboration features are lacking in this software.
  • Due to the complexity of the software product and insufficient community user support groups, a vendor implementation became necessary for our case.
Oracle BI Foundation is well suited for serving reporting and analytics needs for mid-size and large companies. It features scheduled reporting and robust security architecture.
Vineet Rai | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Incentivized
Oracle BI is being used for pretty long time now for addressing our reporting and analytics needs. We have been upgrading the suite appropriately as the versions are available and are currently on v 12. This is one of the key reporting tools for our organization. It addresses number of daily, monthly and ad-how reporting solutions.
  • Ease of development and quick turnouts as the build is easier compared to some other BI tools for both reporting developers as well as the power users. The RPD development is comparatively easier to build for star schemas and also the subject areas are easier to use by the power users.
  • Easy integration of Mobile BI interface and sharing features in the same layer.
  • Easy integration of other functionality like MapViewer. Multi database type integration is enabled which is not really a distinctive feature in market, but has been improved a lot in OBIEE now.
  • Oracle BI suite needs to overhaul the visualization features as well as the look and feel to improve the ease of use for audience which is familiar with new java based tools.
  • The knowledge base available on Oracle repository or forum needs to be more relevant and updated .
  • They need to keep updating their drivers list or integration with other databases or blending tools/ MDX sources. This is one of the difficulties we faced, causing development cost and time to market impacted.
Well suited for standard reporting or enterprise reporting requirements. Scheduled reports or ad-hoc prompt based /power user report builder capabilities are very good. It has an excellent integration model with Essbase and Oracle Exadata kind of relational back ends. No doubt of it’s strength on end to end enterprise reporting capabilities.
Less appropriate for cool visualization or dynamic interactive dashboards or analytics, D3 kind of capabilities. I found other tools or java based open sources much better in market.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
It is used by a wide range of users in different teams. The primary and most used feature is the business dashboard, which gives an instant overview of the status of all products and services. Some users will be able to drill down if they wish, to more details sections and dig in deeper in their areas of interest.
  • It integrates well with an Oracle database as the data warehouse.
  • Heterogeneous data sources can also be configured and used.
  • It provides certain automation capabilities.
  • Some queries generated can be further improved in terms of query performance.
It is better suited for well-designed and organized data warehouses and data marts. It can take time to get full advantage of all of the features, and users need to be trained and user's active sessions need to be monitored for occasional unrealistic queries generated. It is probably less suited for un-refined raw data.
Hemant Prabhakar Patil | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
We are using the Oracle BI Foundation across the organization for different departments like sales, marketing, finance, and renewal contracts. It helps various business departments to analyse the data for making better business decisions.
  • We can use the pre-built Oracle BI Apps model & dashboard/reports in OBIEE. This provides real ease to analyze the data for every business areas of organization with pre-defined KPIs.
  • Oracle BI Foundation includes BI Publisher which supports varied options for delivering the reports via email, printer, shared location, fax. BI Publisher also provides all language compatibility support.
  • Oracle BI Foundation has Exalytics, which delivers amazingly fast performance reports in combination with the Times Ten Database.
  • It's easy to integrate OBIEE & BI Publisher and that provides the flexibility to use BI Publisher for report template building based out of OBIEE Model.
  • OBIEE can provide some changes in the user interface, which has been carried out with the same look and feel almost from version 10 to 12c.
Oracle BI Foundation Suite becomes perfect to use when organizations are also using Oracle EBS for order management, service contracts, install base modules and all other modules of EBS. OBIEE pre-built BI apps and reports/dashboards can be used easily. Oracle BI Foundation Suite is best suited for enterprise-wide reporting. OBIEE requires understanding on the subject area model to create better reports when compared to other simple tools out in the market to build the reports.
Sumeet Saraf | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
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.
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.
Juan Osegueda | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
At Hostmark the Oracle BI Suite is the included reporting segment of UltiPro. Using Oracle Business Intelligence allows me to extract data then write or modify reports to use with all sorts of data analysis. Currently all managers are assigned access to BI to run common payroll, human resource, and benefit reports to help them make decisions. These reports are specialized or formatted to pull the information that our managers need whenever the default reports included with UltiPro don't exactly match the formatting or reporting requirements our managers are looking for.
  • With a little guidance, ease of use
  • Great database management system with just the right amount of options (scalability)
  • Create dashboards for various types of users
  • Can be overwhelming to use at first, but any report-writer would suggest to download data dictionaries first to locate fields and prompts that would ordinarily be hard to find

It doesn't matter what sector you are in. You can use Oracle Business Intelligence to extract whatever data you need for decision making. Our managers use it for all sorts of things: in payroll, to report how many hours their employees are working and to track overtime, in human resources to validate all new hire information and to audit hours worked for full-time/part-time employee classification, and in benefits to find out if any employee vs. employer-paid premiums are in balance and determine benefits eligibility, to name a few.

For the normal user (which we do not give BI access to), having access to this data would be overkill.

October 27, 2017

Oracle BI Suite Review

Krishan Mohil | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Incentivized
I am helping customers in my organization implement Oracle BI Foundation Suite. It helps customers integrate their online application with the Oracle BI tool to help them understand how their business is performing and helps identify the gaps or advance the features of business to grow their business lines. It is used by specific departments. It helps businesses to resolve their accounting and marketing applications.
  • It helps integrate with online applications and provide the complete data warehouse solution.
  • It provides features of adhoc and customized reporting.
  • It has strong visual features to help business needs and supporting integration with different tools like Microsoft Office etc.
  • It is easy to learn by business user to create their own adhoc reports.
  • It should help migration BI solution using other tools with in itself rather creation from start as solution.
  • It should have some feature of in memory data capture for slicing and dicing of data
It should have answer from its infrastructure needs, to installation, to implement existing application or new application, easy to use and help business to design their requirements.
Mary O'Basuyi | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Oracle’s Business Intelligence Foundation Suite has a wide variety of features, some of which are indicated below. However, we want to note that Oracle is one of the few vendors that supports big data capability. Big data refers to a collection of large data sets that are complicated to analyze by traditional software. One of the benefits of Oracle’s Exalytics component is that it can analyze large sets of data in a short time.
  • Ad Hoc Analysis, Online Analytical Processing (OLAP), Predictive Analysis, Profit Analysis, Trend Indicators
  • Ad Hoc Reporting, Automatic Scheduled Reporting, and Customizable Dashboard
  • Ad Hoc Analysis
  • Online Analytical Processing (OLAP)
  • Automatic Scheduled Reporting
  • Profit Analysis
  • Trend Indicators
Office Integration – Office Integration allows users to merge their reports and analyses into their Microsoft Office programs (Word, Excel, etc.) and can even run analyses via Excel.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Oracle BI Foundation suite had been exceptionally helpful to me and co-workers because it helps us to build better reports for senior management teams and help us with budget planning and task management while keeping everything in one place.
  • I love that there are so many different programs all rolled into one suite. It makes it easier than having to switch formats or applications all the time.
  • Interface could use a face lift as it feels a little clunky, but still very usable!
It's great for larger companies because it can hold a large amount of data. Also great for companies that don't want to pay more to have several different programs.
Dan Hotka | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
I am a trainer for the OBIEE part of Oracle BI Foundation Suite. I find the suite of tools to be a great way to analyze and present data to end user teams and upper management. I find the interface rather easy to use. The OBIEE product allows you to make very comprehensive dashboards, where, the end users and/or management teams can quickly see at a high level what is going on, then drill to the supporting detail with the click of a mouse. I find the alerts to be of particular value as OBIEE can monitor and alert you when certain data conditions exist. You can use the score card software to automate some or all of your business decision processes, based on data in your data stores.
  • I like the drag and drop feature of building reports. Tables show up as folders and columns as items within the folder. Most of the reports can be built with a simple drag and drop operation.
  • If you are familiar with the SQL query language, you can definitely use these skills to enhance the reports and information on the reports.
  • I think the alerts is a major useful component of OBIEE...in that...it can monitor your data and let you know when certain conditions exist. No surprises, no missing useful and timely information.
  • It is all web-based development and deployment. You don't need to install any software at your workstation at all.
  • I suppose OBIEE could directly access more data sources but this is also easily accomplished via the underlying Oracle RDBMS and their gateway technologies.
This product is well suited for anyone doing data analysis. It is all web-based. The deployment is a snap. I can say this is a great solution for companies with a sales force that needs up to the minute information on their mobile devices. Sure, lots of products can do this too...but OBIEE makes deployment to both workstations and mobile devices a snap. The dashboards present the information easily and the most important information can easily be featured in the center. A click can drill to the related supporting information.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
We use Oracle BI Foundation Suite (BI) across all the organization. We have trained all our end users to use BI, because we have decided to remove Discoverer from our EBS side. It helped our users to do reporting much more easily and it gives them freedom to create charts.
  • This is not a replacement for Discovery and is not going to replace any transactional report. You can have balances of each account in BI but not the entire trial balance.
  • The focus of this suite is analytical reporting not transaction reporting.
  • If you are using security with EBS, then implementing security with EBS is a challenge, no proper documentation is available from Oracle, so opening an SR is useful.
  • Template builder should be more user friendly.
Great:
1) Adhoc reports
2) Generating graphs of available data.

Not that great:
1) Transnational report.
2) Complicated query which may time-out.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
It is generally used to pull custom reports throughout the organization. We use it to make several reports depending upon clients' need. Whenever they implement Oracle Fusion or Oracle EBS, we give them module specific reports using Oracle VI Foundation Suite. These reports depend on the modules we have implemented. For example, if we have Oracle Time and Labor implemented, we generate a report containing time entries, total time spent, the expenditure type etc., which can be used by the client to interface with their external payroll systems such as ADP.
  • Custom Reports
  • Integration with Oracle HCM
  • Graphs and charts
  • The OTBI where you can drag and drop the subject area items is full of bugs, one such example is when you are rearranging the columns in a report it might not show up immediately.
  • The formulas you use for OTBI reports are pretty basic which results in something as simple as doing an addition of three columns - also a difficult task.
  • Lack of documentation.
Considering the amount of options and integrations it offers and the lack of similar softwares around, it is good choice for most. Oracle BI Foundation suite is exceptionally helpful if you are using Oracle HCM, SCM or EBS system since it will be directly integrated with these systems. Not only can you pull the data from those systems, you can integrate it with them so well that you can display the reports and graphs made through Oracle BI Foundation Suite right in the Fusion, EBS system directly.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
It is attached as a reporting tool to our MRP software and it is being used across the whole company. Departments such as purchasing, finance, sales and manufacturing take advantage of the Oracle BI features on a daily or weekly basis. It helps us to create KPIs and sophisticated dashboards for real time visibility and to allow for making more intelligent business decisions. Remote users and traveling employees take advantage of the of the great reporting tools due to the mobile version of the Oracle BI software. Upper management makes important high level decisions based on the results of the reporting coming from this tool.
  • Easy to use
  • Improved Key Performance Indicators with the use of BI Suite
  • Support for intelligent dashboards creation
  • Real time data visibility
  • Mobile and offline features
  • Ad-hoc reporting
  • Clustering capable
  • Accurate and centralized reports
  • Heavy processes
  • Requires powerful machines and configuration for quick use
  • Relative big cost
  • Requires skillful database background users.
  • Room for improvement in the collaboration section
  • Integration with other software could be done easier; room for improvement
Oracle BI Foundation Suite is a great tool for metric and modern reporting. It's easy to use and user friendly, and has excellent data consolidation features. It is well suited for a large number of transactions or records (likely big or medium sized companies). Based on the cost of the software I would not recommend it for a small database with a reduced number of transactions.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
I am a service provider and work with multiple organizations, of all verticals, implementing Oracle BI Foundation Suite. I have seen this implemented across departments of organizations. This software will address lots of verticals but is famous for - Financial Reporting, Supply Chain and Management, and Student Analytics. This software is so wonderful that organizations who prefer D3JS graphs can call them right into their Oracle BI Foundation Suite. This will open the users to endless open source graphs - D3JS.
  • Oracle BI Foundation Suite is mostly a file system driven software. This cuts down the cost of DBA or databases and is easy to maintain. All the Repository and Catalog are stored on the file system. They can be easily copied over for migration.
  • Oracle BI Foundation Suite is very well integrated with Oracle Fusion Middleware. Oracle ERP is the leading ERP in the market and no other product can integrate so well with Oracle ERP than OBIA, be it JDE, PSFT, or EBS. OBIA cuts down more than 30% in costs while implementing Business Intelligence on an Oracle ERP.
  • Oracle BI Foundation Suite also integrates well with a majority of third party softwares for security (LDAP), SSO and SSL.
  • Though Oracle BI Foundation Suite became a part of FMW, administration should be still done at the local files. I like to manage all of the parameters in configuration files moved to Enterprise Manager. So, it will be easy to manage when we have a cluster instead of editing each file on each server.
  • It would be a great feature if we had a dedicated URL for monitoring. We can do that in Enterprise Manager but have to check for each component performance individually.
  • There are some glitches with the Administration Tool while working online. Oracle doesn't have a checkout / check-in functionality that lets multiple users to work on the online repository at the same time. They developed MUDE but that is not a real solution for most of organizations.
Oracle BI Foundation Suite is well suited for most scenarios. Organizations just have to choose the right product for implementation. We have seen organizations using Business Intelligence for transactional reporting purposes - which is wrong and kills the actual purpose. There is a Transactional Reporting module of Oracle BI Foundation Suite which serves that need.
Jude Odu | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Incentivized
The Oracle BI Suite was an enterprise-wide implementation at two of my previous places of employment. It was used primarily for business intelligence reporting and analysis. My first use of it was within a 12 hospital health system with millions of rows of data and a user base of around 150 end users.
  • Oracle BI Suite is a comprehensive suite able to handle any size of data as well as complex analytical requirements.
  • With proper training, most end users can be taught to use the front-end in a relatively short period of time.
  • It plays very well with Oracle databases, obviously, so for companies that are an Oracle shop already, it can be implemented as a logical next step for business intelligence.
  • Oracle BI is a very bulky and, to a large extent, unwieldy application. It almost invariably requires a dedicated, full-time technical resource to manage it on an ongoing basis.
  • The dashboard visuals could use a lot of improvement, especially when compared to more modern BI applications that sell well largely due to their impressive visuals.
  • The resulting reports could be a bit more user-friendly and more intuitive. Again, this is one area where more modern BI platforms have a distinct advantage over Oracle BI.
Oracle BI Suite is better suited for very large organizations or multi-national corporations with massive amounts of data. Smaller organizations or situations where only a few million rows of data are available would be better served to go with smaller, nimbler BI applications that can be deployed much quicker and much more cost effectively.
Carlos Sanz Porro | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized

Oracle covers all the technological needs of a company. Reporting requirements are covered with BI Publisher, and ad-hoc reports can be distributed to all of the strategic line. I love Oracle Answer. Users can create their own reports and share them with the rest of the organization. Oracle has an intermediate layer where dimensions and metrics that will be used are defined. This allows for greater control by the IT department. Other tools allow you to connect faster data, but there are risks involved in not being in control of the data.

I have worked with many end customers which have used this technology, and the key to success is the use. It is important to be involved at all stages: analysis, development and implementation. Oracle BI is not a simple deployment tool as it has very powerful features and it’s hard to see that all are used in all companies. For example, I have seen rarely seen the Oracle scorecard implemented, because it occurs at a very advanced stage of understanding business data.Overall, I have seen very good satisfaction with the Oracle solution.

  • Self Service - Oracle answer keeps the multi-language fields with custom tooltips in dimensions and measures to facilitate their use. We can even assign security dimensions and measures that can be used by users who want them.
  • Complete solution - reporting, analytics, scorecard.
  • Unification of data, the architecture makes the solution on that can leverage the same information for reporting, analytics and dashboarding.
  • BI Publisher - it is the best tool for customized reports with Microsoft Word. Users can distribute these reports to the entire organization by applying rules shipments.
  • Our customers say that the technical documentation is extensive and difficult to understand.
  • Data Integration - difficult integration with origins that are not database, but does allows some.
Data integration is not very good with Oracle BI Foundation, so you should have other solutions such as Oracle Data Integrator. Other BI solutions allow better integration with disparate data sources. Oracle BI Foundation is not a departmental solution, it is an enterprise solution.
Return to navigation