Search Results edw_bim_ih_media_m

Overview

The table EDW_BIM_IH_MEDIA_M is a dimension table within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 environments. It is owned by the BIM (Marketing Intelligence) schema and is specifically designated as an "Interaction Media Dimension Table." Its primary role is to serve as a master reference for categorizing and describing the various channels or media through which customer interactions occur, such as email, phone, web, or social media. This table is a foundational component for analytical reporting within the now-obsolete Marketing Intelligence module, enabling the analysis of interaction data by media type within the enterprise data warehouse (EDW) layer. The "Obsolete" status of the parent module indicates that while the table exists in the database, it is part of a legacy functional area that is no longer under active development by Oracle.

Key Information Stored

As a dimension table, EDW_BIM_IH_MEDIA_M is structured to hold descriptive attributes for interaction media. The documented primary key column is MDIA_INTRCTN_MEDIA_PK_KEY, which uniquely identifies each media type record. While the full column list is not provided in the excerpt, typical attributes for such a dimension would include a surrogate key (the PK), a natural key from the source transaction system, and descriptive columns. These likely encompass a media name or code (e.g., 'EMAIL', 'WEB_FORM'), a description, and potentially attributes for categorization, hierarchy, and ETL process control flags (like active/inactive status or last update date). The table's design supports slowly changing dimension behavior to track historical changes in media definitions over time.

Common Use Cases and Queries

The primary use case for this table is to enable dimensional analysis and reporting on customer interactions. It is joined to fact tables to break down interaction volumes, durations, or outcomes by the channel used. A typical analytical query would join this dimension table to the related interaction fact table to generate a report. For example, to analyze interaction counts by media type, a query might follow this pattern:

• SELECT m.MEDIA_NAME, COUNT(f.INTRCTN_KEY) AS INTERACTION_COUNT
• FROM BIM_EDW_INTRCTNS_F f,
• EDW_BIM_IH_MEDIA_M m
• WHERE f.INTRCTN_MEDIA_FK_KEY = m.MDIA_INTRCTN_MEDIA_PK_KEY
• GROUP BY m.MEDIA_NAME;

This table is essential for building OLAP cubes or dashboards that provide marketing and service managers with insights into channel effectiveness, customer preference, and interaction routing efficiency.

Related Objects

The documented metadata specifies a direct foreign key relationship with the BIM_EDW_INTRCTNS_F table. This is almost certainly a fact table storing individual interaction transaction records. The foreign key column in the fact table, BIM_EDW_INTRCTNS_F.INTRCTN_MEDIA_FK_KEY, references the primary key of EDW_BIM_IH_MEDIA_M, enforcing referential integrity and ensuring every interaction is linked to a valid media type. The primary key constraint on this table is named EDW_BIM_IH_MEDIA_M_PK. As part of the broader EDW schema within the BIM module, it may also be referenced by other dimensional models, materialized views, or legacy BI Publisher data models related to marketing interaction analytics.