Search Results bsc_kpi_dim_levels_user




Overview
Explore in AI Chat

Overview

The BSC_KPI_DIM_LEVELS_USER table is a core data object within the Oracle E-Business Suite Balanced Scorecard (BSC) module. It functions as a user-specific extension table that stores personalized dimension level selections for Key Performance Indicators (KPIs). In the Balanced Scorecard framework, dimensions (like Time, Geography, or Product) and their hierarchical levels are used to analyze KPIs from multiple perspectives. This table enables the system to maintain and retrieve the specific dimension level preferences for each individual user, ensuring personalized and consistent analytical views across the application. Its role is critical for tailoring the performance management experience to individual user responsibilities and reporting needs in both EBS 12.1.1 and 12.2.2.

Key Information Stored

The table's structure is defined by a composite primary key that uniquely identifies a user's setting for a specific dimension level of a KPI. The key columns are DIM_LEVEL_INDEX, DIM_SET_ID, INDICATOR, and USER_ID. The DIM_LEVEL_INDEX and DIM_SET_ID, along with INDICATOR, are foreign keys linking to the base dimension level definitions in the BSC_KPI_DIM_LEVELS_B table. The USER_ID column links to the BSC_USERS table, identifying the individual to whom the setting belongs. Collectively, these columns store the fundamental relationship mapping which user has access to or prefers which granularity of data (dimension level) for a given KPI within a specific dimension set.

Common Use Cases and Queries

A primary use case is the initialization and rendering of a user's personalized scorecard or KPI detail page. When a user logs in, the application queries this table to determine the default dimension levels at which to display each KPI. For administrative purposes, queries may be written to audit or manage user preferences. A common reporting pattern involves joining to the base dimension table and user table to produce a readable list of settings.

  • Retrieve a User's Dimension Level Settings:
    SELECT * FROM BSC.BSC_KPI_DIM_LEVELS_USER WHERE USER_ID = 1234;
  • List Settings with Descriptive Information:
    SELECT u.USER_ID, l.INDICATOR, l.DIM_SET_ID, l.DIM_LEVEL_INDEX
    FROM BSC.BSC_KPI_DIM_LEVELS_USER u, BSC.BSC_KPI_DIM_LEVELS_B l
    WHERE u.DIM_LEVEL_INDEX = l.DIM_LEVEL_INDEX
    AND u.INDICATOR = l.INDICATOR
    AND u.DIM_SET_ID = l.DIM_SET_ID;

Related Objects

The BSC_KPI_DIM_LEVELS_USER table has defined foreign key relationships with two other core BSC tables, as documented in the ETRM metadata.

  • BSC_USERS: The USER_ID column in BSC_KPI_DIM_LEVELS_USER references the BSC_USERS table. This relationship validates and links to the defined user within the Balanced Scorecard module.
  • BSC_KPI_DIM_LEVELS_B: This table references the base table BSC_KPI_DIM_LEVELS_B via a composite foreign key on the columns DIM_LEVEL_INDEX, INDICATOR, and DIM_SET_ID. This ensures that every user-specific setting corresponds to a valid, system-defined dimension level for a KPI.