Search Results rg_dss_dimensions




Overview
Explore in AI Chat

Overview

The RG_DSS_DIMENSIONS table is a core metadata repository within the Oracle E-Business Suite Application Report Generator (RG) module. It serves as the master definition table for Financial Analyzer dimensions. In the context of the Decision Support System (DSS), a dimension represents a fundamental analytical perspective, such as Account, Company, or Product, used to categorize and analyze financial data. This table is critical for establishing the framework within which financial reporting, consolidation, and analysis are performed, enabling the structuring of data hierarchies and the definition of reporting segments.

Key Information Stored

The table's structure is designed to uniquely identify and define each analytical dimension. The primary identifier is the DIMENSION_ID column, which serves as the system-generated surrogate key for all relationships. The NAME column stores the logical, user-facing name of the dimension (e.g., "Cost Center"). The OBJECT_NAME column typically holds the corresponding physical object or application identifier within the system. The presence of unique constraints on both NAME and OBJECT_NAME underscores the requirement for dimension names to be distinct and for each physical object to map to a single logical dimension definition.

Common Use Cases and Queries

This table is primarily accessed for metadata queries to support report building, data validation, and system integration. Common operational scenarios include retrieving a list of all available dimensions for a report parameter or validating dimension existence before data load processes. A typical query would join RG_DSS_DIMENSIONS with its child table, RG_DSS_DIM_SEGMENTS, to list all segments defined for a specific dimension. For example:

  • SELECT d.name, s.segment_name FROM rg_dss_dimensions d, rg_dss_dim_segments s WHERE d.dimension_id = s.dimension_id ORDER BY d.name;

Another critical use case involves troubleshooting or auditing the dimensional model by identifying dimensions that are referenced in variable definitions or hierarchies through their respective foreign key relationships.

Related Objects

The RG_DSS_DIMENSIONS table is a central parent table with several key dependencies, as documented by its foreign key relationships. The DIMENSION_ID column is referenced as a foreign key in the following tables:

  • RG_DSS_DIM_SEGMENTS: Links dimensions to their constituent segments (RG_DSS_DIM_SEGMENTS.DIMENSION_ID).
  • RG_DSS_HIERARCHIES: Associates dimensions with defined hierarchical structures (RG_DSS_HIERARCHIES.DIMENSION_ID).
  • RG_DSS_VAR_DIMENSIONS: Connects dimensions to variable definitions used in reporting (RG_DSS_VAR_DIMENSIONS.DIMENSION_ID).

These relationships form the backbone of the Financial Analyzer's metadata architecture, ensuring data integrity from the core dimension definition down to its detailed segments and hierarchical representations.