Search Results bsc_sys_datasets_vl




Overview
Explore in AI Chat

Overview

BSC_SYS_DATASETS_VL is a translated (VL, "view with language") view belonging to the Balanced Scorecard (BSC) product family in Oracle E-Business Suite. Balanced Scorecard was delivered as part of the Oracle Enterprise Planning and Budgeting / Strategic Enterprise Management stack integrated with EBS, and is now classified as Obsolete in the ETRM 12.2.2 metadata. The view exposes dataset definitions used by the Balanced Scorecard charting and analytics engine — each dataset describes a measurable series, the arithmetic or comparison operation applied to two measures, and the presentation attributes (format, color method, axis title, autoscaling) used when rendering scorecard graphics.

Functionally, the view joins the base table that stores language-independent dataset attributes with the translation table that stores the user-facing name and help text. By resolving the translation row using USERENV('LANG'), the view automatically returns NAME and HELP in the session's current language, which is the standard Oracle EBS multi-language reporting pattern. The view is read-only and is intended for query and reporting consumption rather than for direct DML; inserts and updates must target the underlying _B and _TL tables.

Underlying Base Objects

The ETRM documentation identifies two referenced base objects, both documented in the view text:

The join is an equijoin on DATASET_ID, filtered by TL.LANGUAGE = USERENV('LANG'). Columns that may be null in the base table — EDW_FLAG and AUTOSCALE_FLAG — are wrapped in NVL(..., 0) so that consumers always receive a numeric 0/1 flag rather than a null. No additional documented base objects (for example, a measures or formats lookup table) are referenced in the documented view definition, so the view itself is a straightforward two-table join.

Key Columns

  • DATASET_ID — Primary identifier linking the base and translation rows; the key used when joining to scorecard measure or chart definitions.
  • NAME — Translated dataset label presented to end users in the current session language.
  • HELP — Translated descriptive text displayed as online help for the dataset.
  • MEASURE_ID1 / MEASURE_ID2 — Identifiers of the primary and secondary measures combined by the dataset.
  • OPERATION — The arithmetic or comparison operator applied between the two measures.
  • FORMAT_ID — Reference to the numeric display format applied to the resulting value.
  • COLOR_METHOD — Determines how color is assigned when the dataset is rendered.
  • PROJECTION_FLAG — Indicates whether the dataset is used as a projection series.
  • EDW_FLAG — Enterprise Data Warehouse flag, normalized to 0 when null.
  • AUTOSCALE_FLAG — Autoscale indicator, normalized to 0 when null.
  • Y_AXIS_TITLE — Translated title applied to the Y axis of the associated chart.
  • SOURCE — Identifies the origin or sourcing designation of the dataset.

Common Use Cases and Queries

Because the view is marked "Not implemented in this database" and the product is obsolete, it is primarily encountered during migration assessments, custom reporting against legacy BSC schemas, or data extraction prior to decommissioning. Typical queries list datasets with their measures and operations, or isolate autoscaled/EDW-enabled series:

  • List all datasets in the session language: SELECT DATASET_ID, NAME, HELP, OPERATION FROM BSC_SYS_DATASETS_VL ORDER BY DATASET_ID;
  • Find autoscaled datasets: SELECT DATASET_ID, NAME FROM BSC_SYS_DATASETS_VL WHERE AUTOSCALE_FLAG = 1;
  • Isolate EDW-sourced datasets: SELECT DATASET_ID, NAME, SOURCE FROM BSC_SYS_DATASETS_VL WHERE EDW_FLAG = 1;
  • Inspect measure pairings and axis titles: SELECT DATASET_ID, MEASURE_ID1, MEASURE_ID2, OPERATION, Y_AXIS_TITLE FROM BSC_SYS_DATASETS_VL;

Always qualify queries with the appropriate language context, since returning rows depends on USERENV('LANG') matching a populated BSC_SYS_DATASETS_TL.LANGUAGE value.