1. Main reasons for using DBI:
• Highly efficient, scalable and performs very well due to summarized materialized views on top of EBS tables in a single instance.
• Quick implementation and OOTB (out of the box) set of reports for EBS
• Executive level reporting along with rapid insight into operational business processes at the detail level
• Integrated BI to provide information within EBS screens
• Pre-aggregated summarized dashboard reporting for a single EBS instance
• Tightly integrated with Oracle EBS and can drill down into the transaction detail.
What it was not meant for:
• Provide an Enterprise wide BI solution
• Complex customization & extensions, e.g. adding complex metrics & dimensions
• Data integration with content outside of single EBS instance
• A substitute for a data warehouse
2. OBI (Oracle Business Intelligence) pre-built Applications
• Out of the box pre-built “Data Warehouse” for Oracle EBS
• Capability to integrate multiple data sources & versions
• Support for multiple languages & currencies
• Integrates many business processes for analysis
• Provides an Enterprise wide BI solution based on the data warehouse
• Ease of customizations and extensions using Answers and Informatica ETL
• Most Oracle EBS ETL mappings pre-defined and available to plug-in
• Can integrate with non-Oracle EBS data sources as well
Comparing OBI with DBI for Order Management functional area
| Order Management | OBI Analytics | Daily Business Intelligence |
| Number of Dashboard Pages | 18 | 8 |
| Number of Reports | 100 | 73 |
| Number of Metrics | 307 | 33 |
| Primary Roles Supported | 7 | 2 (can be extended) |
| Support Multiple Sources | Yes | No |
| Provide a standardized, single business view across entire organization | Yes | Yes |
| Customizable Dashboards | Yes | Yes |
| Move and transform the data (ETL) | Yes | No |
| Data Warehouse | Yes | No |
| Drillable | Yes | Yes |
When to Use DBI or Oracle BI Apps
DBI is a good option when:
• Budget is low and there is no significant customization
• Need quick implementation while OBI apps rolled out (or custom DW)
• Appetite for BI investment or content is low
• Plan to use both DBI and OBI apps
• Only need reporting from a single EBS source
OBI Apps is a better option when:
• there is scope of various customizations
• You need a true “Data Warehouse” outside the oltp instance.
• You don’t want to build a DW from scratch
• You need to implement, grow, extend, evolve in a short time frame.
No comments:
Post a Comment