Skip to main content

Detailed Transactions

The data model includes views for Detail Transactions and Detail Transactions by Year, with measures including Journal Transaction Amount, Journal Transaction Quantity, Source Currency Amount, and Reporting Currency Amount. It captures detailed business transaction information, transaction trends over different years, total transaction monetary values, quantities, original currency amounts, and converted/reporting currency amounts.

Benefits of This Data Model​

  • Enhanced Transaction Analysis: Enables detailed examination of transaction data by various dimensions such as company code, fiscal year, GL account number, and more for comprehensive insights.

  • Improved Trend Identification: Facilitates the identification of transaction trends over different fiscal and calendar periods, aiding in better understanding business patterns and performance over time.

  • Enhanced Currency Conversion Analysis: Provides the ability to analyze transaction amounts in both the source currency and reporting currency, aiding in evaluating the impact of currency fluctuations on financial performance.

  • Comprehensive Business Reporting: Enables the generation of detailed reports on transaction quantities and monetary values across different segments and categories, enhancing overall business reporting capabilities.

Key Performance Indicators (KPIs)​

  • Journal Transaction Amount: The total monetary value of transactions recorded in the journal.
  • Journal Transaction Quantity: The total quantity of items or units involved in transactions recorded in the journal.
  • Source Currency Amount: The monetary amount of transactions in the original/source currency before any conversion.
  • Reporting Currency Amount: The monetary amount of transactions converted and reported in the target/reporting currency.

Available Visualizations​

View NameDescription
Detail TransactionsProvides a detailed view of all business transactions within the data model.
Detail Transactions by YearOffers insights into transaction trends and patterns on a yearly basis.