Fulfillment Fact Relationships

The FULFILLMENT_FACT table is linked to the following dimensions: FULFILLMENT_DIMENSION, ORG_UNIT_DIMENSION, TIME_DIMENSION, LICENSE_MODEL_DIMENSION, LINE_ITEM_DIMENSION, PART_NUMBER_DIMENSION, SUPPORT_ACTION_DIMENSION, and PRODUCT_DIMENSION.

Entity Relationships for the FULFILLMENT_FACT Table

Although the connections are not shown, here, the LINE_ITEM_DATES and LINE_ITEM_USERS tables link to the LINE_ITEM_DIMENSION table. LINE_ITEM_DATES also links to the TIME_DIMENSION table. Likewise, LINE_ITEM_USERS also links to the USER_DIMENSION table. In addition, the FULFILLMENT_DATES table links to the FULFILLMENT_DIMENSION and to the TIME_DIMENSION.

See FULFILLMENT_FACT for details on all the columns in the FULFILLMENT_FACT table.