This post covers a very basic level overview of Oracle BI Applications to help people who are new to BI World.
Oracle BI Applications is a pre-built and pre-packaged business intelligence solution. It includes a server and end user tools such as dashboards, query and analysis, enterprise reporting, disconnected access to the data — all supported by a unified, model-centric server architecture.
Oracle BI Applications supports both Oracle sources, such as Oracle E-Business Suite Applications, Oracle’s Siebel Applications, Oracle’s PeopleSoft Applications, Oracle’s JD Edwards Applications, and non-Oracle sources, such as SAP Applications. If any company already own one of the above applications, they can just purchase Oracle Business Intelligence Enterprise Edition and Oracle BI Applications to work with the application.
Oracle BI Applications also provides complete support for enterprise data, including financial, supply chain, workforce, and procurement and spend sources. These enterprise applications typically source from both Oracle data sources, such as Oracle EBS and PeopleSoft and non-Oracle data sources, such as SAP.
Following Application content is available for the BI Apps : –
– Oracle Financial Analytics
– Oracle Procurement and Spend Analytics
– Oracle Human Resources Analytics
– Oracle Supply Chain and Order Management Analytics
– Oracle Spend Classification Analytics
– Oracle Project Analytics
– Oracle Sales Analytics
– Oracle Service Analytics
– Oracle Marketing Analytics
– Oracle Contact Center Analytics
– Oracle Loyalty Analytics
– Oracle Price Analytics
– Oracle US Federal Financial Analytics
BI Apps consists of following main components:-
a) DAC Repository metadata files : This content includes repository objects such as tables, subject areas, execution plans, and tasks. These files are installed in a ZIP file named export.zip, which you must extract.
b) Informatica PowerCenter ETL tool: This is a third-party ETL platform that performs the extract, transform, and load (ETL) operations for the data warehouse.
c) Pre-built Informatica content : This content includes ETL repository objects, such as mappings, sessions, and workflows, and is contained in the Informatica Repository file (Oracle_BI_DW_Base.rep).
d) Pre-built metadata content: This metadata content is contained in the Oracle BI Applications repository file (OracleBIAnalyticsApps.rpd).
e) Pre-built reports and dashboard content: This content is contained in the Oracle BI Presentation Catalog.
f) Oracle Business Analytics Warehouse : The pre-built data warehouse that holds data extracted, transformed, and loaded from the transactional database.
One of the common question who is new to BI will def ask that Why BI APPS? Why cant we implement it ourself? So I suggest you to go through this link to get your answers. All the BEST!!