Tutorial - Fact contract details
Table Name | fact_contract_details |
|---|---|
Description | Details on contract relatioships with other concept + Calculated enrichment |
_EMP | X |
_CUS | X |
_CAR | X |
_CON | X |
_SHO | X |
Content
Field name | Data Type | Description |
|---|---|---|
contract_id | string | Reference to the contract Dimension |
employee_id | string | Reference to the employee Dimension |
car_id | string | Reference to the car Dimension |
customer_id | string | Reference to the customer Dimension |
shop_id | string | Reference to the shop Dimension (through link employee_shop) |
contract_total_amount | number | = dim_cars.car_unit_price * (1 - dim_contracts.contract_discount) |
contract_employee _commission | number | = dim_cars.car_unit_price * (1 - dim_contracts.contract_discount) * 0,2 |
contract_manager_commission | number | = dim_cars.car_unit_price * (1 - dim_contracts.contract_discount) * 0,05 |
snapshot_date | datetime | Reference to the Point in Time Dimension |