Search Results bsc_sys_measures

Overview

The BSC_SYS_MEASURES table is a core data repository within the Oracle E-Business Suite Balanced Scorecard (BSC) application. It serves as the master definition table for all measures used in the strategic performance management framework. A measure is a quantifiable metric, such as "Customer Satisfaction Index" or "Quarterly Revenue Growth," that organizations track to monitor progress against strategic objectives. This table's primary role is to store the fundamental metadata and configuration for every measure, enabling the system to calculate, aggregate, and report on performance data across perspectives, objectives, and initiatives. Its integrity is critical for the entire Balanced Scorecard module, as it is referenced extensively by other components that define datasets, scorecards, and reports.

Key Information Stored

While the provided ETRM excerpt does not list individual columns, the table's primary key is documented as MEASURE_ID. Based on its role as a master definition table, it typically stores descriptive and configuration attributes for each measure. Common columns in such a structure would include a unique numeric or alphanumeric MEASURE_ID, a MEASURE_CODE or SHORT_NAME, a descriptive MEASURE_NAME, and fields defining the measure's data type, aggregation rules (e.g., sum, average), display format, and status. It may also contain columns linking to the source of the data, such as a database view or function, and parameters controlling its calculation frequency and historical data retention.

Common Use Cases and Queries

This table is central to administrative setup and reporting within the Balanced Scorecard. Common use cases include generating a master list of all available measures for configuration purposes, auditing measure definitions, and troubleshooting data calculation issues. A typical query would retrieve active measures for integration or data loading processes. For example, a report listing all measure definitions might use a SQL pattern such as: SELECT measure_id, measure_code, measure_name, data_type, aggregation_method FROM bsc_sys_measures WHERE status = 'ACTIVE' ORDER BY measure_code;. Developers or administrators might also query this table to understand the metadata of a specific measure before investigating related performance data in transactional tables.

Related Objects

The BSC_SYS_MEASURES table has documented foreign key relationships with other core Balanced Scorecard tables, primarily through its primary key column, MEASURE_ID. According to the provided metadata, it is referenced by the BSC_SYS_DATASETS_B table in two distinct columns:

• BSC_SYS_DATASETS_B.MEASURE_ID1: This foreign key links a dataset definition to a primary measure.
• BSC_SYS_DATASETS_B.MEASURE_ID2: This foreign key links a dataset definition to a secondary or comparative measure, often used for calculations like variance or growth.

These relationships indicate that a single measure defined in BSC_SYS_MEASURES can be used in multiple datasets. The BSC_SYS_DATASETS_B table itself is pivotal, as datasets are the structures that hold the actual performance data values for measures over time, for specific scorecards and perspectives.