Search Results validate_dimension

Overview

The OLAPSYS.CWM1_OLAP_VALIDATE_METADATA package is an Oracle OLAP repository validation utility shipped as part of the Oracle Database OLAP option and exposed within the Oracle E-Business Suite environment. Its purpose is to verify the structural and semantic integrity of OLAP metadata objects — specifically dimensions and cubes — before those objects are consumed by analytical applications, reporting layers, or EBS-integrated business intelligence components. In the EBS 12.1.1 and 12.2.2 architectures, the package resides in the OLAPSYS schema, which owns the OLAP catalog views and the Common Warehouse Metamodel (CWM) metadata used to describe analytic workspaces. The package is classified as an OTHER API under the ETRM documentation standard, meaning it is not an EBS-supported public interface but is nonetheless catalogued because objects in the EBS schema set may reference it or depend on metadata it produces.

Key Procedures and Functions

The documented package specification exposes two procedures. Both accept a validation-type argument that allows the caller to select the depth or category of checks to perform against the target metadata object.

• VALIDATE_DIMENSION — Accepts a dimension identifier (provided as an IRID, the internal repository identifier used by the OLAP catalog) together with a type-of-validation parameter. The procedure confirms that the dimension's metadata is internally consistent, that required attributes and hierarchies are present, and that no orphaned or conflicting definitions exist in the OLAP repository.
• VALIDATE_CUBE — Accepts a cube identifier (IRID) and a type-of-validation parameter. It validates that the cube definition is complete and coherent, including its mappings to underlying dimensions and measures, so that query and aggregation operations against the cube can proceed without runtime metadata errors.

No other procedures or functions are documented in the ETRM metadata. Both entry points are void procedures that signal results through exceptions or through the repository's validation log rather than return values.

Tables Accessed

The documented table reference for this package, resolved through APPS synonyms, is DBA_USERS. This view is consulted for schema and privilege verification — confirming that the owner of the OLAP metadata being validated is a valid, existing database user and that the metadata references resolve to known schemas. The package additionally operates against the OLAPSYS CWM metadata dictionary views (for example, the ALL_OLAP_* family of catalog views) to read dimension and cube definitions, though only DBA_USERS is enumerated in the ETRM record.

Usage Notes

In practice, CWM1_OLAP_VALIDATE_METADATA is invoked programmatically rather than through an EBS form or standard concurrent program. It is typically called by OLAP administrative scripts, by Analytic Workspace Manager validation routines, or by custom PL/SQL that loads OLAP metadata and must confirm correctness before publishing cubes to EBS reporting users. Because the package is documented as being referenced by one other package, dependencies should be reviewed before any patching or upgrade of the OLAPSYS schema. EBS 12.1.1 and 12.2.2 customers should treat this as an internal Oracle-supplied API: it may be called from custom code for diagnostic purposes, but it is not part of the supported EBS public API surface, and its signature may change with database or OLAP option upgrades.