Results for “dbms_awm”
36 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
OLAPSYS.DBMS_AWM is the Oracle-supplied PL/SQL package that implements the Analytic Workspace (AW) Metadata maintenance layer used by Oracle OLAP. Although owned by the OLAPSYS schema, the package is exposed to Oracle E-Business Suite through a public synonym and grants so that EBS forms, concurrent programs, and custom code running under the APPS schema can manipulate OLAP metadata definitions. The package name expands to "DBMS Analytic Workspace Metadata" and its responsibilities span the creation, alteration, and deletion of dimension load specifications (AWDimLoad), cube load specifications (AWCubeLoad), and cube aggregation specifications (AWCubeAgg). Each specification is a declarative description of how source relational data should be mapped into an analytic workspace dimension, cube, or aggregation, and DBMS_AWM provides the DDL-like primitives used to persist those descriptions in the OLAP 2 catalog.
In EBS 12.1.1 and 12.2.2 the package is most visible where Oracle OLAP has been configured as the reporting engine behind EBS business intelligence or DBI (Daily Business Intelligence) deployments. It is not part of the core transactional EBS call flow; rather it sits in the analytical maintenance tier. The package declares authid current_user, so it executes with the privileges of the calling schema, normally APPS, and all object references resolve through APPS synonyms such as ALL_OLAP2_AW_DIMENSIONS and ALL_OLAP2_AW_CUBES.
Key Procedures and Functions
The documented API set of 71 procedures is organized into three functional groups.
- AWDimLoad specification maintenance: CREATE_AWDimLoad_SPEC and DELETE_AWDimLoad_SPEC establish and remove a dimension load specification. SET_AWDimLoad_SPEC_NAME renames it; SET_AWDimLoad_SPEC_DIMENSION repoints it to a different OLAP dimension; SET_AWDimLoad_SPEC_LOADTYPE changes the load method. ADD_AWDimLoad_SPEC_FILTER and DELETE_AWDimLoad_SPEC_FILTER manage the lookup-table WHERE clauses that restrict which relational rows are loaded, and SET_AWDimLoad_SPEC_PARAMETER writes arbitrary parameter values consumed by the load routine.
- AWCubeLoad specification maintenance: CREATE_AWCubeLoad_SPEC and DELETE_AWCubeLoad_SPEC create and drop cube load specifications. SET_AWCubeLoad_SPEC_NAME, SET_AWCubeLoad_SPEC_CUBE, and SET_AWCubeLoad_SPEC_LOADTYPE adjust identity and load strategy. ADD_AWCubeLoad_SPEC_FILTER and DELETE_AWCubeLoad_SPEC_FILTER manage source-row filters, ADD_AWCubeLoad_SPEC_MEASURE and DELETE_AWCubeLoad_SPEC_MEASURE declare which cube measures participate in the load, and SET_AWCubeLoad_SPEC_PARAMETER supplies runtime parameter values.
- AWCubeAgg specification maintenance: CREATE_AWCubeAGG_SPEC and ADD_AWCubeAGG_SPEC_LEVEL define cube aggregation specifications and the hierarchy levels that should be pre-aggregated. Additional procedures in the same family control aggregation naming, load type, and level removal.
The procedures follow a consistent naming convention — a verb prefix (CREATE, DELETE, SET, ADD) applied to a fully qualified object name — and most require the specification name together with dimension or cube owner and name to uniquely identify the target.
Tables Accessed
DBMS_AWM reads and writes the OLAP 2 metadata catalog through APPS synonyms. ALL_OLAP2_AWS exposes analytic workspace definitions; ALL_OLAP2_AW_DIMENSIONS and ALL_OLAP2_DIMENSIONS expose dimension definitions; ALL_OLAP2_AW_CUBES exposes cube definitions. The views ALL_AW_DIM_ENABLED_VIEWS and ALL_AW_CUBE_ENABLED_VIEWS identify which relational views have been registered as OLAP-enabled sources. The package also invokes DBMS_ASSERT for name validation, DBMS_AW for analytic workspace operations, DBMS_LOB for large object handling, and DBMS_SCHEDULER to schedule derived load jobs.
Usage Notes
DBMS_AWM is ordinarily invoked programmatically rather than interactively. In EBS it is reached from OLAP management forms in the Oracle OLAP administration module, from concurrent programs that refresh analytic workspaces, and from custom PL/SQL that automates dimension or cube load maintenance. Because the package operates with authid current_user, direct execution requires the caller to hold the underlying OLAP catalog privileges; EBS addresses this by granting execute through the APPS schema.
No other documented package in the ETRM repository references DBMS_AWM, so its exposure is limited to callers that explicitly target it. Changes made through these procedures affect OLAP metadata only and do not touch EBS transactional tables; they should therefore be treated as metadata administration and scheduled outside peak business hours, with a full export of the OLAP 2 catalog maintained beforehand to allow rollback.
-
SYNONYM: PUBLIC.DBMS_AWM 12.1.1
-
PACKAGE: OLAPSYS.DBMS_AWM 12.1.1
-
12.1.1 DBA Data 12.1.1
-
12.1.1 DBA Data 12.1.1
-
SYNONYM: PUBLIC.DBMS_AW 12.1.1
-
SYNONYM: PUBLIC.DBMS_ASSERT 12.1.1
-
PACKAGE: OLAPSYS.DBMS_AWM 12.1.1
-
SYNONYM: PUBLIC.DBMS_LOB 12.1.1