Versions Compared

Old Version 3

changes.mady.by.user Unknown User (harmeet@emforium.com)

Saved on

compared with

New Version Current

changes.mady.by.user Unknown User (harmeet@emforium.com)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 4.0

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.