Factors To Consider When Installing Oracle Business Intelligence

  1. Declarative model, you can achieve complex GUI tasks with just some lines of code.
  2. Based on the declarative aspect of hierarchical widget containers and objects, you can easily and quickly change the GUI.
  3. Data integration via services so you have the option to use many backend technologies, servers and databases (database and server agnostic).
  4. Data in “bind” to components by means of properties so no need to create models to bridge the data between the server and the GUI widgets in most of the cases.
  5. Very powerful IDE based on Eclipse with “two-way” design view, full debug and profiling.
  6. Much smaller footprint in terms of memory, CPU and load time compared to similar applications in HTML/CSS/JS.
  7. Modular architecture so a big application can be split in modules and loaded by demand.
  8. Easy to integrate third-party components.
  9. Very rich GUI framework with most of the components already available and required by most applications.


Philip Mankoff | Blog

Maurice Berdugo, Managing Partner at BP Analytics:

The best business intelligence tool in my opinion is Oracle’s OBIEE tool. It has a huge customer base, growing in popularity and is backed by Oracle that is investing heavily in the product.

Why I like the product is that it is:

  • Extremely Flexible
  • Has a tool for report writing and Dashboards
  • Has a much better “bug reporting” system than other BI tools.
  • You can set Log Levels and it will show you exactly where the problem is in the code.
  • Adding complex formulas can be done at the RPD layer and you don’t have to be a coder for that.
  • There are bug fixes and updates every month or the tool is getting better and better
  • Costs the same or maybe even a drop less then Cognos/BO


Philip Mankoff | Articles, Blog

Today’s fast-paced business environment demands frequent critical decision-making at all levels of an organization. Oracle Business Intelligence (BI) provides decision makers real-time access to enterprise information residing in data silos. The Oracle BI Analytics tool provides business leaders with the competitive edge needed to make rapid, well-informed decisions.

With the evolution of Oracle E-Business Suite (EBS), R12 drives superior value in all product areas and provides new business advantages over the competition. Core Services provides best-in-class Oracle consulting and hosting services to leverage EBS’ advances, including expanded functionality, scalability, usability and lower cost of ownership.


Oracle Business Intelligence drives the decision in many organizations to upgrade. When implementing or upgrading to EBS R12, the number one challenge most companies face is how to generate reports needed to get the job done effectively and efficiently. The following provides the management conference room questions and discussions Core Services recently completed with a client and outlines the strategy ultimately implemented.

Key Questions to Consider Prior to an ERP Upgrade/Implementation:

  1. Migrating legacy data to a new EBS implementation is hard, time consuming and expensive. In some cases, data is needed but can be relevant for a short time period only and then never looked at again. Should one spend the next couple of months cleansing and migrating short-lived data over to EBS or is there a more effective strategy?
  2. In this case, when reviewing the list of potential EBS users, Core Services discovered that 30 percent were infrequent users who required ERP “read only access.” Can BI help to mitigate licensing costs in the event a user simply needs to retrieve data for a report?
  3. The company needed a reporting environment to be extremely agile and flexible. New reporting hierarchies and customized calculations were required for management KPI- and Dashboard-based reporting. Should additional customizations be made in the ERP or in the Data Warehouse?
  4. The company was on an aggressive growth plan. How quickly could the Data Warehouse scale to meet the company’s thirst for additional data?
  5. Some reports generated out of EBS were unformatted (Notepad) or required extensive massaging to make them ready for management. How will BI eliminate time wasted generating these reports?

Factors that Influenced Management Decision:

  1. Costs: Driving the decision was management’s desire to minimize costs while maximizing return on investment. Management and Core Services determined that the cost of cleansing/scrubbing all the legacy historical data could not be justified. The Data Warehouse seemed the more appropriate location to “house” historical legacy data and merge it with the new data extracted out of EBS.
  2. Manual vs. Strategic: Management knew that manually-created reports consumed far too much company time and resources. The Data Warehouse solution empowered employees to quickly and easily generate the reports, thus freeing up time for data analysis.
  3. Not Too Many Changes at Once: Keeping in mind that employees were being completely retrained as they migrated from an old legacy ERP to EBS, management wanted to minimize the amount of change. The question posed to Core Services was, can the reports/calculations operate in the same way as before? Can there be consistency in using the same acronyms and company definitions/terminology to minimize the learning curve?
  4. Scalability: Because management saw acquisitions as an integral part of the growth strategy, the Data Warehouse solution had to enable a rapid deployment and minimize the transfer of large Excel files via email.


Core Services created three reporting schemas (legacy, EBS and a merged schema of legacy and EBS data) concurrently as the EBS modules were being developed, tested and implemented.

The project was completed in six months with canned reports built for Finance, Marketing, Customer Service and Operations. Advanced users utilized Data Cubes for ad-hoc reporting.

The company saved money by eliminating unnecessary user licenses. For the occasional “read only access” user a number of canned and cube-based reports were developed.

After vetting and validation, the Data Warehouse was such a success, providing a high comfort level among the users, that Core Services extended the Data Warehouse by developing customized applications, such as an advanced forecasting modeling application utilizing data from within the Data Warehouse.

With the expectation of acquisitions, Master Data Management became a key component of the Data Warehouse. Changing the data in a centralized system was easier and more cost than managing change at multiple locations all over the world.

Today, the Data Warehouse is integrated into the very of the company’s operations and has proven to save a tremendous amount of time and money and provide the optimal “tool” to help users get their jobs done As the project neared completion, the Core Services team felt a real sense of accomplishment when they walked the hallways and saw so many computer screens smoothly running BI generated reports.

About BP Analytics

BP Analytics is a software development company specializing in developing; reports, analytics and business application development. Our team of hand picked Analyst’s, database developers and programmers work closely with you to understand your business requirements and develop software solutions that addresses your needs. We are extremely cost conscience and deliver software solutions that are within your budget.


Leave a Comment

Your email address will not be published. Required fields are marked *