Search Results rg_dss_dimensions_uk2

Overview

RG_DSS_DIMENSIONS is a reference table in the RG (Application Report Generator) product schema of Oracle E-Business Suite, documented in ETRM for releases 12.1.1 and 12.2.2. The table stores the Financial Analyzer dimension definitions used by the RG reporting and analysis engine. Each row defines a single analytical dimension — such as an accounting flexfield segment, a currency dimension, or a user-defined grouping — together with the metadata required to render that dimension in report layouts, selectors, and hierarchical drill-downs. Because dimensions are the axes along which Financial Analyzer aggregates balances and transactions, this table acts as the semantic backbone for RG-driven financial reporting.

From a modeling perspective, the heuristic Data Vault classification of this table is hub-leaning. The dimension identifier is referenced by three separate dependent tables via foreign keys, which is the characteristic signature of a hub entity surrounded by link and satellite structures. Treating RG_DSS_DIMENSIONS as a hub candidate is a reasonable starting point for any downstream dimensional or Data Vault-style model.

Key Information Stored

The physical schema documented for 12.2.2 contains 36 columns. The most significant are summarized below.

• DIMENSION_ID — surrogate primary key (RG_DSS_DIMENSIONS_PK) and the join column consumed by all dependent tables.
• NAME — business-key candidate; enforced unique through RG_DSS_DIMENSIONS_U2 (NAME, ZD_EDITION_NAME) and referenced by the documented unique key RG_DSS_DIMENSIONS_UK1.
• OBJECT_NAME — business-key candidate; enforced unique through RG_DSS_DIMENSIONS_U3 (OBJECT_NAME, ZD_EDITION_NAME) and the documented unique key RG_DSS_DIMENSIONS_UK2.
• OBJECT_PREFIX and VALUE_PREFIX — naming prefixes applied when the dimension is expanded into report object or value identifiers.
• ROW_LABEL, COLUMN_LABEL, SELECTOR_LABEL — display labels for the dimension when positioned on rows, columns, or in the dimension selector.
• LEVEL_CODE and DIMENSION_TYPE — classification controls governing how the dimension is expanded and aggregated.
• DIMENSION_BY_CURRENCY — flag indicating whether the dimension is segmented by currency.
• ID_FLEX_CODE and ID_FLEX_NUM — link the dimension to its underlying key flexfield definition when the dimension is flexfield-derived.
• DESCRIPTION and CONTEXT — free-text context and descriptive metadata.
• ATTRIBUTE1 through ATTRIBUTE15 — the standard EBS descriptive flexfield attribute columns.
• ZD_EDITION_NAME — editioning column participating in every documented unique index, supporting Online Patching edition-based redefinition.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — standard EBS audit columns.

The documented unique indexes RG_DSS_DIMENSIONS_U1 (DIMENSION_ID, ZD_EDITION_NAME), U2 (NAME, ZD_EDITION_NAME), and U3 (OBJECT_NAME, ZD_EDITION_NAME) confirm that both the surrogate key and the two business keys are edition-scoped.

Common Use Cases and Queries

Typical usage centers on configuration review and metadata-driven reporting. Administrators query the table to audit which dimensions are defined, how they are labeled, and whether they are flexfield-backed. A standard lookup by business key follows this pattern:

• Retrieve a dimension by name: SELECT dimension_id, name, object_name, dimension_type FROM rg.rg_dss_dimensions WHERE name = :p_name AND zd_edition_name = :p_edition;
• Find all flexfield-derived dimensions: SELECT dimension_id, name, id_flex_code, id_flex_num FROM rg.rg_dss_dimensions WHERE id_flex_code IS NOT NULL;
• List currency-segmented dimensions: SELECT dimension_id, name FROM rg.rg_dss_dimensions WHERE dimension_by_currency = 'Y';
• Join to hierarchy definitions to enumerate available drill paths: SELECT d.name, h.hierarchy_id FROM rg.rg_dss_dimensions d, rg.rg_dss_hierarchies h WHERE d.dimension_id = h.dimension_id;

Reporting scenarios include generating a catalog of dimension labels for report designers, validating that every dimension referenced by a hierarchy or variable has a valid parent row, and reconciling dimension metadata after an upgrade or edition switch.

Related Objects

The following objects reference or depend on RG_DSS_DIMENSIONS through documented foreign key relationships:

• RG_DSS_DIM_SEGMENTS — references RG_DSS_DIMENSIONS.DIMENSION_ID; stores the segments that compose each dimension.
• RG_DSS_HIERARCHIES — references RG_DSS_DIMENSIONS.DIMENSION_ID; defines hierarchical roll-up structures for the dimension.
• RG_DSS_VAR_DIMENSIONS — references RG_DSS_DIMENSIONS.DIMENSION_ID; associates variable definitions with dimensions.

Together these three tables form the immediate dependency cluster around the dimension hub and should be included in any extraction or impact analysis involving RG Financial Analyzer metadata. The unique indexes RG_DSS_DIMENSIONS_U1, U2, and U3, along with the primary key RG_DSS_DIMENSIONS_PK, govern row identity and editioning behavior for all dependent lookups.