Search Results user_level1




Overview
Explore in AI Chat

Overview

BSC_KPI_DIM_LEVEL_PROPERTIES is a configuration table within the Oracle E-Business Suite Balanced Scorecard (BSC) module, documented under the ETRM reference set for releases 12.1.1 and 12.2.2. The object stores per-level display and behavioral properties that govern how dimension levels are presented and applied when a Balanced Scorecard KPI is evaluated against a specific dimension set. In practical terms, it acts as the attribute-bearing intersection that binds a dimension level (BSC_SYS_DIM_LEVELS_B) to a KPI dimension set (BSC_KPI_DIM_SETS_TL), carrying the presentation and default-value semantics used by the scorecard rendering and calculation engines.

The documented product classification is BSC - Balanced Scorecard (Obsolete), and the ETRM implementation note records that the table is "Not implemented in this database." This indicates the object is retained for reference and upgrade-compatibility purposes but is not created in the target instance. The metadata carries a heuristic Data Vault classification of link, mined from its foreign key structure. Under that modeling suggestion, the table behaves primarily as a relationship construct connecting two independent business entities, with a small set of descriptive attributes attached. This classification should be treated as a convenience model rather than an Oracle-documented design intent.

Key Information Stored

The table is documented with thirteen columns and a composite primary key. The primary key constraint, BSC_KPI_DIM_LEVEL_PROPERTI_PK, spans DIM_LEVEL_ID, INDICATOR, and DIM_SET_ID, and is the object referenced by the search term "bsc_kpi_dim_level_properti_pk". A separate unique index, BSC_KPI_DIM_LEVEL_PROPERTI_U1, covers the same three columns in the order INDICATOR, DIM_SET_ID, DIM_LEVEL_ID, and serves as the business-key candidate.

  • DIM_LEVEL_ID — surrogate reference to the dimension level definition in BSC_SYS_DIM_LEVELS_B; part of both the primary key and the unique index.
  • DIM_SET_ID — reference to the KPI dimension set in BSC_KPI_DIM_SETS_TL; identifies the scorecard context in which the level properties apply.
  • INDICATOR — discriminator column distinguishing the property row flavor for a given level/set combination; part of the composite key.
  • POSITION — ordinal placement of the level within the dimension set, controlling display order.
  • TOTAL0 — flag governing whether the level participates in aggregation or total roll-up behavior.
  • LEVEL_DISPLAY — controls whether and how the level is rendered in the scorecard interface.
  • DEFAULT_KEY_VALUE — the default member or key applied when no explicit selection is supplied.
  • USER_LEVEL0, USER_LEVEL1, USER_LEVEL2 — level-specific user assignment or selection attributes for successive hierarchy tiers.
  • USER_LEVEL1_DEFAULT, USER_LEVEL2_DEFAULT — default settings paired with the corresponding user-level columns.
  • TARGET_LEVEL — designates the level used as the target basis within the set hierarchy.

The primary key guarantees uniqueness of a property row per level, indicator, and dimension set, while the alternate unique index reinforces the same business identity from a different column ordering to support alternate access paths.

Common Use Cases and Queries

Because the object is documented as not implemented, its principal uses are reference inspection, upgrade impact analysis, and historical data migration. A typical inspection query joins the level and set translations to resolve descriptive names:

  • Enumerate all property rows for a given dimension set: SELECT * FROM BSC_KPI_DIM_LEVEL_PROPERTIES WHERE DIM_SET_ID = :p_set_id ORDER BY POSITION;
  • Resolve display behavior by joining to level definitions on DIM_LEVEL_ID and to set translations on DIM_SET_ID.
  • Audit default-value configuration by filtering on DEFAULT_KEY_VALUE, USER_LEVEL1_DEFAULT, or USER_LEVEL2_DEFAULT.
  • Verify key integrity against BSC_KPI_DIM_LEVEL_PROPERTI_PK and BSC_KPI_DIM_LEVEL_PROPERTI_U1 before migrating rows into a supported construct.
  • Determine aggregation behavior by examining TOTAL0 and TARGET_LEVEL across the hierarchy defined by POSITION.

Related Objects

  • BSC_SYS_DIM_LEVELS_B — parent of DIM_LEVEL_ID; supplies the dimension level definitions that these properties decorate.
  • BSC_KPI_DIM_SETS_TL — parent of DIM_SET_ID; provides the translated dimension set names used in scorecard reporting.
  • BSC_KPI_DIM_LEVEL_PROPERTI_PK — the composite primary key constraint over DIM_LEVEL_ID, INDICATOR, DIM_SET_ID.
  • BSC_KPI_DIM_LEVEL_PROPERTI_U1 — unique index over INDICATOR, DIM_SET_ID, DIM_LEVEL_ID, acting as the business-key candidate.
  • BSC_SYS_DIM_LEVELS_TL — translated level names, joined via the level identifier for display reporting.
  • BSC_KPI_DIM_SETS_B — base definition of the KPI dimension sets referenced through DIM_SET_ID.

Together these objects form the dimensional scaffolding of the legacy Balanced Scorecard configuration, and any reconstruction or migration of BSC_KPI_DIM_LEVEL_PROPERTIES should preserve the documented key relationships to BSC_SYS_DIM_LEVELS_B and BSC_KPI_DIM_SETS_TL.