- 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.
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.
- Analyze information at different levels of aggregation.
- Graphs and charts are easily produced.
- It is very nice to organize the screen with different views of the same information, all with common parameters. So you can analyze related information from many point of view, all in the same page.
- It is very flexible to add fields to the report, to change orders, to transform a column into a parameter and vice versa.
- I think it should evolve in its graphic capabilities to compete more strongly with other market tools.
- It has good capabilities to integrate maps with information. However, this feature is sold separately, and is quite expensive. That's why, even when we need it, we decided not to use it.
- In South America there are many resources that really dominate the tool. For this reason, or you end up paying very expensive values for resources, or you end up working with consultants with knowledge of other tools. This in general allows us to develop the models that are needed, but we are definitely not making the most of all the capabilities.
- 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.
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.
- 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.
- Oracle BI Foundation suite is an overall package of enterprise reporting, multi-dimensional analytical processing, and real-time quick reporting.
- Oracle BI Foundation has Exalytics, which delivers fast performance reports.
- It has the flexibility to run on different platforms as it is built on Java.
- The tool is not easy to use.
- Oracle BI reporting of administration needs to be simplified for better administration and maintenance.
- 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.
- Middle layer where we can model data for any complex requirement. On presentation layer, we can make it very business friendly.
- Very powerful capability and even customization by languages/scripts is available.
- Data Security and Object security are very strong. It is provided various [types of] granularity.
- Formatting and look & feel is not so great for default development unless you make efforts on it.
- For simple things or quick developments, it takes considerable efforts to bring it completion from end to end.
- 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
- 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.
- 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.
- Ad Hoc Analysis, Online Analytical Processing (OLAP), Predictive Analysis, Profit Analysis, Trend Indicators
- Ad Hoc Reporting, Automatic Scheduled Reporting, and Customizable Dashboard
Oracle BI Foundation Suite Review: "A Close Look at Oracle' OBIEE product (a part of Oracle BI Foundation)"
- 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.
- Better integration with Oracle R12
- Ease of Use and scalability
- Customizations for complex requirements
- Performance is a bit slow and needs improvement
- Better visualizations are needed to compete with other competitive tools.
- 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!
- 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.
- 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.
1) Adhoc reports
2) Generating graphs of available data.
Not that great:
1) Transnational report.
2) Complicated query which may time-out.
- 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.
- Reporting, for our company and when recommending it to our clients its a huge selling point.
- Especially the granular graphs, they can be adjusted for what each needed person (CFO, CEO, Managers) specifically requires.
- It's also helpful to determine where the "bottlenecking" could be occurring within workflow.
- Although after a quick tutorial or testing from an IT end, some users struggle with learning the software.
- This is not uncommon for a learning curve but having quicker resources to point users to for learning would be beneficial. Something such as a direct video less than 5 minutes on how to complete specific functions will help the training.
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.
- Oracle Business Intelligence Reporting platform is well enhanced with many advanced features like Visualization Recommendation for Power users when building the dashboards and Reports like which view to use based on the type of data that we are presenting to the end users.
- Oracle BI Mobile APP Designer is very rich and has useful functionality to develop the dashboards and reports and display them on the mobile devices via Apps
- Oracle Essbase, multi-dimensional Online Analytical processing system which uses the advanced calculation engine for financial forecasting, planning and management reporting.
- Oracle BI Publisher Reporting capabilities caters to the needs of real time pixel perfect reporting with out lot of development time.
- Overall Oracle BI Foundation Suite is a conglomeration of Enterprise Reporting, Real time quick reporting, multi-dimensional analytical processing, BI Mobile, Geo-spatial capabilities which every organization needs today for Analytical and Reporting needs
- Oracle BI Reporting Administration needs to be simplified for easier Administration and maintenance. Today Admins need to deal at different levels (Enterprise Manager, Weblogic Console, BI Admin Tool) to handle the day to day Admin and Maintenance operations
- In order to take advantage of the Geo-Spatial (maps) capabilities you need to have Oracle Database at place as the pre-built maps related data is developed and available only in Oracle Database. Organization who doesn't use Oracle Database have to struggle to get this feature work.
- BI Mobile APP Designer configuration and set up needs to be simplified when upgrading from previous versions
- Endeca uncovers patterns and relationships in your data that traditional BI tools are not built for.
- Endeca has been used for a wide variety of business problems including warranty support, directing social media spending, and optimizing staffing efficiency.
- Endeca is not well suited for small or medium sized businesses.
- Fast response time on reports
- Ease of generating report
- Ease of managing access to the reports
- The model is strictly star and there is no exception
- Too many layers between reporting service and database, so query generated is totally whacky
- The reporting data flow is not seamless and needs lots of hard coding
- Centralized Dashboards that answer key business questions regarding performance and need to knows. The tool is dynamic in that is can provide not only individual queries, but also enterprise wide dashboard reports.
- Dynamic reporting for one to 1000s of users depending on the server infrastructure.
- The tool has a high learning curve and can take time to master.
- The tool cannot uptake data in other formats easily. The data must be structured in specific tables and set up in the middle layer.
- Due to the complexity of the tool, there can be bugs in the development that occur at random which can be difficult to trace to the tool or the environment.
- Powerful tool providing analytics without the business needing to understand SQL or database tables.
- Interface is logically organized for quick and easy start up, but also allows for complex report building.
- Multiple usage models - ad-hoc querying, dashboards with pre-defined prompting, report scheduling, data level security
- The performance of the web interface has degraded with 11g. Moving between screens used to be instantaneous. It now takes several seconds. All navigation is slower.
- Support team at Oracle is difficult to work with. I'd say they know the answer to the problem at best 50% of the time. They request numerous files and don't seem to look at them. They always recommend upgrading which is an easy task.
- Installation and configuration is much more complex in 11g. We used to be able to perform a major upgrade in 6 weeks. Now it takes that long for a small patch. All patches have to be tested extensively as they always introduce some new problem.
Oracle BI Foundation Suite Scorecard Summary
Feature Scorecard Summary
About Oracle BI Foundation Suite
Oracle BI Foundation Suite Competitors
Oracle BI Foundation Suite Technical Details