Search Results drop_branch




Overview
Explore in AI Chat

Overview

SYS.DBMS_CUBE_UTIL is an Oracle-supplied utility package that supports the OLAP cube infrastructure underlying Oracle Enterprise Business Intelligence and the analytic features embedded within Oracle E-Business Suite 12.1.1 and 12.2.2. In the EBS context, the package belongs to the SYS schema and is classified in the ETRM repository as a UTIL object, meaning it exposes internal helper routines rather than an end-user business API. Its principal role is to provide supporting operations for cube metadata resolution, report filter construction, and dimension member retrieval that higher-level OLAP and reporting components consume during query preparation and cube maintenance.

The package is documented as VALID and depends on the sibling types DBMS_CUBE_UTIL_DFLT_MSR_T and DBMS_CUBE_UTIL_EXT_MD_T, together with the STANDARD package. It is referenced by PUBLIC and by SYS itself, and is not referenced by any other EBS package in the documented metadata, confirming its position as a low-level foundation object rather than a shared business service.

Key Procedures and Functions

The ETRM documentation records seven callable units within the package. Because DBMS_CUBE_UTIL is a utility layer, these routines operate on metadata and filter definitions rather than on transactional data.

  • CREATE_RPT_FILTER — Creates a report-level filter definition used to constrain the data returned by a cube-based report or query.
  • DROP_RPT_FILTER — Removes a previously created report filter, releasing the associated definition.
  • DROP_BRANCH — Removes a branch within a cube metadata or dimension hierarchy structure, used when pruning or rebuilding analytic hierarchies.
  • GET_DIMENSION_SPECIAL_MEMBER — Returns the special member of a dimension, such as the "all" or total member that OLAP engines maintain for aggregation.
  • GET_EXT_METADATA — Retrieves extended metadata for a cube object, exposing the additional attributes represented by the DBMS_CUBE_UTIL_EXT_MD_T type.
  • GET_DEFAULT_MEASURE — Returns the default measure associated with a cube, using the DBMS_CUBE_UTIL_DFLT_MSR_T type.

The remaining documented entry follows the same naming convention and participates in the same metadata-resolution family; parameter signatures are not enumerated in the source metadata and are therefore omitted here.

Tables Accessed

The documented ETRM metadata does not list any base tables referenced through APPS synonyms. This is consistent with the package's design: it operates primarily against OLAP metadata structures held in SYS-owned dictionary objects and against the PL/SQL collection types declared alongside the package. Any persistent cube definitions reside in the OLAP catalog rather than in EBS application tables, which explains the absence of synonym-based dependencies.

Usage Notes

SYS.DBMS_CUBE_UTIL is an internal Oracle component and is not intended for direct invocation from EBS forms, concurrent programs, or customer extensions. Its routines are called by Oracle's OLAP engine and by higher-level cube management code to resolve dimensions, measures, and report filters at runtime. Because the package resides in SYS and carries no documented grants beyond Oracle's own references, EBS developers should treat it as read-only infrastructure. Where custom analytics require similar behavior, the supported approach is to use the documented OLAP and BI APIs rather than calling these utility procedures directly, since their signatures are not part of the published EBS interface and may change across patch levels.