Search Results bim_edw_rvct_dly_f




Overview
Explore in AI Chat

Overview

The BIM_EDW_RVCT_DLY_F table is a core data warehouse fact table within the Oracle E-Business Suite Marketing Intelligence (BIM) module. As a daily derived fact table, it serves as the central repository for aggregated marketing performance metrics, specifically tracking revenue and cost data on a daily granularity. Its primary role is to support complex analytical reporting and performance dashboards by providing a pre-joined, dimensionally modeled dataset that correlates financial outcomes with key marketing entities such as campaigns, leads, and opportunities. This table is integral to the EBS Business Intelligence infrastructure, enabling users to analyze the return on investment (ROI) and effectiveness of marketing initiatives directly within the Oracle EBS environment.

Key Information Stored

While specific measure columns are not detailed in the provided metadata, the table's structure is defined by its extensive foreign key relationships. It stores daily snapshots of quantitative facts, which typically include metrics like revenue amount, cost amount, quantity, and count of transactions. The semantic meaning of these facts is defined by their dimensional context. The key stored information is therefore the set of foreign key columns that link to dimension master tables, creating a star schema. These include CMPGN_FK_KEY, EVENT_FK_KEY, LEAD_FK_KEY, OPPORTUNITY_FK_KEY, HEADER_OFFER_FK_KEY, and LINE_OFFER_FK_KEY, among others. Additional keys for ITEM_FK_KEY, ORG_FK_KEY, and CUSTOMER_FK_KEY extend the analysis into operational and customer dimensions.

Common Use Cases and Queries

This table is primarily used for generating marketing performance and pipeline analysis reports. Common use cases include calculating campaign ROI by comparing generated revenue against costs, analyzing lead conversion rates by source or status, and tracking opportunity pipeline value over time segmented by target market or sales channel. A typical analytical query would join this fact table to several dimension tables to produce a readable report.

Sample SQL Pattern:

Related Objects

The BIM_EDW_RVCT_DLY_F table has a defined star schema relationship with numerous dimension tables (EDW_BIM_*_M) within the BIM product, as documented by its foreign keys. The primary related objects are: