Search Results bsc_sys_datasets_b

Overview

The BSC_SYS_DATASETS_B table is a core data repository within the Oracle E-Business Suite Balanced Scorecard (BSC) module. It serves as the master definition table for datasets, which are fundamental constructs used for performance measurement and strategic analysis. A dataset typically represents a collection of related data points or measures that are used to calculate Key Performance Indicators (KPIs), populate scorecards, and enable analytical comparisons. The table's role is to store the structural and relational metadata for these datasets, forming a critical link between defined measures and their analytical consumption throughout the BSC application.

Key Information Stored

While the provided metadata does not list specific columns beyond foreign keys, the structure and relationships indicate the essential data elements stored. The primary key, DATASET_ID, uniquely identifies each dataset record. Crucially, the table stores references to the underlying measures that constitute the dataset through the MEASURE_ID1 and MEASURE_ID2 columns, which are foreign keys to the BSC_SYS_MEASURES table. This design suggests a dataset can be configured for comparative analysis between two measures (e.g., actual vs. target, current period vs. prior period). Other columns likely include descriptive attributes such as a dataset code or name, calculation flags, status, and creation metadata, which would be stored in the associated translation table, BSC_SYS_DATASETS_TL.

Common Use Cases and Queries

This table is primarily accessed during the configuration of Balanced Scorecard objects and the runtime generation of performance data. Common operational scenarios include the setup of a new KPI that requires a specific dataset for its analysis, or the troubleshooting of data discrepancies in a published scorecard. A typical query would join this table to its related measures and translation to retrieve a comprehensive dataset definition.

Sample Query:
SELECT ds.DATASET_ID, tl.NAME, m1.MEASURE_CODE AS MEASURE_1, m2.MEASURE_CODE AS MEASURE_2
FROM BSC_SYS_DATASETS_B ds
JOIN BSC_SYS_DATASETS_TL tl ON ds.DATASET_ID = tl.DATASET_ID AND tl.LANGUAGE = USERENV('LANG')
LEFT JOIN BSC_SYS_MEASURES m1 ON ds.MEASURE_ID1 = m1.MEASURE_ID
LEFT JOIN BSC_SYS_MEASURES m2 ON ds.MEASURE_ID2 = m2.MEASURE_ID
WHERE ds.DATASET_ID = :p_dataset_id;

Related Objects

The BSC_SYS_DATASETS_B table is central to a network of related objects within the BSC schema, as documented by its foreign key relationships.

• Referenced Tables (Outgoing Foreign Keys): The table references BSC_SYS_MEASURES twice, via MEASURE_ID1 and MEASURE_ID2, to define the core components of the dataset.
• Dependent Tables (Incoming Foreign Keys):
  • BSC_KPI_ANALYSIS_MEASURES_B: Links KPIs to the specific datasets used for their analysis via DATASET_ID.
  • BSC_SYS_DATASETS_TL: The translation table that holds the language-specific names and descriptions for the dataset, joined on DATASET_ID.
  • BSC_SYS_DATASET_CALC: Likely stores calculation rules, parameters, or runtime results for the dataset, linked by DATASET_ID.