Search Results bsc_sys_filters_views




Overview
Explore in AI Chat

Overview

The table BSC_SYS_FILTERS_VIEWS is a metadata repository within the Oracle E-Business Suite (EBS) Balanced Scorecard (BSC) module. Its primary role is to store configuration data that defines filter views, which are critical for segmenting and analyzing performance data across different organizational dimensions. This table functions as a core component for building customized analytical perspectives within the now-obsolete Balanced Scorecard application. It establishes a direct relationship between a specific dimension level and the underlying data source, enabling the system to apply dynamic filters to scorecard metrics and reports.

Key Information Stored

The table's structure centers on a composite primary key that uniquely identifies a filter view configuration. The key columns are DIM_LEVEL_ID, which links to a specific level within a performance dimension hierarchy; SOURCE_TYPE, which classifies the nature of the data source; and SOURCE_CODE, which is the specific identifier for that source. While the exact data types and additional descriptive columns are not detailed in the provided metadata, the table's purpose implies it would store information necessary for the application to construct the appropriate SQL or logic to filter data based on the selected dimension level and source context.

Common Use Cases and Queries

This table is queried by the BSC application engine to retrieve filter definitions during runtime when a user generates a scorecard or report. A typical use case involves a user selecting a specific perspective, such as "Sales by Region," prompting the application to query this table for the filter view associated with the "Region" dimension level. A fundamental query pattern would join this table to its parent dimension table to retrieve a usable filter definition. For example:

  • SELECT fv.* FROM BSC_SYS_FILTERS_VIEWS fv WHERE fv.DIM_LEVEL_ID = :p_dim_level_id AND fv.SOURCE_TYPE = :p_source_type;

Given the module's obsolete status, direct operational use is rare. However, technical consultants may query this table during data migration, system decommissioning, or to understand legacy report logic embedded within customizations.

Related Objects

The primary documented relationship for BSC_SYS_FILTERS_VIEWS is a foreign key dependency on the BSC_SYS_DIM_LEVELS_B table. This relationship is fundamental, as every filter view must be associated with a valid dimension level. The join is performed on the DIM_LEVEL_ID column. This link ensures referential integrity, meaning a filter view cannot exist for a dimension level that is not defined in the system. The BSC_SYS_DIM_LEVELS_B table contains the master definitions for all dimension levels used within the Balanced Scorecard, making it the parent entity in this relationship.