Search Results bsc_kpi_analysis_groups_pk

Overview

The BSC_KPI_ANALYSIS_GROUPS 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 a master table for defining and storing analysis groups, which are logical collections used to organize and evaluate Key Performance Indicators (KPIs). The table's primary role is to establish a many-to-many relationship between KPIs and their associated analysis options, enabling complex performance measurement and analytical frameworks. By linking KPIs to specific analysis criteria, it provides the foundational data model for slicing and dicing performance metrics across various business dimensions within the Balanced Scorecard application.

Key Information Stored

Based on the provided metadata, the table's structure is defined by a composite primary key. The key columns are the primary data points stored in this table, with their relationships to other objects defining its purpose.

• ANALYSIS_GROUP_ID: A unique identifier for a specific analysis group definition. This ID, combined with the INDICATOR, uniquely identifies each record in the table.
• INDICATOR: This column stores the identifier for the Key Performance Indicator (KPI) to which the analysis group is linked. It establishes a foreign key relationship to the BSC_KPIS_B table, ensuring referential integrity to valid, defined KPIs.

The combination of these two columns forms the primary key (BSC_KPI_ANALYSIS_GROUPS_PK), meaning that for any given KPI (INDICATOR), multiple distinct analysis groups (ANALYSIS_GROUP_ID) can be defined, and vice-versa.

Common Use Cases and Queries

This table is central to configuring how KPIs are analyzed. Common use cases include setting up performance dashboards where a single metric, like "Revenue Growth," needs to be analyzed by different dimensions such as Region, Product Line, and Customer Segment. Each dimension would be a separate analysis group. Administrators or implementers would populate this table to define these relationships. A typical query would retrieve all analysis groups configured for a specific KPI to understand its analytical scope:

SELECT ANALYSIS_GROUP_ID FROM BSC.BSC_KPI_ANALYSIS_GROUPS WHERE INDICATOR = :KPI_ID;

Conversely, to find all KPIs associated with a particular analysis group (e.g., "Region"), a query would join to the KPI master table:

SELECT k.NAME FROM BSC.BSC_KPIS_B k, BSC.BSC_KPI_ANALYSIS_GROUPS g WHERE g.INDICATOR = k.INDICATOR AND g.ANALYSIS_GROUP_ID = :ANALYSIS_GROUP;

Reporting and data extraction routines heavily rely on this table to determine the available analytical dimensions for each performance metric before drilling down into detailed analysis option values.

Related Objects

The BSC_KPI_ANALYSIS_GROUPS table sits at the center of a key relationship hierarchy within the BSC schema, as documented by its foreign key constraints.

• Referenced Table (Parent):
  • BSC_KPIS_B: The table references BSC_KPIS_B via the INDICATOR column. This ensures every analysis group is attached to a valid, existing KPI.
• Referencing Tables (Child/Dependent):
  • BSC_KPI_ANALYSIS_OPTIONS_B: This is the primary child table. It references BSC_KPI_ANALYSIS_GROUPS using both the INDICATOR and ANALYSIS_GROUP_ID columns. While the provided metadata snippet shows a partial relationship, the full foreign key typically includes both columns to link specific analysis option values (e.g., "North," "South," "East," "West" for a "Region" group) back to the specific KPI and analysis group combination defined in this master table.

This relationship chain—BSC_KPIS_B → BSC_KPI_ANALYSIS_GROUPS → BSC_KPI_ANALYSIS_OPTIONS_B—forms the essential data model for configuring multidimensional KPI analysis in Oracle Balanced Scorecard.