Results for “bsc_kpi_analysis_groups”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

BSC_KPI_ANALYSIS_GROUPS is a table in the BSC (Balanced Scorecard) product schema of Oracle E-Business Suite, documented as VALID in ETRM for releases 12.1.1 and 12.2.2. The table stores analysis group information used by the Balanced Scorecard module to organize KPI indicators into logical groupings that drive analysis behavior, dependency handling, and default value resolution across scorecard deployments.

Under a heuristic Data Vault classification mined from its foreign key structure, BSC_KPI_ANALYSIS_GROUPS leans toward the satellite category. A satellite records descriptive, context-bearing attributes attached to a parent business key rather than defining new entities or relationships. Here, each row supplies descriptive configuration (option counts, dependency flags, parentage, default values, short names) about a KPI indicator, which itself is the parent business key referenced from BSC_KPIS_B. This classification should be treated as a modeling suggestion for warehouse design rather than a fixed architectural fact.

Key Information Stored

The documented physical schema for 12.1.1 contains eight columns in the BSC schema. The most significant are summarized below.

• INDICATOR — The KPI indicator identifier. This column forms part of the composite primary key and is a foreign key to BSC_KPIS_B, anchoring each analysis group definition to its parent indicator.
• ANALYSIS_GROUP_ID — The analysis group identifier. Combined with INDICATOR, it constitutes the composite primary key BSC_KPI_ANALYSIS_GROUPS_PK.
• NUM_OF_OPTIONS — The number of options configured for the analysis group, governing the cardinality of selection choices presented to end users.
• DEPENDENCY_FLAG — Indicates whether the analysis group participates in a dependency relationship with another group.
• PARENT_ANALYSIS_ID — References the parent analysis group, enabling hierarchical or dependent group structures.
• CHANGE_DIM_SET — Controls whether the dimension set associated with the group may be changed.
• DEFAULT_VALUE — The default value applied to the analysis group when no explicit selection is made.
• SHORT_NAME — A concise display label for the analysis group, used in reports and user interfaces.

Two unique indexes are documented as business-key candidates: BSC_KPI_ANALYSIS_GROUPS_PK on (ANALYSIS_GROUP_ID, INDICATOR) and BSC_KPI_ANALYSIS_GROUPS_U1 on (INDICATOR, ANALYSIS_GROUP_ID). These enforce uniqueness across the same column pair in different orderings, confirming the composite business key identity of the table.

Common Use Cases and Queries

Typical uses center on configuring and reporting KPI analysis behavior. Analysts join this table to BSC_KPIS_B to resolve indicator names for active analysis groups, and to BSC_KPI_ANALYSIS_OPTIONS_B to enumerate the selectable options defined within each group. Common patterns include:

• Listing all analysis groups for a given indicator, including short names and default values, to validate scorecard configuration.
• Identifying groups with DEPENDENCY_FLAG set, then traversing PARENT_ANALYSIS_ID to reconstruct dependency hierarchies.
• Auditing NUM_OF_OPTIONS against the actual option rows in BSC_KPI_ANALYSIS_OPTIONS_B to detect configuration drift.
• Reporting which indicators have groups that permit dimension set changes via CHANGE_DIM_SET.

A representative query joining the primary key to its parent indicator is:

SELECT g.INDICATOR, g.ANALYSIS_GROUP_ID, g.SHORT_NAME, g.DEFAULT_VALUE FROM BSC.BSC_KPI_ANALYSIS_GROUPS g, BSC.BSC_KPIS_B k WHERE g.INDICATOR = k.INDICATOR;

Related Objects

The following objects have documented relationships to BSC_KPI_ANALYSIS_GROUPS:

• BSC_KPIS_B — Referenced by the INDICATOR foreign key. Supplies the parent KPI definition for each analysis group row.
• BSC_KPI_ANALYSIS_OPTIONS_B — Depends on this table through INDICATOR and ANALYSIS_GROUP_ID. Stores the individual options belonging to each analysis group.
• BSC_KPI_ANALYSIS_GROUPS_PK — The composite primary key index on (ANALYSIS_GROUP_ID, INDICATOR).
• BSC_KPI_ANALYSIS_GROUPS_U1 — The unique index on (INDICATOR, ANALYSIS_GROUP_ID) acting as a business-key candidate.

Together these objects form the KPI analysis configuration layer of the Balanced Scorecard module.