Search Results get_bsc_olap_object_relation

Overview

APPS.BSC_AW_MD_API is a PL/SQL package body belonging to the Oracle E-Business Suite Balanced Scorecard (BSC) product family. Its primary business function is to manage the metadata that defines the OLAP (Online Analytical Processing) analytics workspace (AW) objects—dimensions, KPIs, calendars, and their interrelationships—used by the Balanced Scorecard analytics engine. The package acts as a server-side API layer that shields callers from the lower-level implementation encapsulated in BSC_AW_MD_WRAPPER, exposing a stable interface for creating, querying, dropping, and rebuilding multidimensional database objects.

The header identifier (BSCAWMAB.pls 120.22) and version history confirm this is a long-lived, shipped component. In Oracle EBS 12.1.1 and 12.2.2, this package is classified as an API and is referenced by 13 other packages, underscoring its role as a foundational dependency for the analytics metadata subsystem.

Key Procedures and Functions

The package exposes 65 documented procedures and functions. The most commonly referenced operations include:

• IS_DIM_PRESENT — Boolean function that determines whether a given dimension is present in the OLAP repository by delegating to GET_BSC_OLAP_OBJECT.
• GET_KPI_FOR_DIM — Returns the list of KPIs associated with a named dimension, populating a DBMS_SQL.VARCHAR2_TABLE.
• GET_DIM_OLAP_OBJECTS — Returns the OLAP object names that must be dropped from the AW for a given dimension, optionally filtered by object type.
• GET_BSC_OLAP_OBJECT / GET_BSC_OLAP_OBJECT_RELATION — Core retrieval routines that read object definitions and object-to-object relationships from the BSC metadata tables into package globals.
• DROP_DIM / DROP_KPI — Delete dimensions or KPIs from the analytics workspace, clearing caches before and after the wrapper call.
• CREATE_DIM_OBJECTS / CREATE_KPI / CREATE_CALENDAR — Construct the corresponding OLAP artifacts.
• MARK_KPI_RECREATE — Flags a KPI for regeneration, delegating to the wrapper.
• GET_CCDIM_FOR_LEVELS, GET_LEVEL_POSITION, GET_DIM_FOR_LEVEL, GET_DIM_PARENT_CHILD, GET_DIM_FOR_KPI, GET_DIM_PROPERTIES, GET_DIM_SET_CALENDAR, DELETE_CALENDAR — Supporting accessors and mutators for dimension hierarchies, level positions, properties, and calendar assignment.

All routines wrap their bodies in exception handlers that log via LOG_N and re-raise, preserving error propagation to the caller.

Tables Accessed

The package operates against the following underlying objects, accessed through APPS synonyms:

• BSC_OLAP_OBJECT — Stores the definitions of OLAP objects (dimensions, KPIs, and related constructs). Read primarily by GET_BSC_OLAP_OBJECT.
• BSC_OLAP_OBJECT_RELATION — Stores the relationships between OLAP objects, such as the dimension-to-KPI mapping or parent-child hierarchies. Read by GET_BSC_OLAP_OBJECT_RELATION.
• DBMS_SQL — Used indirectly via the DBMS_SQL.VARCHAR2_TABLE PL/SQL type for list output parameters.
• PLITBLM — Referenced as a supporting table.

Usage Notes

BSC_AW_MD_API is invoked from within the Balanced Scorecard analytics metadata framework, typically by other BSC packages (13 documented referrers), concurrent programs responsible for building or refreshing the OLAP AW, and occasionally by custom extensions that need to query dimension/KPI metadata. It is not an end-user-facing form API; forms generally interact with higher-level Balanced Scorecard administrative screens that call these routines indirectly. Developers integrating custom code should rely on the public procedures and avoid the g_olap_object and g_olap_object_relation package globals, which are stateful caches cleared on each invocation.