Search Results bsc_db_basic_dim_sets_v




Overview
Explore in AI Chat

Overview

The view BSC_DB_BASIC_DIM_SETS_V belongs to the Balanced Scorecard (BSC) product family within Oracle E-Business Suite, a module that Oracle has classified as obsolete in releases 12.1.1 and 12.2.2. Its documented purpose is to present a consolidated picture of dimension sets and datasets organized by analysis option. In the BSC data model, a KPI indicator can be sliced across up to three analysis options, arranged in analysis groups 0, 1, and 2. The view resolves which analysis option within each group is permitted to alter the dimension set, then joins that resolution back to the KPI analysis measures. This makes the view a bridge between the measure definitions stored on BSC_KPI_ANALYSIS_MEASURES_VL and the dimension set assignments held on BSC_KPI_ANALYSIS_OPTIONS_VL. Because the module is obsolete, ETRM documents the view but notes it is not implemented in the database, so it exists only as a documented artifact rather than an active reporting object in a standard 12.1.1 or 12.2.2 installation. Any reference to it should be treated as historical or upgrade-related context rather than a supported extension point.

Underlying Base Objects

ETRM does not document any base objects for this view under the referenced-objects section; however, the view text itself identifies the tables it draws from. These are BSC_KPI_ANALYSIS_MEASURES_VL, BSC_KPI_ANALYSIS_OPTIONS_VL, and BSC_KPI_ANALYSIS_GROUPS. The two _VL objects are variant views that expose translatable columns, while BSC_KPI_ANALYSIS_GROUPS holds the grouping and control attributes for analysis options. The view's internal subquery, aliased as OPT, unions three separate branches — one per analysis group (0, 1, and 2) — selecting only those options where CHANGE_DIM_SET equals 1. Options in groups 1 and 2 that carry a dependency flag are resolved to their parent or grandparent option IDs so that the correct dimension set can be traced through the hierarchy. The unioned result is then joined to BSC_KPI_ANALYSIS_MEASURES_VL on indicator and on the three analysis option columns, with a -1 sentinel allowing a group to match any option when no specific restriction applies.

Key Columns

The view exposes a compact set of columns that together describe which dimension set applies to a measure under a given option combination.

  • INDICATOR — the KPI indicator to which the measure, options, and dimension set belong; the primary join key across all branches.
  • A0, A1, A2 — the analysis option identifiers for analysis groups 0, 1, and 2 respectively. A value of -1 indicates a wildcard, meaning the group does not constrain the dimension set.
  • SERIES_ID — the series identifier from the measure definition, distinguishing multiple series within an indicator.
  • DIM_SET_ID — the dimension set associated with the qualifying analysis option, the central output of the view.
  • DATASET_ID — the dataset tied to the measure, allowing dimension sets and datasets to be reported together.

Common Use Cases and Queries

Documented usage centers on determining which dimension set governs an indicator's measures for a specific analysis option path. A representative query retrieves the indicator, option path, and dimension set for all measures:

  • SELECT indicator, a0, a1, a2, series_id, dim_set_id, dataset_id FROM bsc_db_basic_dim_sets_v WHERE indicator = :indicator_id;
  • SELECT indicator, dim_set_id, dataset_id FROM bsc_db_basic_dim_sets_v WHERE dim_set_id IS NOT NULL ORDER BY indicator;

Because the module is obsolete and the view is not implemented, these constructs are primarily useful for migration analysis, historical data review, or understanding the legacy dimension-set resolution logic during upgrades to later EBS releases.