Search Results change_dim_set




Overview
Explore in AI Chat

Overview

The BSC.BSC_KPI_ANALYSIS_GROUPS table is a core configuration object within the Oracle E-Business Suite Balanced Scorecard (BSC) module, shared with Enterprise Performance Foundation / Enterprise Planning and Budgeting analytical components. It stores the definition of analysis groups that are associated with individual Key Performance Indicators (KPIs). Each row represents a distinct analysis group tied to an indicator, capturing the group identifier, the number of analytical options it exposes, dependency behavior between parent and child groups, and whether the group influences the dimension set used for slicing KPI results. In Oracle EBS 12.1.1 and 12.2.2, this table is validated and owned by the BSC schema with FND design data registered under BSC.BSC_KPI_ANALYSIS_GROUPS, making it eligible for standard EBS patching and DDL synchronization through AD utilities. Physically it resides in the APPS_TS_TX_DATA tablespace with a PCT Free of 10.

Under a heuristic Data Vault classification mined from the foreign key structure, this object leans toward a satellite role: it carries descriptive, attribute-bearing context about an indicator (a hub candidate) whose primary surrogate identity is ANALYSIS_GROUP_ID combined with INDICATOR. Modeling tools should treat it as an attribute-satellite attached to the KPI indicator hub rather than as an independent hub or a pure link.

Key Information Stored

The table holds eight documented columns. The composite primary key BSC_KPI_ANALYSIS_GROUPS_PK is defined over ANALYSIS_GROUP_ID and INDICATOR. A parallel business-key candidate, BSC_KPI_ANALYSIS_GROUPS_U1, is a unique index over the same two columns (INDICATOR, ANALYSIS_GROUP_ID) in APPS_TS_TX_IDX. The most important columns are:

  • INDICATOR — the numeric indicator code that identifies the parent KPI; also the foreign key to BSC_KPIS_B.
  • ANALYSIS_GROUP_ID — the surrogate analysis group identifier, part of the composite primary key.
  • NUM_OF_OPTIONS — the number of analysis options defined for the group.
  • DEPENDENCY_FLAG — indicates whether the group's options depend on another group.
  • PARENT_ANALYSIS_ID — the parent analysis group identifier, supporting hierarchical dependencies.
  • CHANGE_DIM_SET — the flag the user searches against: it determines whether selecting an option in this group changes the dimension set used to render the KPI.
  • DEFAULT_VALUE — the default analysis option applied when no explicit selection is made.
  • SHORT_NAME — the VARCHAR2(30) display label for the group.

Common Use Cases and Queries

Typical usage includes reporting which KPI analysis groups alter the dimension set, tracing parent-child group hierarchies, and diagnosing incorrect KPI drill behavior. A search for change_dim_set resolves directly to flag inspection and updates:

  • Identify all groups that change the dimension set: SELECT INDICATOR, ANALYSIS_GROUP_ID, SHORT_NAME FROM BSC.BSC_KPI_ANALYSIS_GROUPS WHERE CHANGE_DIM_SET = 1;
  • Find dependent groups and their parents: SELECT * FROM BSC.BSC_KPI_ANALYSIS_GROUPS WHERE DEPENDENCY_FLAG = 1 AND PARENT_ANALYSIS_ID IS NOT NULL;
  • Join to options using the composite key: SELECT g.SHORT_NAME, o.* FROM BSC.BSC_KPI_ANALYSIS_GROUPS g, BSC.BSC_KPI_ANALYSIS_OPTIONS_B o WHERE g.INDICATOR = o.INDICATOR AND g.ANALYSIS_GROUP_ID = o.ANALYSIS_GROUP_ID;

Related Objects

The most significant related objects, based on documented FK and dependency data, are:

  • BSC.BSC_KPIS_B — the KPI definition table, referenced by BSC_KPI_ANALYSIS_GROUPS.INDICATOR.
  • BSC.BSC_KPI_ANALYSIS_OPTIONS_B — child options table; it references this table via INDICATOR and ANALYSIS_GROUP_ID.
  • APPS.BSC_KPI_ANALYSIS_GROUPS — the APPS-synonym-accessible view of the same underlying table used by forms and reports.
  • Additional BSC KPI analysis and dimension-set configuration objects, and the Balanced Scorecard concurrent programs that consume analysis group metadata at runtime.