Sales Domain
Facts | ||||
---|---|---|---|---|
Dimension | Fact-field | Fact-alias | SalesInvoiceFact | SalesOrderFact |
Account | accountDimId | account | Y | Y |
---|---|---|---|---|
Brand | brandDimId | brand | 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 |
---|
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 | ||
Time | timeDimId | time | Y | |
TimeEntry | timeEntryDimId | timeEntry |
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 | |
Catalog | catalogDimId | catalog | |
Customer | customerDimId | customer | |
Country | countryDimId | country | |
Currency | currencyDimId | currency | |
Date | dateDimId | date | Y |
Employee | employeeDimId | employee | Y |
Facility | facilityDimId | facility | Y |
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 |
TimeEntry | timeEntryDimId | timeEntry |
Project
Facts | |||
---|---|---|---|
Dimension | Fact-field | Fact-alias | tbd |
Account | accountDimId | account | |
---|---|---|---|
Brand | brandDimId | brand | |
Carrier | carrierDimId | carrier | |
Catalog | catalogDimId | catalog | |
Customer | customerDimId | customer | Y |
Country | countryDimId | country | |
Currency | currencyDimId | currency | |
Date | dateDimId | date | Y |
Employee | employeeDimId | employee | Y |
Facility | facilityDimId | facility | |
Manager | managerDimId | manager | Y |
Organisation | organisationDimId | organisation | Y |
PaymentMethod | paymentMethodDimId | payMethod | |
Product | productDimId | product | |
ProductCategory | productCategoryDimId | category | |
Project | projectDimId | project | Y |
SalesChannel | channelDimId | channel | |
SalesPromo | promoDimId | promo | |
SalesRep | salesrepDimId | rep | |
Store | storeDimId | store | |
Supplier | supplierDimId | supplier | |
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 | |
TimeEntry | timeEntryDimId | timeEntry |