Search Results bsc_kpi_analysis_options_b




Overview
Explore in AI Chat

Overview

The BSC_KPI_ANALYSIS_OPTIONS_B table is a core data structure within the Oracle E-Business Suite Balanced Scorecard (BSC) module, present in both releases 12.1.1 and 12.2.2. It serves as the base table for storing the hierarchical configuration of analysis options used during the evaluation of Key Performance Indicators (KPIs). This table defines the permissible analytical dimensions and their relationships, enabling users to drill down into KPI performance data from summary levels to granular detail. It is fundamental to the analytical framework that supports strategic performance management and reporting within the application.

Key Information Stored

The table's primary key is a composite of ANALYSIS_GROUP_ID and OPTION_ID, ensuring uniqueness within a defined analysis context. The INDICATOR column is a critical component, linking the analysis option to a specific KPI. The structure supports multi-level hierarchies through the GRANDPARENT_OPTION_ID and PARENT_OPTION_ID columns, which define the lineage and nesting of analysis options. While the provided metadata does not list all columns, the foreign key relationships indicate the presence of a DIM_SET_ID column, which links to a defined dimension set (BSC_KPI_DIM_SETS_TL), thereby specifying the analytical perspective (e.g., by Geography, by Product Line) for the option.

Common Use Cases and Queries

This table is primarily accessed to retrieve the valid analysis paths for a given KPI or to populate user interface elements in scorecard analysis pages. A common reporting requirement is to list all analysis options for a specific indicator within a particular analysis group. The following query pattern illustrates this:

  • SELECT OPTION_ID, PARENT_OPTION_ID, DIM_SET_ID FROM BSC.BSC_KPI_ANALYSIS_OPTIONS_B WHERE INDICATOR = :p_indicator AND ANALYSIS_GROUP_ID = :p_analysis_group_id ORDER BY PARENT_OPTION_ID, OPTION_ID;

Another critical use case is during data aggregation and drill-down operations, where the hierarchical relationships defined in this table are traversed to roll up or decompose KPI values. System administrators may also query this table to audit or maintain the analysis option hierarchies configured for enterprise KPIs.

Related Objects

The table maintains integral relationships with several other BSC module objects, as documented by its foreign keys. The primary foreign key references BSC_KPI_ANALYSIS_GROUPS, linking via ANALYSIS_GROUP_ID and INDICATOR to define the overarching analysis framework. It references BSC_KPI_DIM_SETS_TL via DIM_SET_ID to associate a dimension set. The table BSC_KPI_ANALYSIS_OPTIONS_TL holds the translated names and descriptions for the options stored in this base table, joined on the composite key (ANALYSIS_GROUP_ID, OPTION_ID, INDICATOR, PARENT_OPTION_ID, GRANDPARENT_OPTION_ID). Furthermore, the table BSC_KPI_ANALYSIS_OPT_USER references this base table using the same composite key, likely to store user-specific customizations or security settings for analysis options.