Skip to main content

What is OBIA? Oracle BI Applications and various Components of OBIA

Oracle BI Applications
The increasing volumes and complexity of data provide a strategic opportunity for organizations to turn information into business intelligence.This has resulted in OBIA. We will see what are the important features of OBIA(Latest version is  Oracle Business Intelligence Applications, v. 7.9.6.1).

Definition:
Oracle Business Intelligence Applications is a prebuilt business intelligence solution that deliver intelligence across an organization, empowering users at all levels from front line operational users to senior management with the key information they need to maximize effectiveness.

Sources for OBIA
EBS or Oracle E-Business Suite
Oracle’s Siebel Applications
Oracle’s PeopleSoft Applications
Oracle’s JD Edwards Applications
Non-Oracle sources such as SAP Applications.


Oracle Business Intelligence Application (OBIA) is composed of : 
INFORMATICA
+
DAC
+
OBIEE

Components of OBIA
Components
Description
DAC Repository metadata files:
Content includes repository objects such as
tables, subject areas, execution plans, and tasks, and
is contained in XML files.The DAC client and server were included until version 7.9.5. Since then it is a separate installer.
Embedded Informatica ETL tool and repository
ETL is a third party tool which includes mappings (wrapped in workflows) to extract data from the supported source systems (various versions of standard applications such as Siebel CRM - yes it was first - , Oracle eBusiness Suite, Peoplesoft, JDEdwards and SAP (BI Apps version 7.8.4) ) and load the data into the Oracle Business Analysis Warehouse.
Prebuilt metadata content
This metadata content is contained in the Oracle BI
Applications repository file (OracleBIAnalyticsApps.rpd).
It maps the source physical tables to a generic business model and includes more than 100 presentation catalogs (aka subject areas) to allow queries and segmentation using Oracle BI clients such as Answers, Dashboards and Segment Designer
Prebuilt reports and dashboard content
Contains hundreds of requests and ready-to-use dashboards which enable tight integration between the source applications and the BI infrastructure
Oracle Business Analytics Warehouse
The prebuilt data warehouse that holds data extracted, transformed, and loaded from the
 transactional database
Ad-hoc Analysis
Metadata layer serves as foundation to provide flexible and intuitive ad-hoc reporting
and custom dashboard designs through Oracle BI Answers and Oracle BI Dashboard
tools that are part of the OBIEE toolset.
Role-Based Dashboards
Delivered role-based dashboards are easily configurable to meet specific organizational
needs and practices.
Oracle BI Applications includes the following modules:
  • Oracle Financial Analytics (Manage financial performance across locations, customers, products, and territories, and receive real-time alerts on events that may impact financial condition)
  • Oracle Human Resources Analytics (Correlate financial measures with key workforce metrics to demonstrate HR’s strategic value in the organization)
  • Oracle Procurement and Spend Analytics (Creates visibility to spending patterns for both direct and indirect spend, enabling users to identify and realize the savings opportunities, with the ability to do the spend analysis by commodities, suppliers, supplier locations, buying locations, business units, cost centers, buyers and contract usage)
  • Oracle Project Analytics
  • Oracle Supply Chain and Order Management Analytics
  • And more….
 You can also read more about What a DAC is and Full Load in DAC.

Tables Used by OBIA
Table
Description
Aggregate tables (_A)
These tables contain summed (aggregated) data.
Dimension tables (_D)
Dimension tables with descriptive data
Staging tables for Dimension(_DS)
These tables contain the data which is to be loaded to Target
Fact tables (_F)
Tables storing facts and measures
Dimension Hierarchy tables (_DH)
Tables that store the dimension's hierarchical structure
Fact Staging tables (_FS)
Staging tables used to hold the metrics being analyzed by dimensions that have not been through the final ETL transformations.

Internal Tables in Oracle Business Analytics Warehouse
Internal tables are used primarily by ETL mappings for data transformation and for controlling ETL runs. These tables are not queried by end users and are not directly managed by the Oracle Data Warehouse Administration Console (DAC).
Name
Purpose
W_DUAL_G
Used to generate records for the Day dimension.
W_COSTLST_G
Stores cost lists.
W_EXCH_RATE_G
Stores exchange rates.

Comments

Post a Comment

Popular posts from this blog

Create Accounting for a Payment generates errors 95333 and 95359

Create Accounting for a Payment generates errors 95333 and 95359 Error: 95333: A conversion rate does not exist to convert USD to AUD for the conversion type Corporate and conversion date 20-MAR-09 for line -25. Please use the Daily Rates form in General Ledger to enter a conversion rate for these currencies, conversion date and conversion type. 95359: There is no accounted amount for the subledger journal entry line. Please inform your system administrator or support representative that: The source assigned to the accounting attribute Accounted Amount has no value for extract line number 88547. Please make sure the source assigned to the accounting attribute Accounted Amount has a valid value, or assign a different source to this accounting attribute. Solution: 1. Specify a conversion rate for the currencies and conversion date mentioned in the error message 95333 Navigation under the General Ledger responsibility: Setup > Currencies > Currency Rates Manager > Daily Rates ...
15 comments
Read more

Public API’s for FA Transactions

Public API’s for FA Transactions So far Oracle FA is have all the good things except the lack on reporting.Oracle FA is now offer lot of public API's that can be used to interfacing with third party or Oracle application other modules. Here are some of transaction's API's:   Additions API if you have requirement to add assets directly via PL/SQL then use  FA_ADDITION_PUB.DO_ADDITION. If you have selected the Allow CIP Assets check box on the Book Controls window of a tax book when adding CIP assets using the Additions API, the this API automatically adds those CIP assets to that tax book at the same time that they are added to the corporate book. Adjustments API you can make cost adjustments to your assetsdirectly via PL/SQL using  FA_ADJUSTMENT_PUB.DO_ADJUSTMENT  for any  process adjustment. Detail can be found in appendix H) You can use this API if you have a custom interface that makes it difficult to use with the existing Oracle Assets interfaces for adjusti...
Post a Comment
Read more

AP Table Relation Oracle Apps

AP Table Relation Oracle Apps ORACLE PAYABLE TABLE RELATION Source Table Dependent Table Condition AP_INVOICE_LINES_ALL AIL ZX_LINES_SUMMARY ZLS AIL.invoice_id = ZLS.trx_id and  ZLS.application_id  = 200 and  ZLS.entity_code  = 'AP_INVOICES' and  ZLS.event_class_code  in ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS') and  AIL.summary_tax_line_id = ZLS.summary_tax_line_id AP_INVOICE_LINES_ALL AIL ZX_LINES ZL AIL.invoice_id = ZL.trx_id and  ZL.application_id  = 200 and  ZL.entity_code  = 'AP_INVOICES' and  ZL.event_class_code  in ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS') and  AIL.line_number = ZL.trx_line_number AP_INVOICE_DISTRIBUTIONS_ALL AID ZX_REC_NREC_DIST ZD AID.invoice_id = ZD.trx_id and  ZD.application_id  = 200 and  ZD.entity_code  = 'AP_INVOICES' and  ZD.event_class_code  in ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS') and...
Post a Comment
Read more