You are viewing an old version of this page. View the current version.
Compare with Current
View Page History
« Previous
Version 3
Next »
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 |
|
|
---|