These applications
directly access OLTP schema (Oracle??™s Daily Business Intelligence) or more commonly
access solutions with infrastructure similar to traditional data warehouses.
Examples of product suites that take the latter approach include Oracle Business
Intelligence Applications, PeopleSoft EPM, and SAP??™s Business Warehouse, all often
deployed on Oracle databases.
The business intelligence applications often focus on specific areas of the business,
such as marketing or financial analysis. For example, Oracle??™s Hyperion Financial Performance
Management applications address financial planning and budgeting. Such
applications include predefined queries, reports, and charts that deliver the kind of
information required for a particular type of business analysis while sparing the business
user the complexity of creating these objects from scratch. The data warehousing
type of solutions also include prebuilt ETL from supported data sources.
248 | Chapter 10: Oracle Data Warehousing and Business Intelligence
Oracle E-Business Suite??™s Daily Business Intelligence (DBI) provides access into Oracle
transactions tables and materialized views.
Pages:
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546