Search Results set_plural_name




Overview
Explore in AI Chat

Overview

The OLAPSYS.CWM2_OLAP_DIMENSION package is a member of the OLAP Catalog (CWM2) PL/SQL API family shipped with the Oracle database and surfaced within the Oracle E-Business Suite 12.1.1 and 12.2.2 environments through the OLAPSYS schema. It provides the programmatic interface for creating, maintaining, and administering logical OLAP dimensions — the metadata objects that describe the axes along which analytic measures are aggregated (for example, Time, Product, Customer, or Geography). In the EBS context, this package underpins the metadata layer that EBS Business Intelligence, Discoverer, and OLAP-based reporting components rely upon to resolve dimension definitions stored in the OLAP Catalog.

The package is classified as an OTHER API, meaning it is not a documented EBS business-facing API such as those in the AP, GL, or PO schemas. It is a database-tier utility that manipulates OLAP metadata and is generally invoked indirectly by OLAP administration tools rather than by EBS application logic. Customizations that reference it should be treated as advanced, low-level integrations.

Key Procedures and Functions

The package exposes nine documented procedures covering the full lifecycle of a dimension definition:

  • CREATE_DIMENSION — Creates a new dimension, accepting owner, name, display name, plural name, short description, description, and an optional dimension type.
  • SET_DIMENSION_NAME — Renames an existing dimension, changing its stored name to a new value.
  • SET_DISPLAY_NAME — Updates the display (label) name shown to end users.
  • SET_PLURAL_NAME — Updates the plural form of the dimension name, which is the attribute targeted by the search term "set_plural_name". This is the caption rendered when a dimension is presented in plural contexts, such as column headings or list views.
  • SET_SHORT_DESCRIPTION — Modifies the abbreviated description associated with the dimension.
  • SET_DESCRIPTION — Replaces the full long description.
  • SET_DEFAULT_DISPLAY_HIERARCHY — Designates the hierarchy used by default when the dimension is rendered.
  • DROP_DIMENSION — Removes a dimension definition, with an optional silent flag to suppress errors if the object is absent.
  • LOCK_DIMENSION — Acquires a lock on the dimension to serialize concurrent metadata changes, with an optional wait-for-lock behavior.

The setter procedures share a common pattern of accepting the dimension owner and dimension name as identifying keys, followed by the attribute value to be applied.

Tables Accessed

The supplied ETRM metadata does not enumerate specific tables referenced through APPS synonyms, which is consistent with this being an OLAPSYS-owned catalog package that writes to OLAP Catalog repository tables (the CWM2_* metadata views and their underlying base tables) rather than to standard EBS application tables. Modifications made through the setters — including set_plural_name — persist to the dimension metadata stored in that repository. Practitioners should not assume direct EBS table dependencies for this package.

Usage Notes

Because it is classified as an OTHER API and is owned by OLAPSYS rather than by an EBS product schema, CWM2_OLAP_DIMENSION is not called from standard EBS forms or concurrent programs within the 12.1.1 or 12.2.2 application flows. It is most commonly invoked by OLAP administration utilities, metadata synchronization scripts, or custom PL/SQL that programmatically defines or re-labels analytic dimensions. The metadata notes that the package is referenced by one other package, indicating a dependent internal component. When used in custom code, changes such as set_plural_name should be followed by the appropriate metadata commit or refresh so that reporting layers reflect the updated caption. Given the package's low-level, undocumented nature, DBAs should validate against the specific database version's OLAP Catalog before relying on it in production EBS customizations.