Finance Dimension 07 Dim

Created by Robert Cross, Modified on Wed, 9 Jul, 2025 at 7:51 AM by Robert Cross

Finance Dimension 07 Dim

This dimension captures detailed financial classification data related to 'Finance Dimension 07' used across the organization. It provides a structured way to categorize and understand financial entries by key, company, description, level, and status. The dimension supports analysis and reporting needs with key business attributes that define the financial dimension context within the data warehouse.

Output Column	Database Logic	Description
Finance Dimension 07 Key	Unique identifier key for the Finance Dimension 07 in the source system.	This field represents the unique key assigned to each finance dimension record, allowing clear identification and linkage across financial data sets.
Company	The company associated with the finance dimension entry.	Indicates the company or business unit that the financial dimension record belongs to, enabling company-specific financial reporting.
Finance Dimension 07	The actual code or value representing the Finance Dimension 07.	This is the core financial dimension value or code that categorizes transactions within the finance dimension for reporting and analysis.
Finance Dimension 07 Description	Descriptive text explaining the Finance Dimension 07.	Provides a human-readable explanation or description of the finance dimension value, offering context and clarity to business users.
Level	Hierarchy or classification level of the finance dimension record.	Represents the position or depth of the finance dimension within its hierarchical structure, supporting detailed drill-down and aggregation.
Last Modified Datetime	Timestamp of the last update made to this finance dimension record.	Shows the date and time when the finance dimension record was last updated, helping track data currency and changes over time.
Deleted	Flag indicating if the record is marked as deleted.	A status indicator that signals whether the finance dimension entry is active or has been logically removed from use.