Search Results bisbv_dimensions




Overview
Explore in AI Chat

Overview

BISBV_DIMENSIONS is a read-only reporting view within the Oracle EBS Applications BIS (Business Intelligence System) product family. It exposes the master list of business dimensions defined for the ETRM/analytics schemas, presenting each dimension together with its translated display name and description. The view is engineered to surface the correct language-specific text for the session by filtering on the current runtime language, which makes it suitable for multilingual reporting environments. A defining characteristic of the view is the presence of the WITH READ ONLY clause, which prevents any DML activity against the view and reinforces its purpose as a query-only presentation layer. In release 12.1.1 and 12.2.2 the object exists primarily to support BIS and ETRM reporting components that need a clean, joined representation of dimension metadata without requiring the caller to perform the base-table join themselves.

Underlying Base Objects

The view is defined over two base tables: BIS_DIMENSIONS (the primary entity table) and BIS_DIMENSIONS_TL (the translated-language companion table). BIS_DIMENSIONS holds the language-independent attributes of every dimension, while BIS_DIMENSIONS_TL stores the translatable NAME and DESCRIPTION values keyed by DIMENSION_ID and LANGUAGE. The join is performed on DIMENSION_ID, with the language predicate BIS_DIMENSIONS_TL.LANGUAGE = USERENV('LANG') ensuring that only the row matching the session language is returned. Two important filters are embedded in the definition: the view excludes the seeded dimension with DIMENSION_ID = -1, and it therefore never returns that internal placeholder row. The ETRM metadata notes that the view is "not implemented in this database" in the noted environment and documents no referenced base objects at the dictionary level, which indicates that availability is dependent on the BIS/ETRM schema having been installed and configured in the target instance.

Key Columns

  • DIMENSION_ID — Unique surrogate key identifying the dimension; used to join to BIS_DIMENSIONS_TL and related fact/metadata objects.
  • DIM_GRP_ID — Identifier of the dimension group to which the dimension belongs, supporting grouping in design and reporting screens.
  • SHORT_NAME — Language-independent short code for the dimension, commonly used in programmatic references.
  • DIMENSION_SHORT_NAME — Documented column alias exposing the short code for reporting consumers.
  • DIMENSION_NAME — Translated display name sourced from BIS_DIMENSIONS_TL.NAME.
  • DESCRIPTION — Translated descriptive text from BIS_DIMENSIONS_TL.DESCRIPTION.
  • APPLICATION_ID — Owning application identifier, allowing the dimension to be traced to its product.
  • HIDE_IN_DESIGN — Flag controlling whether the dimension is suppressed in design-time pickers.
  • CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard audit columns for change tracking.

Common Use Cases and Queries

The view is typically used to populate dimension selection lists, validate dimension codes during data loading, and drive multilingual reporting extracts. A representative query listing all visible dimensions follows:

  • SELECT DIMENSION_ID, DIMENSION_SHORT_NAME, DIMENSION_NAME, DESCRIPTION FROM BISBV_DIMENSIONS ORDER BY DIMENSION_NAME;
  • SELECT d.DIM_GRP_ID, COUNT(*) FROM BISBV_DIMENSIONS d GROUP BY d.DIM_GRP_ID;
  • SELECT DIMENSION_ID, DIMENSION_NAME FROM BISBV_DIMENSIONS WHERE HIDE_IN_DESIGN = 'N';
  • SELECT DIMENSION_ID, APPLICATION_ID FROM BISBV_DIMENSIONS WHERE APPLICATION_ID = :app_id;

Because the session language governs the translated text, callers requiring a specific locale should set the NLS language environment before querying. Write operations must target the base tables directly, since the view enforces read-only access.