Customize the Data Pipeline

Business requirements often extend beyond the capabilities of the standard ready-to-use data model delivered with Oracle E-Business Suite Data Intelligence. Organizations frequently need to incorporate additional business attributes, expose source-specific information, or support user-defined reporting requirements that aren't available in the delivered fact and dimension data stores.

This section explains few common use case scenarios for customizing the ready-to-use facts and dimensions, as well as creating custom facts and dimensions in Oracle E-Business Suite Data Intelligence. These scenarios illustrate how user-specific business requirements can be addressed by extending the semantic model while preserving the integrity and consistency of the delivered Oracle data model.

Typical customizations include enriching fact tables with additional transactional attributes, extending dimensions with new descriptive information, incorporating source system-specific columns, and exposing business-critical data required for operational, financial, and analytical reporting. The objective of these examples is to illustrate recommended extension patterns, highlight common business requirements, and provide guidance on implementing scalable, maintainable, and upgrade-safe customizations that align with Oracle's recommended practices.