Star Schema - Order Fact Source
For reporting it is optimal to create a derivative Star schema for Ofbiz entities. Orders represent a set of facts. Reports would be used to report against those facts. Each state change for an order and related entity could represent a distinct fact. Following are the entities to consider to create Order Fact table.