Search Results bsc_sys_datasets_b_n1

Overview

The BSC_SYS_DATASETS_B table is a core repository within the Oracle E-Business Suite (EBS) Balanced Scorecard (BSC) application, versions 12.1.1 and 12.2.2. It functions as a system-level definition table for datasets, which are fundamental constructs for performance measurement and analytics. A dataset defines how a specific business measure, or a calculated combination of measures, is presented graphically or reported within the BSC framework. This table stores the configuration that links raw measure data to its visual representation, controlling aspects like calculation, formatting, color-coding, and projection behavior for scorecards and strategy maps.

Key Information Stored

The table's columns define the dataset's composition and display properties. The primary identifier, DATASET_ID, uniquely references each dataset configuration. The core logic is defined by MEASURE_ID1, OPERATION, and MEASURE_ID2, which allow a dataset to represent either a single measure (where MEASURE_ID2 may be null) or a calculated measure (e.g., MEASURE_ID1 / MEASURE_ID2). The FORMAT_ID links to formatting rules, while COLOR_METHOD and PROJECTION_FLAG control visual rendering and forecasting features. Key control flags include EDW_FLAG, which denotes if the dataset sources from the Enterprise Data Warehouse, and AUTOSCALE_FLAG for graph axis scaling. The table also includes standard "Who" columns (CREATED_BY, CREATION_DATE, etc.) for auditing.

Common Use Cases and Queries

This table is central to troubleshooting and analyzing BSC performance metrics. A common use case is investigating the definition of a specific measure's graphical representation. Given the user's search for "measure_id1", a typical query would identify all datasets based on a particular measure, which is supported by the non-unique index BSC_SYS_DATASETS_B_N1 on that column.

Sample Query: Find datasets using a specific measure.

• SELECT dataset_id, operation, measure_id2, format_id FROM bsc.bsc_sys_datasets_b WHERE measure_id1 = <measure_id_value>;

Sample Query: List all calculated datasets.

• SELECT dataset_id, measure_id1, operation, measure_id2 FROM bsc.bsc_sys_datasets_b WHERE measure_id2 IS NOT NULL AND operation IS NOT NULL;

These queries are essential for impact analysis before modifying a measure or for auditing dataset configurations during report development.

Related Objects

As per the dependency information, the BSC_SYS_DATASETS_B table is a referenced object, indicating it is a parent table in the data model. It is primarily referenced by other BSC application objects, likely including user interface views, transactional tables that store instance-specific dataset data, and possibly the BSC_SYS_DATASETS_TL table for translated names. The presence of indexes on DATASET_ID (unique), MEASURE_ID1, MEASURE_ID2, and FORMAT_ID confirms its relationships with other entities in the schema, such as measure master (BSC_SYS_MEASURES_B) and format definition tables. Direct queries or modifications should consider these referential integrity constraints.