Untitled

INSERT INTO FINANCE_FACT (
COUNTRY_ID, 
[YEAR],
[MONTH],
PRODUCTION_COST,
EMPLOYEE_COST, 
EARNS, 
BENEFICE_NET )

SELECT COUNTRY_MULTILINGUAL.COUNTRY_CODE,
 DatePart("yyyy",[ORDER_HEADER.ORDER_DATE]),
 DatePart("m",[ORDER_HEADER.ORDER_DATE]),
 sum(ORDER_DETAILS.QUANTITY*ORDER_DETAILS.UNIT_COST),
 sum(EMPLOYEE_DETAIL_FACT.SALARY+EMPLOYEE_DETAIL_FACT.BONUS),
 sum(ORDER_DETAILS.QUANTITY*(ORDER_DETAILS.UNIT_SALE_PRICE-ORDER_DETAILS.UNIT_COST)),
 sum(ORDER_DETAILS.QUANTITY*(ORDER_DETAILS.UNIT_SALE_PRICE-ORDER_DETAILS.UNIT_COST))-(SALARY_TABLE.BONUS+SALARY_TABLE.SALARY)*2/12

FROM COUNTRY_MULTILINGUAL,
 ORDER_HEADER,
 ORDER_DETAILS,
 EMPLOYEE_DETAIL_FACT,
 SALES_BRANCH,
 COUNTRY,
 STAFF_DIMENSION,
 SALES_STAFF,
 SALARY_TABLE

WHERE ( ORDER_HEADER.SALES_BRANCH_CODE = SALES_BRANCH.SALES_BRANCH_CODE  )
  AND  ( ORDER_DETAILS.ORDER_NUMBER = ORDER_HEADER.ORDER_NUMBER  )
  AND  ( COUNTRY.COUNTRY_CODE = COUNTRY_MULTILINGUAL.COUNTRY_CODE  )
  AND  ( SALES_BRANCH.SALES_BRANCH_CODE = SALES_STAFF.SALES_BRANCH_CODE  )
  AND  ( SALES_BRANCH.COUNTRY_CODE = COUNTRY.COUNTRY_CODE  )
  AND  ( SALES_STAFF.SALES_STAFF_CODE = STAFF_DIMENSION.SALES_STAFF_CODE  )
  AND  ( STAFF_DIMENSION.STAFF_KEY = EMPLOYEE_DETAIL_FACT.STAFF_KEY  )
  AND  ( (SALARY_TABLE.DAY_KEY-0101)/10000 = DatePart("yyyy",[ORDER_HEADER.ORDER_DATE]) )

GROUP BY COUNTRY_MULTILINGUAL.COUNTRY_CODE,
 DatePart("yyyy",[ORDER_HEADER.ORDER_DATE]),
 DatePart("m",[ORDER_HEADER.ORDER_DATE]),
SALARY_TABLE.BONUS,SALARY_TABLE.SALARY

;















INSERT INTO FINANCE_FACT (
COUNTRY_ID, 
[YEAR],
[MONTH],
PRODUCTION_COST,
EMPLOYEE_COST, 
EARNS, 
BENEFICE_NET )

SELECT COUNTRY_MULTILINGUAL.COUNTRY_CODE,
 DatePart("yyyy",[ORDER_HEADER.ORDER_DATE]),
 DatePart("m",[ORDER_HEADER.ORDER_DATE]),
 sum(ORDER_DETAILS.QUANTITY*ORDER_DETAILS.UNIT_COST),
 sum(EMPLOYEE_DETAIL_FACT.SALARY+EMPLOYEE_DETAIL_FACT.BONUS),
 sum(ORDER_DETAILS.QUANTITY*(ORDER_DETAILS.UNIT_SALE_PRICE-ORDER_DETAILS.UNIT_COST)),
 sum(ORDER_DETAILS.QUANTITY*(ORDER_DETAILS.UNIT_SALE_PRICE-ORDER_DETAILS.UNIT_COST))-SUM(salary_table.bonus+salary_table.salary)*2/12

FROM COUNTRY_MULTILINGUAL,
 ORDER_HEADER,
 ORDER_DETAILS,
 EMPLOYEE_DETAIL_FACT,
 SALES_BRANCH,
 COUNTRY,
 STAFF_DIMENSION,
 SALES_STAFF,
 SALARY_TABLE

WHERE ( ORDER_HEADER.SALES_BRANCH_CODE = SALES_BRANCH.SALES_BRANCH_CODE  )
  AND  ( ORDER_DETAILS.ORDER_NUMBER = ORDER_HEADER.ORDER_NUMBER  )
  AND  ( COUNTRY.COUNTRY_CODE = COUNTRY_MULTILINGUAL.COUNTRY_CODE  )
  AND  ( SALES_BRANCH.SALES_BRANCH_CODE = SALES_STAFF.SALES_BRANCH_CODE  )
  AND  ( SALES_BRANCH.COUNTRY_CODE = COUNTRY.COUNTRY_CODE  )
  AND  ( SALES_STAFF.SALES_STAFF_CODE = STAFF_DIMENSION.SALES_STAFF_CODE  )
  AND  ( STAFF_DIMENSION.STAFF_KEY = EMPLOYEE_DETAIL_FACT.STAFF_KEY  )
  AND  ( (SALARY_TABLE.DAY_KEY-0101)/10000 = DatePart("yyyy",[ORDER_HEADER.ORDER_DATE]) )

GROUP BY COUNTRY_MULTILINGUAL.COUNTRY_CODE,
 DatePart("yyyy",[ORDER_HEADER.ORDER_DATE]),
 DatePart("m",[ORDER_HEADER.ORDER_DATE]),

;