Search Results rg_dss_var_dimensions_pk

Overview

The RG_DSS_VAR_DIMENSIONS table is a core data structure within the Application Report Generator (RG) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It functions as a junction table, establishing the critical many-to-many relationship between financial data items (variables) and their associated analytical dimensions. This table is essential for the Financial Analyzer component, enabling the multi-dimensional analysis of financial data by defining which dimensions—such as Account, Company, or Product—are applicable to a specific financial variable. Its role is to maintain the dimensional framework that underpins complex financial reporting and ad-hoc analysis within the EBS environment.

Key Information Stored

The table's primary purpose is to map variables to dimensions. Its key columns, as defined by its primary and unique keys, are VARIABLE_ID and DIMENSION_ID. The VARIABLE_ID column is a foreign key linking to the RG_DSS_VARIABLES table, identifying the specific financial data item. The DIMENSION_ID column is a foreign key linking to the RG_DSS_DIMENSIONS table, identifying the analytical dimension. The SEQUENCE column, used in conjunction with VARIABLE_ID for the primary key, dictates the order or precedence of dimensions for a given variable. This structure allows a single variable to be analyzed across multiple dimensions and a single dimension to be associated with numerous variables.

Common Use Cases and Queries

A primary use case is auditing or documenting the dimensional model for financial reporting. Administrators or developers often query this table to understand the complete dimensional context of a variable, which is crucial for troubleshooting report definitions or building custom analytical queries. A typical query retrieves all dimensions for a known variable name or ID.

• Sample SQL Pattern: To find all dimensions linked to a specific variable:
  SELECT d.DIMENSION_NAME, vd.SEQUENCE
FROM rg_dss_var_dimensions vd,
rg_dss_dimensions d,
rg_dss_variables v
WHERE vd.dimension_id = d.dimension_id
AND vd.variable_id = v.variable_id
AND v.variable_name = 'REVENUE'
ORDER BY vd.sequence;
• Reporting Use Case: Generating a master list of all financial variables with their assigned dimensions for system documentation or compliance purposes.

Related Objects

The RG_DSS_VAR_DIMENSIONS table is centrally connected to two other foundational tables in the RG schema, as defined by its documented foreign key constraints.

• RG_DSS_VARIABLES: This table stores the definition of financial data items. The relationship is established via RG_DSS_VAR_DIMENSIONS.VARIABLE_ID → RG_DSS_VARIABLES. A row in RG_DSS_VARIABLES can have multiple associated dimension mappings in this table.
• RG_DSS_DIMENSIONS: This table stores the definition of analytical dimensions. The relationship is established via RG_DSS_VAR_DIMENSIONS.DIMENSION_ID → RG_DSS_DIMENSIONS. A dimension defined in RG_DSS_DIMENSIONS can be applied to many different variables through this table.

These relationships are enforced by the primary key RG_DSS_VAR_DIMENSIONS_PK (VARIABLE_ID, SEQUENCE) and the unique key RG_DSS_VAR_DIMENSIONS_UK1 (VARIABLE_ID, DIMENSION_ID), ensuring data integrity in the dimensional model.