Purchase Orders

The Purchase Orders cube analyzes the purchase process of the company such as, the monetary value, type of goods, suppliers, and period. The analysis helps to identify issues and trends, which affect the supply chain of a company.

The facts in this model can be analyzed by order date.

Source information

The main source for this model is the table MPLINE in M3 BE. The time dimension is based on the order date. This model has two fact tables, one captures order line transactions, and the other provides order header data.