OE Historical Orders

The data model includes measures such as quantity ordered, backordered, committed, and shipped, along with invoice costs and amounts, late payment amounts categorized by days overdue in both the source and home currencies, and reporting currency amounts for historical orders. The model also captures geographical data with the latitude and longitude of the shipping destination. Additionally, it accounts for the days until the requested date at both header and detail levels for historical orders.

Benefits of This Data Model

• Improved Order Tracking: Enables better tracking of historical orders with details such as expected ship dates and requested ship dates at both header and detail levels.

• Enhanced Geographic Analysis: Facilitates geographical analysis by capturing the latitude and longitude of shipping destinations, providing insights into customer locations and shipping patterns.

• Efficient Currency Analysis: Allows for detailed analysis of late payment amounts categorized by days overdue in both the source and home currencies, along with reporting currency amounts for historical orders.

• Comprehensive Customer Insights: Provides a comprehensive view of customer-related dimensions such as customer ID, name, group code, and descriptive details, aiding in customer segmentation and analysis.

• Cost Optimization: Supports cost optimization through measures like quantity ordered, backordered, committed, and shipped, along with invoice costs and amounts, enabling better cost management and control.

Key Performance Indicators (KPIs)

• Ship To Latitude: The latitude of the shipping destination for historical orders.
• Ship To Longitude: The longitude of the shipping destination for historical orders.
• Quantity Ordered: The quantity of goods ordered in historical orders.
• Quantity BackOrdered: The quantity of goods that are on backorder in historical orders.
• Quantity Committed: The quantity of goods that are committed and scheduled for shipment in historical orders.
• Quantity Shipped To Date: The total quantity of goods shipped up to the current date in historical orders.
• Invoice Cost: The cost of the invoices for the historical orders.
• Invoice Amount: The total amount billed on the invoices for the historical orders.
• Days Until Requested Date Header: Number of days until the requested date at the header level in historical orders.
• Days Until Requested Date Detail: Number of days until the requested date at the detail level in historical orders.
• Source Currency Current Amount: The current amount in the source currency for the historical orders.
• Source Currency Late Total Amount: Total amount late in the source currency for historical orders.
• Amount Late SC 1-30 Days: Amount late in the source currency within 1-30 days for historical orders.
• Amount Late SC 31-60 Days: Amount late in the source currency within 31-60 days for historical orders.
• Amount Late SC 61-90 Days: Amount late in the source currency within 61-90 days for historical orders.
• Amount Late SC 91-120 Days: Amount late in the source currency within 91-120 days for historical orders.
• Amount Late SC 121+ Days: Amount late in the source currency exceeding 120 days for historical orders.
• Home Currency Current Amount: The current amount in the home currency for the historical orders.
• Home Currency Late Total: Total amount late in the home currency for historical orders.
• Late HC 1-30 Days: Amount late in the home currency within 1-30 days for historical orders.
• Late HC 31-60 Days: Amount late in the home currency within 31-60 days for historical orders.
• Late HC 61-90 Days: Amount late in the home currency within 61-90 days for historical orders.
• Late HC 91-120 Days: Amount late in the home currency within 91-120 days for historical orders.
• Late HC 121+ Days: Amount late in the home currency exceeding 120 days for historical orders.
• Reporting Currency Current Amount: The current amount in the reporting currency for the historical orders.
• Reporting Currency Late Total: Total amount late in the reporting currency for historical orders.

Available Visualizations

View Name	Description
Aged Orders Historical Home Currency	View showing historical orders aged in home currency.
Aged Orders Historical Source Currency	View showing historical orders aged in source currency.