Results for “aw_cube_create_access”
3 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The OLAPSYS.CWM2_OLAP_OLAPAPI_ENABLE package body is part of the Oracle OLAP metadata infrastructure bundled with the database tier of Oracle E-Business Suite 12.1.1 and 12.2.2. It belongs to the OLAPSYS schema, the repository owner for OLAP Analytic Workspace (AW) metadata and the CWM2 (Common Warehouse Metamodel) API used to manipulate OLAP objects. Its purpose is to expose and manage the accessibility of OLAP Analytic Workspaces — specifically cubes and dimensions — so that they become available to the OLAP API and the BI query layer. In an EBS context, this package forms part of the mechanism by which analytic content referenced from EBS reporting is enabled, viewed, and subsequently disabled when no longer required.
The object is a wrapped package body; the source is stored in obfuscated form and is not intended for direct modification. The ETRM registry classifies the API as OTHER, indicating it is an internal database-supplied utility rather than a supported EBS application API.
Key Procedures and Functions
The package exposes a set of procedures oriented around enabling, disabling, and refreshing access definitions for AW cubes and dimensions. Documented members include:
- AW_DIMENSION_CREATE_ACCESS — creates the access definition that makes an analytic workspace dimension visible to the OLAP API layer.
- AW_CUBE_CREATE_ACCESS — performs the equivalent access creation for cubes.
- AW_DIMENSION_DROP_ACCESS — removes the access definition for a previously enabled dimension.
- AW_CUBE_DROP_ACCESS — removes the access definition for a previously enabled cube.
- UPDATE_ENABLED_DIM_VIEW — refreshes or maintains the view definition associated with an enabled dimension.
- UPDATE_ENABLED_CUBE_VIEW — refreshes or maintains the corresponding view for an enabled cube.
The remaining documented members (10 procedures/functions in total) follow the same enable/disable/view-maintenance pattern. Parameter lists are intentionally omitted here; the wrapped body does not expose them for reference.
Tables Accessed
The package reads and writes the OLAP2 data dictionary views, referenced through APPS synonyms:
- ALL_OLAP2_AW_CUBES — the catalog of cubes defined within analytic workspaces; used to resolve cube identity and enablement state.
- ALL_OLAP2_AW_DIMENSIONS — the catalog of dimensions; used to resolve dimension identity and enablement state.
Supporting database packages invoked include DBMS_AW (Analytic Workspace operations), DBMS_ASSERT (name validation for SQL injection resistance), DBMS_LOB (large object manipulation of generated view text), UTL_FILE (file I/O for generated scripts or logs), and PLITBLM (associative array utilities). These confirm that the package generates and validates dynamic DDL/views rather than merely querying metadata.
Usage Notes
This package is invoked indirectly rather than directly by end users. It is referenced by one other package, and is typically triggered when OLAP analytic workspaces are deployed, refreshed, or retired — for example, during OLAP AW build routines or Analytic Workspace Manager operations against the database. Within EBS, enabling a cube or dimension exposes it to the OLAP API so that downstream BI queries can resolve it; dropping access removes it from the queryable set.
Because the body is wrapped and owned by OLAPSYS, customization is not supported. The ETRM record should be treated as reference documentation only; direct invocation from custom EBS code is discouraged, and any dependency should be validated against the specific EBS patch level, since OLAP component versions vary between 12.1.1 and 12.2.2.