Search Results get_filter_view_name

Overview

BSC_DIM_FILTERS_PUB is a public PL/SQL package owned by the APPS schema within the Oracle E-Business Suite environment. It forms part of the Oracle Balanced Scorecard (BSC) module, which delivers performance management and analytics capabilities. The package encapsulates the business logic responsible for managing dimension filters that govern how key performance indicators (KPIs) are aggregated, displayed, and constrained within scorecard definitions. In ETRM 12.1.1 and 12.2.2, the package is classified as a public API (PUB), indicating that its procedures are intended for invocation by other application modules, integration points, and potentially by custom extensions that must interact with dimension filtering functionality.

Key Procedures and Functions

The documented interface exposes seven procedures and functions. Each addresses a specific aspect of dimension filter lifecycle management:

• CHECK_FILTERS_NOT_APPLY — Validates whether filters have not been applied, providing a verification mechanism before certain operations proceed.
• CHECK_FILTERS_NOT_APPLY_BY_KPI — Performs the same validation but scoped specifically to a given KPI, allowing KPI-level filter applicability checks.
• DROP_FILTER — Removes a dimension filter definition from the system.
• SYNCH_FITERS_AND_KPI_DIM — Synchronizes filters with KPI dimension definitions, ensuring consistency between filter configurations and their associated dimensional structures.
• DROP_FILTER_BY_DIM_OBJ — Drops filters associated with a specific dimension object.
• DROP_FILTER_BY_TAB — Drops filters associated with a specific table indicator or tab context.
• GET_FILTER_VIEW_NAME — Retrieves the name of the database view associated with a filter, supporting dynamic SQL generation and view resolution.

The procedures collectively support creation, validation, synchronization, and removal of the filter constructs that connect KPIs to their dimensional data.

Tables Accessed

The package reads from and writes to several core Balanced Scorecard tables through APPS synonyms:

• BSC_KPIS_B — The base KPI definition table, referenced during filter validation and synchronization operations.
• BSC_SYS_DIM_LEVELS_B — Stores system dimension level definitions, used to resolve dimensional hierarchy context for filters.
• BSC_KPI_DIM_LEVELS_B — Links KPIs to dimension levels, accessed during synchronization of filters and KPI dimensions.
• BSC_SYS_FILTERS_VIEWS — Stores the mapping between filters and their generated database views, accessed by GET_FILTER_VIEW_NAME.
• BSC_TAB_INDICATORS — Holds tab indicator definitions, referenced during filter removal by tab context.

Usage Notes

BSC_DIM_FILTERS_PUB is referenced by seven other packages, including BSC_BIS_DIMENSION_PUB, BSC_BIS_DIM_REL_PUB, BSC_BIS_KPI_MEAS_PUB, BSC_DIMENSION_LEVELS_PVT, BSC_DIMENSION_SETS_PUB, BSC_DIM_FILTERS_PVT, and BSC_PMF_UI_WRAPPER. The dependency on BSC_PMF_UI_WRAPPER indicates that the package is invoked from the Balanced Scorecard user interface layer, making it a runtime participant in scorecard configuration performed through the application forms. The PVT (private) companion package BSC_DIM_FILTERS_PVT performs lower-level operations, while this public package provides the supported entry points. Custom code should call procedures in BSC_DIM_FILTERS_PUB rather than accessing the underlying tables directly, ensuring that synchronization logic and view management remain consistent. Typical invocation scenarios include scorecard setup during implementation, KPI reconfiguration by administrators, and cleanup operations when dimensional structures are modified or retired.