Business Intelligence with Oracle

Oracle have a range of Business Intelligence technologies and applications. Business Intelligence and Data Warehousing is based on the Oracle database foundation. The latest version of the database, Oracle 10g, includes built in ETL, Data Mining and OLAP functionality. Oracle Business Intelligence solutions offer a range of integrated query, reporting, analysis management and BI application development capabilities. The Oracle E-Business suite includes integrated applications designed to meet reporting, analysis, budgeting & planning, consolidation and KPI dashboards requirements.

 

Oracle Database & Data Warehousing

Oracle OLAP

Oracle OLAP is included as an option to the Oracle 10g Database Enterprise Edition. Based on the successful Oracle Express Server product, Oracle OLAP provides a feature rich powerful calculation engine for modelling multidimensional data.

Oracle Discoverer

Oracle Discoverer is an an-hoc query tool for reporting and analyzing data from data marts, data warehouses, OLTP systems and the Oracle E-Business suite. Oracle Discoverer now allows integration with both relational and multi-dimensional data.

Oracle Warehouse Builder (OWB)

Oracle Warehouse Builder is a development tool for building data warehouse databases. OWB provides a single environment for ETL tasks, data quality checking, relational and dimensional modelling and metadata management.

Oracle Business Intelligence Beans (BI Beans)

Oracle BI Beans enable developers to build business intelligence applications to take advantage of the OLAP functionality within the Oracle database. Oracle BI beans can be packaged modularly within bespoke applications. BI Beans exist for reporting (crosstabs, graphs) and query and calculation beans, which can be deployed in Java or HTML applications. Oracle JDeveloper and BI beans can be used together to build custom BI applications. 

Oracle Business Intelligence Spreadsheet Add In

Oracle Business Intelligence Spreadsheet Add in enables users to access data in Excel from within OLAP analytic workspaces - stored an Oracle 10g database. The standard functionality of Excel can be combined with the powerful analytic capability of Oracle OLAP. Wizards are used to expose query building and calculation building options to the Excel user. 

Oracle Business Intelligence Suites

Oracle Business Intelligence Suite: Enterprise Edition (EE) Plus


Oracle Business Intelligence Suite: Enterprise Edition is Oracle's BI application stack acquired from their Siebel acquisition and previously known as Seibel Analytics.

Oracle BI Enterprise Edition includes the following components:

 - Oracle BI Server
 - Oracle BI Answers
 - Oracle BI Interactive Dashboards
 - Oracle BI Delivers
 - Oracle BI Disconnected Analytics
 - Oracle BI Publisher
 - Oracle BI Briefing Books

Arrow Bullet Click here for more information.

Oracle Business Intelligence Suite: Standard Edition (SE)

Oracle Business Intelligence Suite: Standard Edition is Oracle's BI Application stack previously known as Oracle Business Intelligence 10g.

BI Standard edition includes Oracle Database 10g, with ETL, OLAP, Data Mining included in the data server as well as:

 - Oracle BI Discoverer
 - Oracle BI Warehouse Builder
 - Oracle BI Spreadsheet Add in
 - Oracle BI Beans
 - Oracle Reports Services

Arrow Bullet Click here for more information.

 

Oracle Business Intelligence Suite: Standard Edition One

Oracle Business Intelligence Standard Edition One is a new BI suite offering from Oracle that includes a mix of the Standard and Enterprise Edition components. 

Oracle Business Intelligence Suite SE One includes:

 - Oracle Database Standard Edition One
 - Oracle BI Warehouse Builder
 - Oracle BI Analytics Server
 - Oracle BI Answers
 - Oracle BI Dashboard
 - Business Intelligence Server Administration

Oracle Business Intelligence Suite Standard Edition One is packaged and marketed as a departmental BI solution.

Oracle E-Business Suite

Oracle Corporate Performance Management Applications

 - Oracle Financial Consolidation Hub (FCH)
 - Oracle Profitability Manager
 - Oracle Enterprise Performance Foundation (EPF)
 - Oracle Demand Planning
 - Oracle Activity Based Management
 - Oracle Balanced Scorecard
 - Oracle Performance Analyzer
 

Oracle Enterprise Planning & Budgeting (EPB)

 

Oracle Enterprise Planning & Budgeting (EPB) is an enterprise level budgeting, planning, reporting and analysis tool based on the Oracle OLAP database option integrated as part of the E-Business Suite. EPB uses the common structural and metadata model within the Enterprise Performance Foundation CPM framework.

Arrow Bullet Click here for more information.

Oracle Financial Analyzer (OFA)

 

Oracle Financial Analyzer (OFA) is a budgeting, planning, reporting and analysis application based on the multi-dimensional Oracle Express Server OLAP engine. OFA is integrated with the Oracle General Ledger to allow rapid implementation of Actual, Budget and Encumbrance reporting solutions for Financials data. OFA can be implemented along with Oracle GL or as a standalone product. 

Arrow Bullet Click here for more information.

Oracle Express Server

 

Oracle Express Server is a multidimensional OLAP engine and is the platform upon which the analytic applications OFA / OSA are based.  

Arrow Bullet Click here for more information.

Daily Business Intelligence (DBI)

Oracle Daily Business Intelligence (DBI) is a suite of modules to provide reporting and analysis across E-Business suite modules. DBI provides accurate & timely dashboard reporting capabilities with minimal setup requirements.

 

Email Logo