Skip to main content

Difference Between OBIEE AND Oracle BI Applications

Oracle BI Apps is the main business intelligence solution from Oracle.Its is packaged along with Oracle Business Intelligence Enterprise Edition - OBIEE and is considered as the platform for Oracle BI Apps.


Difference Between OBIEE AND Oracle BI Applications

The main difference between OBIEE and Oracle BI Applications is that we use OBIEE for developing our own reports (manually)and dashboard while in prebuilt Apps we just need to deploy them without any customization. Also OBIEE Is the engine that holds Oracle BI Applications. Oracle BI holds complete package like Procurement and Spend Analytics ,Finance,HR etc. With Prebuilt Applications we get the physical data model -fact and dimension tables , Business model and presentation catalog -Repository and ETL mappings. We just need to configure them

Oracle BI supports all the below sources
Source
Oracle eBusiness Suite
Peoplesoft
JD Edwards
SAP
Siebel

Why to use Oracle BI Apps ?

The main advantage is that it can be used by any industry irrespective of the kind of departments.If its not suiting then we can customize the reports accordingly.
Using BI Apps the company can deliver greater insight to larger user communities across the organization via dashboards, query and analysis, and alerts.If we are building our own reports we can useOBIEE for that and develop BI metric, reports, and dashboard.Else we can just deploy prebuilt without any customization.
Most organizations needs analytic applications pull data from multiple enterprise sources and shed insight into the status and effectiveness of business operations. For example, a financial analytic application can track actual performance versus budget. A sales analytic application can track the size of the pipeline and identify the most profitable opportunities. A supply chain analytic application can optimize inventory levels, predict product fulfillment needs, and identify order backlog issues. While enterprise applications are required to run the business, analytic applications are mandatory to make sense of it

Advantages of Oracle BI Apps

In comparision with Datamart  and Datawarehouse the prebuilt applications provide the following advantages:
1.Less Time:
These Prebuilt Application requires less time to get deployed and start running. Properly designed analytic packages come with an integrated set of tools, data schemas, business views, and predefined reports and dashboards that significantly accelerate the time it takes to get a BI solution up and running.
2.Better Results:
Oracle BI application can deliver functionality and benefits that would be difficult or impossible for you to reproduce on your own ie with the help of OBIEE ,developing our own reports.
3.Single BI Apps is Enough:
Finally, packaged applications like Oracle Business Intelligence Applications allow organizations
to deploy BI on a small scale for a single department and then expand seamlessly to support
other departments using the same model and platform, delivering a consistent view of enterprise
information

Comments

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 ...

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...

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...