Sales Domain
Facts | |||||
---|---|---|---|---|---|
Dimension | Fact-field | Fact-alias | SalesInvoiceFact | SalesOrderFact | JIRA ticket |
Account | accountDimId | account | Y | Y | |
Carrier | carrierDimId | carrier | |||
Catalog | catalogDimId | catalog | |||
Customer | customerDimId | customer | Y | Y | |
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 | |||
SalesChannel | channelDimId | channel | Y | Y | |
SalesPromo | promoDimId | promo | Y | ||
SalesRep | salesrepDimId | rep | Y | Y | |
Store | storeDimId | store | Y | Y | |
Supplier | supplierDimId | supplier | |||
Time | timeDimId | time | Y |
Procurement/Purchase Domain
Facts | |||||
---|---|---|---|---|---|
Dimension | Fact-field | Fact-alias | PurchaseInvoiceFact | PurchaseOrderFact | JIRA ticket |
Account | accountDimId | account | |||
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 | |||
Time | timeDimId | time | Y |
Human Resources Domain
Facts | ||||
---|---|---|---|---|
Dimension | Fact-field | Fact-alias | tbd | JIRA ticket |
Account | accountDimId | account | ||
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 | Y |
Inventory/Warehousing Domain
Facts | ||||
---|---|---|---|---|
Dimension | Fact-field | Fact-alias | InventoryItemFact | JIRA ticket |
Account | accountDimId | account | ||
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 | Y |
Project
Facts | ||||
---|---|---|---|---|
Dimension | Fact-field | Fact-alias | tbd | JIRA ticket |
Account | accountDimId | account | ||
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 | ||
Store | storeDimId | store | ||
Supplier | supplierDimId | supplier | ||
Time | timeDimId | time |
Accounting Domain
Facts | ||||
---|---|---|---|---|
Dimension | Fact-field | Fact-alias | tbd | JIRA ticket |
Account | accountDimId | account | ||
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 |