Search Results bsc_kpi_dim_sets_tl




Overview
Explore in AI Chat

Overview

The BSC_KPI_DIM_SETS_TL table is a core repository for multilingual descriptive information related to Key Performance Indicator (KPI) dimension sets within the Oracle E-Business Suite Balanced Scorecard (BSC) module. As a translation table (denoted by the '_TL' suffix), its primary role is to store user-friendly names and descriptions for dimension sets across multiple installed languages, enabling global deployments. A dimension set defines the analytical perspectives (such as Product, Geography, or Time) through which a KPI's performance data can be sliced, aggregated, and analyzed. This table is integral to the configuration and presentation layer of the Balanced Scorecard, ensuring that dimension set labels are correctly displayed in the user's preferred language throughout the application interface and reports.

Key Information Stored

The table's structure centers on a composite primary key and language-specific descriptive columns. The primary key consists of DIM_SET_ID and INDICATOR, which uniquely identifies a specific dimension set for a given KPI. The INDICATOR column is a foreign key to the BSC_KPIS_B table, linking the descriptive text to the base KPI definition. While the exact column list is not fully detailed in the provided metadata, standard Oracle E-Business Suite translation table conventions dictate the presence of a LANGUAGE column (and often a SOURCE_LANG column) to identify the language of the translated text. The core content columns typically include DIM_SET_NAME and potentially a DESCRIPTION field, holding the translated labels for the dimension set. The table's design supports the simultaneous storage of multiple translations for a single dimension set record.

Common Use Cases and Queries

This table is primarily accessed for user interface rendering and for generating localized reports. Common operational and reporting queries include retrieving the translated name for a specific dimension set in the current session language or extracting a full list of all dimension set translations for a given KPI to support data migration or reconciliation tasks. A typical join pattern to fetch a KPI's dimension set names in the user's language would involve BSC_KPIS_B, BSC_KPI_DIM_SETS_B (the base table), and BSC_KPI_DIM_SETS_TL. For example:

  • SELECT kpi.NAME, tl.DIM_SET_NAME FROM BSC_KPIS_B kpi, BSC_KPI_DIM_SETS_B ds, BSC_KPI_DIM_SETS_TL tl WHERE kpi.INDICATOR = ds.INDICATOR AND ds.DIM_SET_ID = tl.DIM_SET_ID AND ds.INDICATOR = tl.INDICATOR AND tl.LANGUAGE = USERENV('LANG');

Administrators may also query this table to audit or manage translation completeness across installed languages.

Related Objects

BSC_KPI_DIM_SETS_TL sits at a critical junction within the Balanced Scorecard schema, maintaining defined relationships with several key configuration tables. It references the base KPI definition and is referenced by numerous objects that define the analytical behavior of a dimension set.

These relationships underscore that the descriptive records in BSC_KPI_DIM_SETS_TL are foundational to the configuration of data sources, default values, dimension groups, hierarchy levels, and analysis properties for a KPI's dimensional analysis.