Search Results get_kpi_calendar
Overview
APPS.BSC_METADATA is a PL/SQL package in the Oracle E-Business Suite Balanced Scorecard (BSC) module, part of the Oracle Business Intelligence foundation shipped with EBS 12.1.1 and 12.2.2. The package maintains and exposes the structural metadata that describes the Balanced Scorecard data model: KPI definitions, dimension hierarchies, dimension levels, calendars, and the underlying database views and base tables that supply scorecard values. It functions as a metadata access layer that other BSC runtime packages call to translate an abstract scorecard definition into physical SQL constructs, level relationships, and data sources.
The package is classified as OTHER in the ETRM repository and is owned by the APPS schema. It is referenced by BSC_AW_ADAPTER, BSC_AW_BSC_METADATA, BSC_AW_CALENDAR, BSC_AW_READ, and BSC_AW_UTILITY, and it depends on BSC_AW_ADAPTER_DIM, BSC_AW_UTILITY, DBMS_SQL, and the STANDARD package. Because BSC_AW_UTILITY appears both as a dependency and as a dependent, the two packages form a mutually referencing pair within the scorecard aggregation and refresh framework; this is why the user query for "bsc_aw_utility" surfaces BSC_METADATA documentation.
Key Procedures and Functions
ETRM documents 42 procedures and functions in BSC_METADATA. The documented set falls into several functional groups:
- Hierarchy and level navigation: GET_PARENT_LEVEL, GET_CHILD_LEVEL, GET_LEVEL_PK, and IS_TARGET_AT_HIGHER_LEVEL resolve the parent/child relationships between dimension levels and determine whether a target has been defined at a higher aggregation level than a given KPI.
- KPI-to-dimension mapping: GET_KPI_FOR_DIM, GET_DIMS_FOR_KPIS, GET_KPI_FOR_CALENDAR, GET_KPI_CALENDAR, and GET_KPI_DIM_SETS return the dimensions, dimension sets, and calendars associated with one or more KPIs.
- Dimension set metadata: GET_DIM_SET_DIMS and GET_DIM_SET_MEASURES return the dimensions and measures that compose a dimension set.
- Data source resolution: GET_DIM_DATA_SOURCE and GET_DENORM_DATA_SOURCE identify the physical source for dimension and denormalized fact data, while GET_S_VIEWS, GET_S_VIEW_LEVELS, and GET_BASE_TABLE_LEVELS expose the scorecard views and their mapped base tables and levels.
- Level properties and filters: GET_DIM_LEVEL_PROPERTIES, GET_DIM_LEVEL_FILTER, GET_TARGET_LEVELS, and IS_DIM_RECURSIVE return level attributes, filter predicates, valid target levels, and recursion flags.
The exact parameter signatures are not enumerated in the available metadata; only the names and functional intent are documented.
Tables Accessed
The package references the APPS synonyms DBMS_SQL and PLITBLM. DBMS_SQL is used for dynamic SQL construction — necessary because scorecard queries are generated at runtime from metadata rather than being statically coded. PLITBLM provides the PL/SQL index-by table support used to pass collection data between the metadata layer and the aggregation packages. All primary scorecard metadata tables (KPI, dimension, level, calendar, and view definitions) are reached through APPS synonyms and are normally accessed read-only by this package.
Usage Notes
BSC_METADATA is not an end-user API. It is invoked internally by the Balanced Scorecard runtime packages — BSC_AW_ADAPTER, BSC_AW_READ, BSC_AW_CALENDAR, and BSC_AW_UTILITY — during scorecard rendering, aggregation, and data refresh. Custom code that must resolve scorecard hierarchy or KPI metadata should call these documented functions rather than querying the underlying metadata tables directly, since the metadata model is internal and subject to change. No concurrent program or Oracle Form calls this package directly; it is a supporting library within the BSC execution stack.