Sales Domain
Fact-field | Fact-alias | |||
---|---|---|---|---|
accountDimId | account | Y | Y | |
brandDimId | brand | Y | Y | |
carrierDimId | carrier | |||
catalogDimId | catalog | |||
customerDimId | customer | Y | Y | |
countryDimId | country | |||
currencyDimId | currency | Y | Y | |
dateDimId | date | Y | Y | |
employeeDimId | employee | |||
facilityDimId | facility | |||
Manager | managerDimId | manager | ||
organisationDimId | organisation | Y | Y | |
PaymentMethod | paymentMethodDimId | payMethod | ||
productDimId | product | Y | Y | |
productCategoryDimId | category | |||
Project | projectDimId | project | ||
channelDimId | channel | Y | Y | |
SalesPromo | promoDimId | promo | Y | |
SalesRep | salesrepDimId | rep | Y | Y |
storeDimId | store | Y | Y | |
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 | 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 | 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 |
Related tickets
Open
Closed