Miscellany

select f.time_id, f.customer_id, f.dealer_id, f.region_id,
f.product_id, f.cell_site_id, f.contract_type_id,
f.call_category_id, f.call_type_id, f.call_mode_id,
f.operator_id, f.time_of_the_day_id,
sum(f.air_time_minutes),
sum(f.air_time_units),
sum(f.air_time_amount),
sum(f.ic_units),
sum(f.ic_amount) 
from fact_stg f,
time_dim tim, customer_dim cust, dealer_dim dea, region_dim reg,
product_dim pro, cell_site_dim cesi, contract_type_dim ctype,
call_category_dim cat, call_type_dim typ, call_mode_dim mode,
operator_dim opr, time_of_the_day_dim tod
where
f.time_id=tim.time_id and f.customer_id=cust.customer_id and f.dealer_id=dea.dealer_id 
and f.region_id=reg.region_id and
f.product_id=pro.product_id and f.cell_site_id=cesi.cell_site_id 
and f.contract_type_id=ctype.contract_type_id and
f.call_category_id=cat.call_category_id and f.call_type_id=typ.call_type_id 
and f.call_mode_id=mod.call_mode_id and
f.operator_id=opr.operator_id and f.time_of_the_day_id=tod.time_of_the_day_id
group by
f.time_id, f.customer_id, f.dealer_id, f.region_id,
f.product_id, f.cell_site_id, f.contract_type_id,
f.call_category_id, f.call_type_id, f.call_mode_id,
f.operator_id, f.time_of_the_day_id;