Oracle business intelligence applications modules

The upper image is of the BI Administration Tool and as can be seen the platform is installed but there is no content, this all needs adding manually after an analysis and design stage. This pre-built approach differs from the OBIEE manifests itself in the application layer as can be seen from the screenshots below. The diagram below shows a comparative approach to a traditional data warehouse against OBIA. When building a traditional data warehouse, a significant amount of time and effort is given over to the analysis and build of the warehouse. Oracle BI Applications Vs OBIEE Implementation ApproachДЄn OBIA implementation differs from a traditional data-warehouse build, in that it is complete with pre-built, pre-mapped and pre-packaged insights based upon best practice principles. The presentation server formats the data into the required format and through web server, the request is presented to the end user. The presentation server interacts with OBI Server and OBI server will understand the requests and hits the OBAW if itвЂ™s not cashed and extracts the data and provides it to the presentation server.ДЁ.

The request comes through the web server and interacts with the presentation server.Д§. After the ETL is complete and OBAW is online, an OBIEE end user runs a dashboard or report in the Answers or Interactive dashboard.Д¦. Then the data are extracted, transferred and loaded from the transactional databases into the OBAW target tables.ДҐ. The informatica server executes the commands issued from DAC, and uses the objects and configuration data stored in the informatica repository.Д¤.

The DAC server uses the object and configuration data stored in the DAC repository to issue commands to the informatica Server.ДЈ. First, the DAC scheduler kicks off jobs to loadrefresh the OBAW at regular intervals or alternatively, these jobs could be kicked off manually from the DAC client.Дў. The below diagram shows the Architecture of the OBI AppsДЎ. The pre-built OBIEE repository and web catalog are aligned with the Business Analytics Warehouse and contain the domain specific and end user facing dashboards, reports and KPIвЂ™s. The pre-built Business Analytics Warehouse is one single but modular data warehouse model to support one or a combination of the source systems. The pre-built ETL repository includes not only routines for changed data capture, extract to staging area and the load into data warehouse tables, but also seed data for common dimensions like the time dimension or dimension lookup files with domain values or dimension value sets to support sources independent metric calculation. The figure below diagram presents a functional overview of OBIA. The ETL repository tailored for the source applications The Oracle BI Applications pre-packaged content comes with three main pre-built repositories:Дў. The BI Applications are built upon the foundation of Oracle BI Enterprise Edition which means that they allow extension of the suite with additional data sources and own-built dashboards and reports. Oracle Contact Center Telephony Analytics Oracle Supply Chain and Order Management AnalyticsД¤. Oracle BI Applications includes the following modules:ДЈ. These solutions transform and integrate data from a range of enterprise sources, including Siebel, Oracle E-Business Suite, as well as corporate data warehouses. Oracle Business Intelligence Applications are a set of prebuilt solutions that deliver business intelligence across an organization, giving users the key information they need to maximize effectiveness.

Oracle business intelligence applications modules