Search Results merge_olap_object
Overview
BSC_AW_MD_WRAPPER is the metadata abstraction layer that Oracle E-Business Suite uses to manage the Oracle OLAP (Express/AWM) analytic workspace objects underlying the Balanced Scorecard (BSC) and Daily Business Intelligence (DBI) analytics infrastructure. Its primary responsibility is to insulate the Applications schema from the mechanics of creating, altering, and deleting OLAP metadata — dimensions, cubes, measures, and their relationships — by wrapping those operations in a controlled PL/SQL interface. The package stores and reconciles its state in the BSC_OLAP_OBJECT and BSC_OLAP_OBJECT_RELATION tables, and it treats those tables as a registry of analytic objects and their dependencies, including KPI-specific metadata.
The name and header comment indicate that the wrapper was authored against the OLAP AW (Analytic Workspace) metadata model and is registered as a "noship" internal component, confirming that it is an internal engine rather than a public product API. The header shows version 120.4 dated 2006/01/14, which is consistent with the BSC/DBI generation shipped in the 12.0.x–12.1.1 timeframe and carried forward into 12.2.x.
Key Procedures and Functions
- SET_CONTEXT / DEFAULT_CONTEXT_IF_NULL — Establish and normalize the runtime context (for example AW versus MODEL) so that subsequent operations target the correct metadata ownership scope.
- CREATE_DIM / DROP_DIM — Create and remove OLAP dimension definitions from the analytic workspace based on a dimension record definition.
- CREATE_CALENDAR — Establish the calendar object used by time-based analytics.
- CREATE_KPI (the searched object) — Create a KPI definition and its associated metadata so that the KPI can be evaluated against the OLAP workspace. This is the entry point most commonly referenced when users search for "create_kpi."
- DROP_KPI / MARK_KPI_RECREATE — Remove a KPI, or flag it for recreation (for example after a dimension or measure change invalidates it).
- CREATE_WORKSPACE / DROP_WORKSPACE — Provision and tear down the analytic workspace itself.
- GET_BSC_OLAP_OBJECT / GET_BSC_OLAP_OBJECT_RELATION — Retrieve registry rows and their relationships for inspection and dependency processing.
- INSERT_OLAP_OBJECT / INSERT_OLAP_OBJECT_RELATION / UPDATE_OLAP_OBJECT / UPDATE_OLAP_OBJECT_RELATION / MERGE_OLAP_OBJECT / MERGE_OLAP_OBJECT_RELATION / DELETE_OLAP_OBJECT / DELETE_OLAP_OBJECT_RELATION — The persistence layer that keeps the registry synchronized with the physical workspace objects.
Tables Accessed
The package reads and writes the documented registry tables BSC_OLAP_OBJECT and BSC_OLAP_OBJECT_RELATION through APPS synonyms. BSC_OLAP_OBJECT holds the object identity and type information (object, object_type, parent_object, parent_object_type) and also carries runtime properties such as load start/end times and lock indicators in its property columns. BSC_OLAP_OBJECT_RELATION stores the parent-child and dependency relationships between dimensions, cubes, and KPIs. The package also relies on DBMS_SQL for dynamic DDL/DML against the workspace and on PLITBLM for PL/SQL table operations; the declared collection types (bsc_olap_object_tb, bsc_olap_object_relation_tb, bsc_runtime_tb) support this bulk metadata handling.
Usage Notes
Because it is an internal ("noship") wrapper, BSC_AW_MD_WRAPPER is invoked indirectly by the BSC/DBI load, aggregation, and workspace-maintenance programs rather than directly by end users. It is referenced by 11 other packages, reflecting its role as a shared dependency for KPI and workspace construction. The mark_kpi_recreate routine is typically called when an underlying dimension or measure changes, flagging affected KPIs for regeneration on the next run. In 12.1.1 and 12.2.2, custom code should not call create_kpi or the OLAP mutators directly; use the supported DBI/BSC administrative concurrent programs, which call this wrapper on your behalf. Direct invocation risks leaving the BSC_OLAP_OBJECT registry inconsistent with the physical analytic workspace, requiring full regeneration of the affected objects.