Skip to main content

PJC Transactions

The data model includes measures for the total extended and total amounts in both home and reporting currencies, along with quantity for transaction analysis. Views provide insights into PJC transaction totals by category and summary of total costs by cost class, aiding in cost tracking and budget management.

Benefits of This Data Model​

  • Improved Cost Tracking: The data model allows for detailed analysis of PJC transactions by category, enhancing cost tracking capabilities.
  • Enhanced Budget Management: The model provides a summary of total costs by cost class, aiding in budget management processes.
  • Efficient Transaction Analysis: With measures for total amounts and quantities, the model supports in-depth transaction analysis for better decision-making.

Key Performance Indicators (KPIs)​

  • Home Currency Extended Amt: The total extended amount in the home currency for the transaction.
  • Home Currency Total Amt: The total amount in the home currency for the transaction.
  • Reporting Currency Extended Amt: The total extended amount in the reporting currency for the transaction.
  • Reporting Currency Total Amt: The total amount in the reporting currency for the transaction.
  • Quantity: The quantity of items involved in the transaction.

Available Visualizations​

View NameDescription
PJC Transaction Totals by CategoryAnalysis of PJC transactions grouped by categories for better cost tracking.
Total Cost by Cost ClassSummary of total costs classified by cost classes. Helps in budget management.