Search Results rg_dss_var_dimensions




Overview
Explore in AI Chat

Overview

The RG_DSS_VAR_DIMENSIONS table resides in the RG schema and belongs to the Application Report Generator product family within Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented purpose is to store Financial Analyzer financial data item dimensions — in other words, it defines which dimensions apply to each Financial Analyzer variable (data item), and in what order they are resolved. The object has a VALID status in the ETRM data dictionary and is fully registered under the RG product module.

From a data modeling standpoint, the heuristic Data Vault classification for this table is link. This classification is well supported by the FK topology: the table references two independent parents — RG_DSS_VARIABLES and RG_DSS_DIMENSIONS — and its structure is essentially a join capturing the association between a variable and a dimension, plus ordering metadata. In Data Vault terms, VARIABLE_ID and DIMENSION_ID function as the natural composite key of the link, while the surrogate primary key RG_DSS_VAR_DIMENSIONS_PK (VARIABLE_ID, SEQUENCE) preserves the sequence in which dimensions are bound to a variable.

Key Information Stored

The table contains 24 documented columns, dominated by the standard EBS WHO columns and a wide CONTEXT/ATTRIBUTE1–15 flexfield scaffold. The columns of substantive interest are:

  • VARIABLE_ID — Foreign key to RG_DSS_VARIABLES; identifies the Financial Analyzer variable / data item whose dimensions are being defined. It participates in both unique indexes.
  • SEQUENCE — Ordinal position of the dimension within the variable. Combined with VARIABLE_ID it forms the surrogate primary key, so the same dimension cannot appear twice at the same position for a given variable.
  • DIMENSION_ID — Foreign key to RG_DSS_DIMENSIONS; identifies the Financial Analyzer dimension attached to the variable. Combined with VARIABLE_ID it forms the alternate unique index U2, enforcing that a given dimension is attached to a given variable only once.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Audit columns capturing who last modified the row and when; used heavily in ETRM change-detection extracts and audit views.
  • CREATION_DATE, CREATED_BY — Audit columns recording row creation.
  • CONTEXT and ATTRIBUTE1 through ATTRIBUTE15 — Descriptive flexfield (DFF) columns. Although frequently unpopulated in a vanilla install, they provide an extension surface for customer-specific dimension metadata and are exposed in EBS DFF-enabled forms.

The surrogate primary key is VARIABLE_ID + SEQUENCE (documented as PK RG_DSS_VAR_DIMENSIONS_PK, with U1 mirroring the same pair as a unique constraint). The two business-key candidates are therefore (VARIABLE_ID, SEQUENCE) and (VARIABLE_ID, DIMENSION_ID) — the first enforces positional uniqueness, the second enforces membership uniqueness.

Common Use Cases and Queries

The most common usage of this table is to resolve the ordered list of dimensions for each Financial Analyzer variable during report generation. Reports frequently need to enumerate the dimensions bound to a data item, or to find all variables that use a particular dimension. A representative query listing variables with their dimension sequence is:

SELECT v.variable_id, v.name, d.dimension_id, d.name, sv.sequence
FROM   rg_dss_var_dimensions sv
JOIN   rg_dss_variables       v ON v.variable_id  = sv.variable_id
JOIN   rg_dss_dimensions      d ON d.dimension_id = sv.dimension_id
WHERE  sv.variable_id = :p_variable_id
ORDER  BY sv.sequence;

A second common pattern is impact analysis before changing or deleting a dimension: count how many variables reference a given DIMENSION_ID via the FK to RG_DSS_DIMENSIONS. A third is incremental synchronization based on LAST_UPDATE_DATE, typical of ETRM data feeds that must respect the audit WHO columns.

Related Objects

  • RG_DSS_VARIABLES — referenced via RG_DSS_VAR_DIMENSIONS.VARIABLE_ID; the parent registry of Financial Analyzer variables.
  • RG_DSS_DIMENSIONS — referenced via RG_DSS_VAR_DIMENSIONS.DIMENSION_ID; the parent registry of dimensions.
  • RG_DSS_VAR_DIMENSIONS_PK — the primary key constraint (VARIABLE_ID, SEQUENCE).
  • RG_DSS_VAR_DIMENSIONS_UK1 / RG_DSS_VAR_DIMENSIONS_U1 — unique constraint on (VARIABLE_ID, SEQUENCE).
  • RG_DSS_VAR_DIMENSIONS_UK2 / RG_DSS_VAR_DIMENSIONS_U2 — unique constraint on (VARIABLE_ID, DIMENSION_ID).
  • Standard EBS Report Generator (RG) report-execution logic that consumes these assignments when rendering Financial Analyzer output.

Because the table carries no dependent children documented in the ETRM metadata, it behaves as a terminal link table — read-mostly, referenced by reporting code rather than by further FKs.