Facts and Dimensions
Fact tables (aka facts) stores store the performance measurements resulting from the organisation's business process events. Dimension tables (aka dimensions) contain the textual contacts context associated with a business process measurement event (captured in a fact) and describe the 'who, what, where, when, how and why'.
In the sections below we describe how the facts and dimension per business domain
Sales Domain
Fact-field | Fact-alias | AssetUtilisation | ||||||
---|---|---|---|---|---|---|---|---|
Asset | assetDimId | asset | Y | |||||
accountDimId | account | Y | Y | Y | ||||
brandDimId | brand | Y | Y | |||||
carrierDimId | carrier | |||||||
catalogDimId | catalog | |||||||
customerDimId | customer | Y | Y | Y | ||||
countryDimId | country | |||||||
currencyDimId | currency | Y | Y | |||||
dateDimId | date | Y | Y | Y | ||||
employeeDimId | employee | |||||||
facilityDimId | facility | |||||||
Manager | managerDimId | manager | ||||||
organisationDimId | organisation | Y | Y | Y | ||||
PaymentMethod | paymentMethodDimId | payMethod | ||||||
PosTerminal | posTerminalDimId | posTerminal | ||||||
productDimId | product | Y | Y | |||||
productCategoryDimId | category | |||||||
projectDimId | project | |||||||
channelDimId | channel | Y | Y | |||||
promoDimId | promo | Y | Y | |||||
SalesRep | salesrepDimId | rep | Y | Y | ||||
storeDimId | store | Y | Y | |||||
supplierDimId | supplier | |||||||
timeDimId | time | Y | TimeEntry | timeEntryDimId | timeEntry
Procurement/Purchase Domain
Facts | |||||||
---|---|---|---|---|---|---|---|
Dimension | Fact-field | Fact-alias | PurchaseInvoiceFact | PurchaseOrderFact | |||
Account | accountDimId | account | |||||
Brand | brandDimId | brand | |||||
Carrier | carrierDimId | carrier | |||||
Catalog | catalogDimId | catalog | |||||
Customer | customerDimId | customer | |||||
Country | countryDimId | country | |||||
Currency | currencyDimId | currency | Y | Y | |||
Date | dateDimId | date | Y | Y | |||
Employee | employeeDimId | employee | |||||
Facility | facilityDimId | facility | |||||
Manager | managerDimId | manager | |||||
Organisation | organisationDimId | organisation | Y | Y | |||
PaymentMethod | paymentMethodDimId | payMethod | |||||
Product | productDimId | product | Y | Y | |||
ProductCategory | productCategoryDimId | category | |||||
Project | projectDimId | project | Y | Y | |||
SalesChannel | channelDimId | channel | Y | Y | |||
SalesPromo | promoDimId | promo | Y | ||||
SalesRep | salesrepDimId | rep | Y | Y | |||
Store | storeDimId | store | Y | Y | |||
Supplier | supplierDimId | supplier | Y | Y | |||
Time | timeDimId | time | Y | TimeEntry | timeEntryDimIdtimeEntry |
Human Resources Domain
Facts | |||||||
---|---|---|---|---|---|---|---|
Dimension | Fact-field | Fact-alias | tbd | ||||
Account | accountDimId | account | |||||
Brand | brandDimId | brand | |||||
Carrier | carrierDimId | carrier | |||||
Catalog | catalogDimId | catalog | |||||
Customer | customerDimId | customer | |||||
Country | countryDimId | country | |||||
Currency | currencyDimId | currency | |||||
Date | dateDimId | date | Y | ||||
Employee | employeeDimId | employee | Y | ||||
Facility | facilityDimId | facility | |||||
Manager | managerDimId | manager | |||||
Organisation | organisationDimId | organisation | Y | ||||
PaymentMethod | paymentMethodDimId | payMethod | |||||
Product | productDimId | product | |||||
ProductCategory | productCategoryDimId | category | |||||
Project | projectDimId | project | |||||
SalesChannel | channelDimId | channel | |||||
SalesPromo | promoDimId | promo | |||||
SalesRep | salesrepDimId | rep | Y | ||||
Store | storeDimId | store | Y | ||||
Supplier | supplierDimId | supplier | |||||
Time | timeDimId | time | TimeEntry | timeEntryDimId | timeEntry | Y |
Inventory/Warehousing Domain
Facts | ||||||
---|---|---|---|---|---|---|
Dimension | Fact-field | Fact-alias | InventoryItemFact | |||
Account | accountDimId | account | ||||
Brand | brandDimId | brand | ||||
Carrier | carrierDimId | carrier | Y | |||
Catalog | catalogDimId | catalog | ||||
Customer | customerDimId | customer | ||||
Country | countryDimId | country | ||||
Currency | currencyDimId | currency | Y | |||
Date | dateDimId | date | Y | |||
Employee | employeeDimId | employee | ||||
Facility | facilityDimId | facility | Y | |||
Manager | managerDimId | manager | ||||
Organisation | organisationDimId | organisation | Y | |||
PaymentMethod | paymentMethodDimId | payMethod | ||||
Product | productDimId | product | Y | |||
ProductCategory | productCategoryDimId | category | ||||
Project | projectDimId | project | ||||
SalesChannel | channelDimId | channel | ||||
SalesPromo | promoDimId | promo | ||||
SalesRep | salesrepDimId | rep | ||||
Store | storeDimId | store | ||||
Supplier | supplierDimId | supplier | ||||
Time | timeDimId | time | Y | TimeEntry | timeEntryDimId | timeEntry |
Project Domain
Facts | |||||||
---|---|---|---|---|---|---|---|
Dimension | Fact-field | Fact-alias | TimeEntryFactTimeEntry | ||||
Account | accountDimId | account | |||||
Brand | brandDimId | brand | |||||
Carrier | carrierDimId | carrier | |||||
Catalog | catalogDimId | catalog | |||||
customerDimId | customer | Y | |||||
Country | countryDimId | country | |||||
Currency | currencyDimId | currency | |||||
dateDimId | date | Y | |||||
Employee | employeeDimId | employee | Y | ||||
Facility | facilityDimId | facility | |||||
Manager | managerDimId | manager | Y | ||||
organisationDimId | organisation | Y | |||||
PaymentMethod | paymentMethodDimId | payMethod | |||||
Product | productDimId | product | |||||
ProductCategory | productCategoryDimId | category | |||||
projectDimId | project | Y | |||||
ProjectTask | taskDimId | task | Y | ||||
SalesChannel | channelDimId | channel | |||||
SalesPromo | promoDimId | promo | |||||
SalesRep | salesrepDimId | rep | |||||
Store | storeDimId | store | |||||
Supplier | supplierDimId | supplier | ProjectTask | taskDimId | task | Y||
Time | timeDimId | time | TimeEntry | timeEntryDimId | timeEntry | Y |
Accounting Domain
Facts | |||
---|---|---|---|
Dimension | Fact-field | Fact-alias | tbd |
Account | accountDimId | account | |
Brand | brandDimId | brand | |
Carrier | carrierDimId | carrier | |
Catalog | catalogDimId | catalog | |
Customer | customerDimId | customer | |
Country | countryDimId | country | |
Currency | currencyDimId | currency | |
Date | dateDimId | date | Y |
Employee | employeeDimId | employee | |
Facility | facilityDimId | facility | |
Manager | managerDimId | manager | |
Organisation | organisationDimId | organisation | Y |
PaymentMethod | paymentMethodDimId | payMethod | Y |
Product | productDimId | product | |
ProductCategory | productCategoryDimId | category | |
Project | projectDimId | project | |
SalesChannel | channelDimId | channel | |
SalesPromo | promoDimId | promo | |
SalesRep | salesrepDimId | rep | |
Store | storeDimId | store | |
Supplier | supplierDimId | supplier | |
Time | timeDimId | time |
Manufacturing Domain
Facts | ||||||
---|---|---|---|---|---|---|
Dimension | Fact-field | Fact-alias | AssetUtilisation | |||
Asset | assetDimId | asset | TimeEntry | timeEntryDimId | timeEntry |
Related tickets
Open
Jira | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
|
Closed
Jira | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
|