Results for “bsc_kpi_dim_levels_user”

21 results




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

Overview

BSC_KPI_DIM_LEVELS_USER is a transactional configuration table in the Balanced Scorecard (BSC) module of Oracle E-Business Suite, owned by the BSC schema. It stores user-specific dimension level information, allowing individual users to personalize how dimension hierarchies are displayed or selected when building and viewing KPI scorecards. In Oracle EBS 12.1.1 and 12.2.2, this table operates alongside the base dimension level definition table BSC_KPI_DIM_LEVELS_B, extending the shared definition with per-user attributes.

From a Data Vault modeling perspective, the metadata's foreign key structure suggests this object behaves as a link table. It connects a user (via USER_ID to BSC_USERS) to a dimension level definition (via DIM_LEVEL_INDEX, DIM_SET_ID, and INDICATOR to BSC_KPI_DIM_LEVELS_B), with additional descriptive columns carried on the relationship. This classification is a heuristic mined from the FK topology and should be treated as a modeling suggestion rather than a documented architectural fact.

Key Information Stored

The table contains ten documented columns. The primary key, BSC_KPI_DIM_LEVELS_USER_PK, is a composite surrogate key spanning DIM_LEVEL_INDEX, DIM_SET_ID, INDICATOR, and USER_ID. A unique index, BSC_KPI_DIM_LEVELS_USER_U1, covers the same four columns in the order USER_ID, INDICATOR, DIM_SET_ID, DIM_LEVEL_INDEX, confirming that these four attributes constitute the business key of the record.

  • USER_ID — Foreign key to BSC_USERS; identifies the user to whom the dimension level configuration applies.
  • INDICATOR — Part of the composite key and FK to BSC_KPI_DIM_LEVELS_B; distinguishes the dimension level record within the parent definition.
  • DIM_SET_ID — Part of the composite key and FK to BSC_KPI_DIM_LEVELS_B; identifies the dimension set to which the level belongs.
  • DIM_LEVEL_INDEX — Part of the composite key and FK to BSC_KPI_DIM_LEVELS_B; specifies the ordinal position of the level within the dimension hierarchy.
  • DISPLAY_FLAG — Controls whether the corresponding dimension level is displayed for the user, enabling personalized visibility.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard Oracle EBS audit columns recording who created and last modified the row, when, and from which login session.

Common Use Cases and Queries

Typical scenarios include reporting on which dimension levels a user has enabled or disabled, auditing personalization changes across the user base, and diagnosing why a particular user does not see expected dimension levels in a scorecard. A common query joins the user table to resolve the user name:

  • SELECT u.user_name, l.dim_set_id, l.indicator, l.dim_level_index, l.display_flag FROM bsc.bsc_kpi_dim_levels_user l, bsc.bsc_users u WHERE l.user_id = u.user_id ORDER BY u.user_name, l.dim_set_id;
  • Filter by DISPLAY_FLAG = 'Y' to retrieve only active dimension level personalizations for a given USER_ID.
  • Join to BSC_KPI_DIM_LEVELS_B on DIM_SET_ID, INDICATOR, and DIM_LEVEL_INDEX to compare user-specific overrides against the base definition.

Because the table is keyed on USER_ID, reports are frequently scoped to a single user or aggregated by user to detect configuration drift.

Related Objects

The most significant related objects are those referenced by the documented foreign keys, plus the base definition table that supplies shared dimension level metadata.

  • BSC_USERS — Referenced via USER_ID; the parent user record for each personalization row.
  • BSC_KPI_DIM_LEVELS_B — Referenced via DIM_LEVEL_INDEX, INDICATOR, and DIM_SET_ID; the base dimension level definition that this table personalizes per user.
  • BSC_KPI_DIM_LEVELS_USER_PK — The primary key constraint enforcing uniqueness of the composite key.
  • BSC_KPI_DIM_LEVELS_USER_U1 — The unique index on USER_ID, INDICATOR, DIM_SET_ID, and DIM_LEVEL_INDEX, confirming the business key.
  • Associated BSC scorecard and KPI definition tables that consume dimension level settings when rendering scorecards, though not directly referenced by foreign keys documented here.

Oracle Proprietary, Confidential Information — Legal Notices apply.