THIS IS A TEST INSTANCE. ALL YOUR CHANGES WILL BE LOST!!!!
The Sales Invoice Item Star Schema combines following dimension and fact tables:
Dimension/Fact | Description |
---|---|
PurchaseOrderItemFact | Fact table having transaction records regarding Order items |
DateDimension | Dimension table having attributes regarding the date dimension id in the fact table |
SupplierDimension | Dimension table having attributes regarding the supplier dimension id in the fact table |
OrganisationDimension | Dimension table having attributes regarding the organisation dimension id in the fact table |
ProductDimension | Dimension table having attributes regarding the product dimension id in the fact table |
CurrencyDimension | Dimension table having attributes regarding the currency dimension id in the fact table |