Search Results bsc_sys_dim_groups_tl

Overview

The BSC_SYS_DIM_GROUPS_TL table is a core data object within the Oracle E-Business Suite Balanced Scorecard (BSC) module, supporting versions 12.1.1 and 12.2.2. As a translation table (indicated by the '_TL' suffix), its primary role is to store multilingual descriptions for dimension groups. Dimension groups are logical collections of related dimensions used to categorize and analyze Key Performance Indicators (KPIs) within the Balanced Scorecard framework. This table enables the global deployment of the application by allowing dimension group names and descriptions to be presented in a user's preferred language, a critical feature for multinational organizations.

Key Information Stored

While the provided metadata does not list specific columns, the structure of a standard Oracle EBS translation table can be inferred. The table's primary key is DIM_GROUP_ID. This column stores the unique identifier for a dimension group, linking each record to its corresponding base data. A critical column is LANGUAGE, which holds the ISO language code (e.g., 'US' for American English, 'KO' for Korean) to identify the translation. The SOURCE_LANG column typically indicates the original language of the translatable data. The core content columns are user-facing textual attributes, most commonly NAME and DESCRIPTION, which store the translated label and explanatory text for the dimension group, respectively. Additional columns like CREATION_DATE and LAST_UPDATE_DATE are standard for tracking data maintenance.

Common Use Cases and Queries

The primary use case is retrieving dimension group information in a user's session language for display in the BSC application's user interface, reports, and analytics. A common query pattern involves joining this translation table to its base table (typically BSC_SYS_DIM_GROUPS_B) to fetch the current language's description. For example, to list all dimension group names for a session, a query would filter on the LANGUAGE column using the user's session context. Data maintenance scripts for implementing new languages or correcting translations would target this table. Reporting queries often join through this table to ensure KPI analysis reports display dimension group labels correctly for international user bases.

Related Objects

As documented in the provided metadata, BSC_SYS_DIM_GROUPS_TL is centrally linked to several key Balanced Scorecard tables via its primary key, DIM_GROUP_ID.

• BSC_KPI_DIM_GROUPS: This table references BSC_SYS_DIM_GROUPS_TL.DIM_GROUP_ID via its own DIM_GROUP_ID column. This relationship associates specific Key Performance Indicators with the categorized dimension groups for analysis.
• BSC_SYS_DIM_LEVELS_BY_GROUP: This table also references BSC_SYS_DIM_GROUPS_TL.DIM_GROUP_ID via its DIM_GROUP_ID column. This relationship defines which specific dimension levels are included within a given dimension group.

These foreign key relationships confirm that BSC_SYS_DIM_GROUPS_TL is a master reference table for translated dimension group data, which is then utilized to organize both KPIs and the hierarchical levels of dimensions within the scorecarding system.