Stock Journal

The data model within the Stock Journal cube includes measures for tracking movements' values in ledger currency, reporting currency, and globally. It also incorporates order prices in ledger currency, reporting currency, and globally, as well as unabsorbed variances in ledger currency, reporting currency, and globally. Additionally, the model features a measure for quantity in Stock Keeping Units (STU), supporting analysis and optimization of inventory management, and the measurement of inventory to sales ratio to evaluate operational efficiencies.

Benefits of This Data Model

• Improved Inventory Management: The data model enables analysis and optimization of inventory levels by tracking stock movements and quantities in Stock Keeping Units (STU).
• Enhanced Operational Efficiency Evaluation: The measurement of inventory to sales ratio facilitates the identification of operational efficiencies by assessing the relationship between inventory levels and sales performance.
• Comprehensive Financial Analysis: With measures for movement values in different currencies and unabsorbed variances globally, the data model supports detailed financial analysis and reporting.
• Detailed Order Price Tracking: The model incorporates order prices in ledger currency, reporting currency, and globally, providing detailed insights into pricing strategies and fluctuations.

Key Performance Indicators (KPIs)

• Movement Value Ledger: This measure represents the value of movements in the ledger currency within the Stock Journal cube.
• Movement Value Reporting Currency: This measure represents the value of movements converted to the reporting currency within the Stock Journal cube.
• Movement Value Global: This measure represents the global value of movements in all currencies within the Stock Journal cube.
• Order Price Ledger: This measure represents the order price in the ledger currency within the Stock Journal cube.
• Order Price Reporting Currency: This measure represents the order price converted to the reporting currency within the Stock Journal cube.
• Order Price Global: This measure represents the global order price in all currencies within the Stock Journal cube.
• Variance Not Absorbed Ledger: This measure represents the unabsorbed variance in the ledger currency within the Stock Journal cube.
• Variance Not Absorbed Reporting Currency: This measure represents the unabsorbed variance converted to the reporting currency within the Stock Journal cube.
• Variance Not Absorbed Global: This measure represents the global unabsorbed variance in all currencies within the Stock Journal cube.
• Quantity STU: This measure represents the quantity in Stock Keeping Units (STU) within the Stock Journal cube.

Available Visualizations

View Name	Description
Stock Journal	Tracks stock movements for analysis and optimization of inventory management.
Inventory to Sales Ratio	Measures the relationship between inventory levels and sales performance to identify efficiencies.