Search Results bsc_sys_dataset_calc_pk

Overview

The BSC_SYS_DATASET_CALC table is a core configuration table within the Oracle E-Business Suite Balanced Scorecard (BSC) module. Its primary function is to manage the selective disabling of specific calculations for defined datasets. In the context of the Balanced Scorecard, a dataset represents a collection of key performance indicators (KPIs) and data used for strategic performance management. This table provides a granular level of control, allowing administrators to exclude certain automated calculations from processing within a specific dataset, thereby tailoring the performance measurement logic to unique business requirements without altering the global calculation definitions.

Key Information Stored

The table acts as a junction or intersection entity, storing pairs of identifiers that define a disablement rule. Its structure is defined by a composite primary key. The two critical columns are DATASET_ID, which references a specific dataset from the BSC_SYS_DATASETS_B table, and DISABLED_CALC_ID, which references a particular calculation defined in the BSC_SYS_CALCULATIONS table. Each record in this table signifies that the calculation identified by DISABLED_CALC_ID is explicitly turned off for the dataset identified by DATASET_ID. The table does not store the calculation logic or dataset details itself; it solely maintains this relationship.

Common Use Cases and Queries

The primary use case is administrative configuration and troubleshooting of Balanced Scorecard calculation behavior. A system administrator may query this table to audit which calculations are disabled across the system or for a particular dataset. Common SQL patterns include identifying all disabled calculations for a given dataset name, or verifying if a specific calculation is disabled anywhere. For example, to list all disabled calculations for a dataset named 'Q4_FINANCIAL_SCORECARD', a query would join BSC_SYS_DATASET_CALC to BSC_SYS_DATASETS_B and BSC_SYS_CALCULATIONS. Conversely, during performance tuning or issue diagnosis, technical consultants might query this table to rule out disabled calculations as the cause for unexpected KPI values in a specific dataset report.

Related Objects

This table has defined dependencies on two other primary BSC configuration tables, enforced through foreign key constraints:

• BSC_SYS_DATASETS_B: The DATASET_ID column in BSC_SYS_DATASET_CALC references the primary key of this table, which stores the master list of all datasets.
• BSC_SYS_CALCULATIONS: The DISABLED_CALC_ID column in BSC_SYS_DATASET_CALC references the primary key of this table, which contains the definitions of all available system calculations.

The table's primary key constraint, BSC_SYS_DATASET_CALC_PK, ensures the uniqueness of each dataset and calculation ID combination, preventing duplicate disablement rules.