|
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 |