Search Results bsc_kpi_analysis_measures_b

Overview

The BSC_KPI_ANALYSIS_MEASURES_B table is a core data structure within the Balanced Scorecard (BSC) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It serves as the base table for storing the configuration of analysis measures associated with Key Performance Indicators (KPIs). This table is essential for defining the specific data series, dimensions, and datasets that underpin the analytical views and performance breakdowns available for a KPI within the Balanced Scorecard framework. Its role is to establish the link between a high-level indicator and the granular, multi-dimensional data used for its detailed evaluation and root-cause analysis.

Key Information Stored

The table's primary key structure reveals the composite nature of an analysis measure definition, which is uniquely identified by a combination of columns pointing to a specific KPI, data series, and analysis dimensions. Key columns include INDICATOR, which references the KPI identifier from BSC_KPIS_B; SERIES_ID, which identifies the specific data series for analysis; and DATASET_ID, which links to the source dataset definition in BSC_SYS_DATASETS_B. The ANALYSIS_OPTION0, ANALYSIS_OPTION1, and ANALYSIS_OPTION2 columns typically hold identifiers for the dimensional breakdowns or analysis axes (such as Organization, Time, or Product) that are applied to the measure, enabling multi-dimensional analysis.

Common Use Cases and Queries

This table is primarily accessed during the configuration of KPI analysis and the runtime generation of detailed performance reports. A common administrative use case is querying all analysis measures defined for a specific KPI to audit or modify its analytical depth. For reporting and integration, a typical query involves joining this table to its descriptive translation table (BSC_KPI_ANALYSIS_MEASURES_TL) and to the base KPI and dataset tables to extract a full definition.

Sample Query:
SELECT kpi.NAME kpi_name,
       meas.SERIES_ID,
       tl.NAME measure_name,
       ds.DATASET_CODE
FROM BSC_KPI_ANALYSIS_MEASURES_B meas,
     BSC_KPIS_B kpi,
     BSC_KPI_ANALYSIS_MEASURES_TL tl,
     BSC_SYS_DATASETS_B ds
WHERE meas.INDICATOR = kpi.INDICATOR
AND meas.INDICATOR = tl.INDICATOR
AND meas.SERIES_ID = tl.SERIES_ID
AND meas.DATASET_ID = ds.DATASET_ID
AND kpi.INDICATOR = :p_kpi_id;

Related Objects

The table maintains critical foreign key relationships with other central BSC tables, forming an integral part of the data model.

• BSC_KPIS_B: The parent table, linking the analysis measure to its parent Key Performance Indicator.
• BSC_SYS_DATASETS_B: Links the measure to the underlying dataset that supplies the actual data values.
• BSC_KPI_ANALYSIS_MEASURES_TL: The translation table that stores the user-facing names and descriptions for the analysis measures in multiple languages.
• BSC_KPI_SERIES_COLORS: References this table to store display properties, such as chart colors, assigned to each analysis measure series.