Finance Dimension 11 Dim

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

Finance Dimension 11 Dim This dimension captures essential financial categorization attributes within the data warehouse, supporting reporting and analysis for financial operations. It includes key identifiers, descriptive labels, and metadata such as modification timestamps and deletion status to ensure data accuracy and historical tracking.

Output Column	Database Logic	Description
Finance Dimension 11 Key	Unique identifier for each finance dimension entry as defined in the Finance Dimension 11 view.	This is the unique key that identifies each financial dimension entry, allowing precise tracking and referencing of financial categories.
Company	Company code associated with the finance dimension entry from the Finance Dimension 11 data.	Indicates the company related to the financial data, ensuring that financial reporting is segmented by the respective corporate entity.
Finance Dimension 11	The actual finance dimension value or code as maintained in the Finance Dimension 11 source.	Represents the specific finance dimension value used for classification within financial reports, such as cost centers or departments.
Finance Dimension 11 Description	Textual description or label describing the finance dimension entry.	Provides a clear and understandable description of the finance dimension, making it easier for stakeholders to interpret the financial categories.
Level	Hierarchical level indicator showing the position of the finance dimension in the dimension structure.	Shows the hierarchical level of the financial dimension, helping to understand the detail and aggregation level of financial data.
Last Modified Datetime	Timestamp of the last update made to the finance dimension record.	Records the date and time when the financial dimension data was last updated, ensuring users can trust the data's currency.
Deleted	Flag indicating whether the finance dimension entry is marked as deleted or active.	Indicates if the financial dimension record is currently active or has been marked as deleted, supporting data integrity and historical tracking.