Search Results bm_flag

Overview

The BSC.BSC_KPI_ANALYSIS_MEASURES_B table is a core configuration table within the Oracle E-Business Suite Balanced Scorecard (BSC) module. It stores the definition of analysis measures associated with each Key Performance Indicator (KPI), capturing how a given indicator is sliced across analysis dimensions, plotted on charts, and compared against benchmarks or budgets. In Oracle EBS 12.1.1 and 12.2.2, this object underpins the graphical and analytical presentation of KPIs in the Daily Business Intelligence and Balanced Scorecard dashboards.

Each row identifies a particular analysis measure through the combination of an indicator code, three analysis option identifiers, and a series identifier. The table resides in the APPS_TS_TX_DATA tablespace with PCTFREE 10, and its indexes are held in APPS_TS_TX_IDX. Based on the foreign key structure, the heuristic Data Vault classification is satellite-leaning: the object primarily stores descriptive attributes and flags that qualify an underlying business key (the KPI measure), rather than acting as a hub or link. This classification is a modeling suggestion, not a normative designation.

Key Information Stored

The table contains 16 columns. The most significant for functional and reporting purposes are:

• INDICATOR — Numeric indicator code; foreign key to BSC_KPIS_B. This is the parent KPI to which the measure belongs.
• ANALYSIS_OPTION0, ANALYSIS_OPTION1, ANALYSIS_OPTION2 — Analysis option values for analysis groups 0, 1, and 2. Together with INDICATOR and SERIES_ID these form the composite primary key and the unique index BSC_KPI_ANALYSIS_MEASURES_B_U1.
• SERIES_ID — Series identifier that distinguishes multiple data series within the same analysis measure.
• DATASET_ID — Dataset identifier; foreign key to BSC_SYS_DATASETS_B. Indexed by the non-unique index BSC_KPI_ANALYSIS_MEASURES_B_N1.
• KPI_MEASURE_ID — Surrogate unique key representing the combination of analysis options and data series; enforced by unique index BSC_KPI_ANALYSIS_MEASURES_B_U2.
• AXIS — Chart axis placement (1 = Left, 2 = Right).
• SERIES_TYPE — Defines the rendering type of the series.
• STACK_SERIES_ID — Base series identifier used for stacking related series.
• BM_FLAG — Indicates whether a benchmark applies to the measure.
• BUDGET_FLAG — Indicates whether budget values apply.
• DEFAULT_VALUE — Marks the measure as preselected by default.
• SERIES_COLOR and BM_COLOR — Colour codes for the series and its benchmark respectively.
• PROTOTYPE_FLAG — Flag designating a prototype/base series.

The surrogate primary key is BSC_KPI_ANALYSIS_MEASURES_B_PK (ANALYSIS_OPTION0, ANALYSIS_OPTION1, INDICATOR, SERIES_ID, ANALYSIS_OPTION2), while the business-key candidates are the two unique indexes U1 and U2.

Common Use Cases and Queries

The most frequent use case is retrieving the analysis measures configured for a given KPI, including benchmark and budget flags, so that dashboards render the correct series, colours, and axis placements.

• Identifying which measures use benchmarks: SELECT INDICATOR, KPI_MEASURE_ID FROM BSC.BSC_KPI_ANALYSIS_MEASURES_B WHERE BM_FLAG = 1;
• Listing default series for chart rendering: ... WHERE DEFAULT_VALUE = 1 AND BUDGET_FLAG = 0;
• Joining to indicator metadata: SELECT m.INDICATOR, m.SERIES_ID, k.KPI_NAME FROM BSC.BSC_KPI_ANALYSIS_MEASURES_B m, BSC.BSC_KPIS_B k WHERE m.INDICATOR = k.INDICATOR;
• Resolving dataset context: joining on DATASET_ID to BSC_SYS_DATASETS_B.
• Reporting on colour configuration for series and benchmarks via SERIES_COLOR and BM_COLOR.

Related Objects

• BSC.BSC_KPIS_B — parent KPI definition; joined on INDICATOR.
• BSC.BSC_SYS_DATASETS_B — dataset definitions; joined on DATASET_ID.
• BSC.BSC_KPI_ANALYSIS_MEASURES_TL — translation table for measure labels; references this table through ANALYSIS_OPTION2.
• BSC.BSC_KPI_SERIES_COLORS — series colour configuration; references this table through ANALYSIS_OPTION2.
• BSC_KPI_ANALYSIS_MEASURES_B_PK — composite primary key constraint object.