Oracle OBIEE offers interactive dashboards, robust reporting, and seamless integration with diverse data sources. It provides powerful visualizations and enterprise-level security, making it ideal for large-scale data handling and insightful analysis.

| Author info | Rating | Review Summary |
|---|---|---|
| Director of Statistics and Analysis at a tech company with 1,001-5,000 employees | 4.0 | No summary available |
Company Background:
• Verisign, Inc. operates the domain name registry for .COM, .NET and other Top Level Domain extensions
• There are more than 125 Million registered .COM and .NET domain names
• These domains are in various states, such as:
newly registered, expiring, renewed, or deleted
Department Background:
• The Business Intelligence group is responsible for reporting, modeling, forecasting, and creating a coherent narrative about the 'health' of the domain registry.
• Our group acts as an information 'hub-and-spoke' for many internal customers such as, Marketing, Finance, Product Management, Account Management, and the Executive suite
Data Background:
• The primary source of data comes from Oracle Business Intelligence (OBIEE)
• Oracle 11g running on Linux
• Oracle has always been a principle database in the infrastructure
• Engineering builds some automated reports for external customers with BI Publisher
• Our Business Intelligence Group used to work with Oracle Discover, then OBIEE (v10), and currently migrating to OBIEE (v11)
Process Challenges:
• Company has never provided an opportunity to choose a different BI tool
OBIEE is the legacy company standard
• Currently migrating from OBIEE (v10) to latest version (v11)
• Along with a new data architecture:
Writing user quick guides
Arranging training for business users
Building dashboards from scratch
Recreating Automated Reports (Agents)
Process Advantages:
• After using OBIEE (v10) for three years, there were hundreds of reports in the folder structure
Some were useful, some weren't
• The migration forced us to start from a clean slate because over the past few years we have better idea about what is important to our customers
OBIEE Pro's:
• Interface is improved from earlier (v10) version
Better organization of windows showing the compound layout, views, and subject areas
Easier to configure pivot tables
There is a split screen where you can arrange the columns and rows and view the pivot table results
• Improved ‘Agent’ capabilities
"Agents" is the new term that replaces "iBot”
With v11, possible to subscribe other people to an automated agent
This is better than having to work with Executives and walk them through the process
• Latest version of OBIEE contains functions to obtain values from prior time periods
Makes comparative reports much easier to create
OBIEE Con's:
• OBIEE interface times out for long queries that involve extensive drill-down
The analysis we perform is not limited to rote, summarization of transactional data
Easier to identify the event in the OBIEE reports then submit a SQL query to the database to pull the transactional detail
• OBIEE Excel 2007 download
Selecting the ‘Excel’ download option still only returns 65K rows
• Formatting is time consuming task
Dozens and dozens of ‘clicks’ required to polish a dashboard
When formatting a pivot table, there isn't an obvious way to change the 'fill' color in the upper left box that sits adjacent
to the row labels and the first column
Other Challenges:
• Working with Unstructured Data
Creating segmentations on-the-fly not practically possible
Temporary tables cannot be inserted into the production environment
Exploring Oracle APEX as a solution
Have to download to Excel and then summarize against a lookup
Analysis often merges non-Oracle data with results from OIBEE reports
• Analytics
Our forecasting code doesn’t run in production
Isn’t available within the OBIEE interface
Resulting datasets downloaded into Access for aggregation
OBIEE has some time series functions but very difficult to perform rigorous validations and monitor accuracy without having to customize the XML and PL/SQL options on the ‘advanced tab’ of the query design window
• Dates
We’ve encountered some issues with dates that we did not have with OBIEE v10
The “Month-Year” date format in OBIEE downloads into Excel as a ‘text’ value instead of an Excel Date value with a “MON-YEAR” format
Conclusion: Oracle Business Intelligence is a powerful platform for summarizing data within a DW environment. Despite OBIEE’s interface and feature improvements, its usability remains clumsy with complex queries requiring skilled coders.
| Product | Mindshare (%) |
|---|---|
| Oracle OBIEE | 2.2% |
| Microsoft Power BI | 7.6% |
| Tableau Enterprise | 6.5% |
| Other | 83.7% |
| Company Size | Count |
|---|---|
| Small Business | 31 |
| Midsize Enterprise | 30 |
| Large Enterprise | 83 |
| Company Size | Count |
|---|---|
| Small Business | 468 |
| Midsize Enterprise | 158 |
| Large Enterprise | 314 |
Oracle OBIEE is a comprehensive business intelligence and analytics platform, valued for its ability to integrate seamlessly with multiple data sources and deliver powerful visualizations, including map-based options. Users appreciate its flexible custom report creation, centralized metadata management, and enterprise-level security. This platform facilitates self-service analytics, minimizing IT dependency. Despite these strengths, there are areas for improvement, such as simplifying navigation to ease report creation and data visualization. Performance issues with large datasets and integration challenges with external applications are noted. Enhancements in documentation, support, and the modernization of visualizations could make it even more effective. Licensing costs are high, suggesting a need for architectural simplification and advanced analytics features.
What are the key features of Oracle OBIEE?Oracle OBIEE is utilized across industries for data reporting, business intelligence, and analytics. Companies create dashboards for sales performance monitoring, financial product analysis, and operational and financial reports generation. It supports departments like finance, marketing, and HR, facilitating enterprise-wide reporting and enhancing business intelligence capabilities.
Oracle OBIEE was previously known as OBIEE, Oracle Business Intelligence Enterprise Edition, Oracle BI, Oracle BI EE 11g.
Banca Transilvania, BeckmanCoulter, Hong Kong Housing Society, HealthShare, Ivanhoe Cambridge Unifies, and Home Credit, and Finance Bank.