Results for “analysis_option2”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

BSC_KPI_SUBTITLES_TL is a translation (TL) table in the Oracle EBS Balanced Scorecard (BSC) module, versioned for 12.1.1 and 12.2.2. It stores language-specific subtitle information for Key Performance Indicators (KPIs), which are referred to as "indicators" throughout the BSC schema. Each row represents a translated subtitle value associated with a specific indicator, a calculation combination, a set of analysis option dimensions, and a language code. The physical schema documented in ETRM contains eight columns, and the object is owned by the BSC schema with a status of VALID.

Because the table carries localized descriptive text (SUBTITLE, SOURCE_LANG, LANGUAGE) tied to a parent indicator defined in BSC_KPIS_B, the heuristic Data Vault classification derived from the FK structure is satellite-leaning. This suggests the table is best modeled as a satellite surrounding the KPI hub, capturing language-dependent descriptive attributes rather than acting as a hub or link in its own right.

Key Information Stored

The eight documented columns capture a composite identifier, a foreign key, localization fields, and the subtitle itself:

• INDICATOR — Foreign key to BSC_KPIS_B, identifying the KPI that the subtitle describes.
• CALC_COMB — Part of the composite key, representing the calculation combination to which the subtitle applies.
• ANALYSIS_OPTION0, ANALYSIS_OPTION1, ANALYSIS_OPTION2 — Dimensional discriminators that further qualify which analysis view the subtitle belongs to.
• LANGUAGE — The language code for the translated subtitle.
• SOURCE_LANG — The source language from which the translation originated.
• SUBTITLE — The actual translated subtitle text, the primary payload of the table.

The composite primary key BSC_KPI_SUBTITLES_TL_PK spans ANALYSIS_OPTION0, ANALYSIS_OPTION1, CALC_COMB, LANGUAGE, INDICATOR, and ANALYSIS_OPTION2. A separate unique index, BSC_KPI_SUBTITLES_TL_U1, covers INDICATOR, CALC_COMB, ANALYSIS_OPTION0, ANALYSIS_OPTION1, ANALYSIS_OPTION2, and LANGUAGE, serving as a business-key candidate that enforces uniqueness of the localized subtitle per indicator configuration.

Common Use Cases and Queries

Typical usage centers on retrieving and joining localized subtitle text to a KPI definition. A common reporting pattern joins the translation table to BSC_KPIS_B on INDICATOR to present subtitles in the user's session language:

• Filtering by LANGUAGE to return only the subtitle in a target locale.
• Joining on INDICATOR to enrich KPI summary reports with localized subtitle descriptions.
• Filtering by CALC_COMB and the ANALYSIS_OPTION columns to isolate subtitles for a specific calculation and analysis configuration.
• Auditing translations by comparing SOURCE_LANG against LANGUAGE to identify rows pending localization.
• Verifying uniqueness of subtitles against the BSC_KPI_SUBTITLES_TL_U1 business key.

A representative query might select B.SUBTITLE, B.INDICATOR, and B.LANGUAGE from BSC_KPI_SUBTITLES_TL B where B.INDICATOR = :kpi_id and B.LANGUAGE = :lang, restricted further by CALC_COMB and the analysis options to resolve the correct subtitle row.

Related Objects

The most significant relationship documented is the foreign key from BSC_KPI_SUBTITLES_TL.INDICATOR to BSC_KPIS_B, the base KPI table. This parent-child link is the primary dependency and the join used when resolving subtitle text for a KPI. The composite unique index BSC_KPI_SUBTITLES_TL_U1 and the primary key BSC_KPI_SUBTITLES_TL_PK both enforce integrity across the indicator and its dimensional qualifiers. The analysis option and calculation combination columns imply functional dependencies on BSC analysis and calculation configuration objects, and the TL suffix indicates a corresponding base translation set. Together, these objects support localized presentation of Balanced Scorecard KPI subtitles.