1> set showplan debug
2> go
(0 rows affected)
1> SELECT trans_year,
2> cast(sum(num_items_net) / count(distinct case when  order_pub_comm_base >= 0 then orderid end) as double)  as net_items_per_order
3> FROM ActivityAdvertiserTransDate WHERE trans_date_key>='2015-01-01' AND trans_date_key<='2015-01-01' 
4> AND advertiser_key=111 GROUP BY trans_year, trans_date_key
5> limit 1
6> go
 trans_year net_items_per_order
 ---------- -------------------
       2015                 NaN
1> show plan
2> go
 PLAN_TEXT                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              PLAN_XML                                 DEBUG_LOG
 -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------- -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 AccessNode    + Relational Node ID:1    + Output Columns:      0: trans_year (integer)      1: net_items_per_order (double)    + Statistics:      0: Node Output Rows: 1      1: Node Next Batch Process Time: 0      2: Node Cumulative Next Batch Process Time: 0      3: Node Cumulative Process Time: 1421      4: Node Next Batch Calls: 2      5: Node Blocks: 1    + Cost Estimates:Estimated Node Cardinality: 1.0    + Query:SELECT g_1.year_name AS c_0, convert((SUM(g_0.num_items_net) / convert(COUNT(DISTINCT CASE WHEN g_0.order_pub_comm_base >= 0 THEN g_0.orderid END), long)), double) AS c_1 FROM fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date AS g_0 INNER JOIN fact_activity_advertiser_trans_date.dim_date AS g_1 ON g_0.trans_date_key = g_1.date_key WHERE (g_0.trans_date_key >= '2015-01-01') AND (g_0.trans_date_key <= '2015-01-01') AND (g_0.advertiser_key = 111) AND (g_1.date_key >= '2015-01-01') AND (g_1.date_key <= '2015-01-01') GROUP BY g_1.year_name, g_0.trans_date_key LIMIT 1    + Model Name:fact_activity_advertiser_trans_date    + Data Bytes Sent:26    + Planning Time:7   org.teiid.core.types.SQLXMLImpl@511a671f   ============================================================================  USER COMMAND:  SELECT ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_year, convert((SUM(ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.num_items_net) / convert(COUNT(DISTINCT CASE WHEN ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.order_pub_comm_base >= 0 THEN ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.orderid END), long)), double) AS net_items_per_order FROM ActivityAdvertiserTransDate.ActivityAdvertiserTransDate WHERE (ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_date_key >= '2015-01-01') AND (ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_date_key <= '2015-01-01') AND (ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.advertiser_key = 111) GROUP BY ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_year, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_date_key LIMIT 1    ----------------------------------------------------------------------------  OPTIMIZE:   SELECT ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_year, convert((SUM(ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.num_items_net) / convert(COUNT(DISTINCT CASE WHEN ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.order_pub_comm_base >= 0 THEN ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.orderid END), long)), double) AS net_items_per_order FROM ActivityAdvertiserTransDate.ActivityAdvertiserTransDate WHERE (ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_date_key >= '2015-01-01') AND (ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_date_key <= '2015-01-01') AND (ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.advertiser_key = 111) GROUP BY ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_year, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_date_key LIMIT 1    ----------------------------------------------------------------------------  GENERATE CANONICAL:   SELECT ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_year, convert((SUM(ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.num_items_net) / convert(COUNT(DISTINCT CASE WHEN ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.order_pub_comm_base >= 0 THEN ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.orderid END), long)), double) AS net_items_per_order FROM ActivityAdvertiserTransDate.ActivityAdvertiserTransDate WHERE (ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_date_key >= '2015-01-01') AND (ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_date_key <= '2015-01-01') AND (ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.advertiser_key = 111) GROUP BY ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_year, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_date_key LIMIT 1    CANONICAL PLAN:   TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=1})    Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol0 AS trans_year, convert((anon_grp0.agg0 / convert(anon_grp0.agg1, long)), double) AS net_items_per_order]})      Group(groups=[ActivityAdvertiserTransDate.ActivityAdvertiserTransDate, anon_grp0], props={GROUP_COLS=[ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_year, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_date_key], SYMBOL_MAP={anon_grp0.gcol0=ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_year, anon_grp0.gcol1=ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_date_key, anon_grp0.agg0=SUM(ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.num_items_net), anon_grp0.agg1=COUNT(DISTINCT CASE WHEN ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.order_pub_comm_base >= 0 THEN ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.orderid END)}})        Select(groups=[ActivityAdvertiserTransDate.ActivityAdvertiserTransDate], props={SELECT_CRITERIA=ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.advertiser_key = 111})          Select(groups=[ActivityAdvertiserTransDate.ActivityAdvertiserTransDate], props={SELECT_CRITERIA=ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_date_key <= '2015-01-01'})            Select(groups=[ActivityAdvertiserTransDate.ActivityAdvertiserTransDate], props={SELECT_CRITERIA=ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_date_key >= '2015-01-01'})              Source(groups=[ActivityAdvertiserTransDate.ActivityAdvertiserTransDate], props={NESTED_COMMAND=SELECT fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_impressions, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_clicks, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.est_click_comm, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.sales, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.quantity, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_items, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_items_cancel, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_items_net, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.pub_comm_adj, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.pub_comm_base, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.pub_comm_base_totl, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.pub_comm_totl, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.pub_comm_totl_w_click, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.pub_comm_gross, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.pub_comm_gross_totl, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.rktn_comm_totl, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.sales_gross, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.sales_returned, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.publisher_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.network_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key, fact_activity_advertiser_trans_date.dim_advertiser.advertiser_name, fact_activity_advertiser_trans_date.dim_advertiser.advertiser_primary_industry, fact_activity_advertiser_trans_date.dim_advertiser.advertiser_secondary_industry, CASE WHEN left(fact_activity_advertiser_trans_date.dim_advertiser.advertiser_name, 3) = '{*}' THEN FALSE ELSE TRUE END AS advertiser_is_active, fact_activity_advertiser_trans_date.dim_network.network_name, fact_activity_advertiser_trans_date.dim_network.network_cancellation_window, fact_activity_advertiser_trans_date.dim_network.network_locale, fact_activity_advertiser_trans_date.dim_publisher.publisher_secondary_industry, fact_activity_advertiser_trans_date.dim_publisher.publisher_primary_industry, fact_activity_advertiser_trans_date.dim_publisher.publisher_encr_id, fact_activity_advertiser_trans_date.dim_publisher.publisher_url, fact_activity_advertiser_trans_date.dim_publisher.publisher_tertiary_industry, fact_activity_advertiser_trans_date.dim_publisher.publisher_name, fact_activity_advertiser_trans_date.dim_date.year_name AS trans_year, fact_activity_advertiser_trans_date.dim_date.month_num AS trans_month, fact_activity_advertiser_trans_date.dim_date.month_name AS trans_month_name, fact_activity_advertiser_trans_date.dim_date.day_num AS trans_day_num, fact_activity_advertiser_trans_date.dim_date.day_name AS trans_day_name, fact_activity_advertiser_trans_date.dim_date.week_day_num AS trans_week_day_num, fact_activity_advertiser_trans_date.dim_date.week_num AS trans_week_num, fact_activity_advertiser_trans_date.dim_date.week_name AS trans_week_name, fact_activity_advertiser_trans_date.dim_date.week_begin_date AS trans_week_begin_date, fact_activity_advertiser_trans_date.dim_date.week_end_date AS trans_week_end_date, concat(concat(LPAD(convert(fact_activity_advertiser_trans_date.dim_date.month_num, string), 2, '0'), '-'), LPAD(convert(fact_activity_advertiser_trans_date.dim_date.day_num, string), 2, '0')) AS trans_month_day, concat(concat(LPAD(convert(fact_activity_advertiser_trans_date.dim_date.month_num, string), 2, '0'), '-'), convert(fact_activity_advertiser_trans_date.dim_date.year_name, string)) AS trans_month_year, fact_activity_advertiser_trans_date.dim_date.last_year_date_key AS trans_last_year_date_key, fact_activity_advertiser_trans_date.dim_date.last_month_date_key AS trans_last_month_date_key, fact_activity_advertiser_trans_date.dim_date.last_week_date_key AS trans_last_week_date_key, fact_activity_advertiser_trans_date.dim_date.yesterday_date_key AS trans_yesterday_date_key, fact_activity_advertiser_trans_date.dim_publisher_group.publisher_group_name, fact_activity_advertiser_trans_date.dim_publisher_group.publisher_group_id, fact_activity_advertiser_trans_date.dim_group_mid.group_id, fact_activity_advertiser_trans_date.dim_creative_type.creative_type_name, fact_activity_advertiser_trans_date.dim_offer.offer_name, fact_activity_advertiser_trans_date.dim_offer.group_offer_key, fact_activity_advertiser_trans_date.dim_offer.group_offer_name, fact_activity_advertiser_trans_date.dim_offer.group_offer_id, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.orderid, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.order_pub_comm_base, fact_activity_advertiser_trans_date.ref_click_comm.cpc_comm, (CASE WHEN convert(fact_activity_advertiser_trans_date.ref_click_comm.cpc_comm, double) IS NOT NULL THEN (convert(fact_activity_advertiser_trans_date.ref_click_comm.cpc_comm, double) * ifnull(convert(fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_clicks, double), 0.0)) ELSE 0.0 END + ifnull(convert(fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.pub_comm_totl, double), 0.0)) AS cpc_comm_calc, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.offer_key, fact_activity_advertiser_trans_date.dim_network.network_currency, fact_activity_advertiser_trans_date.dim_publisher.publisher_category, fact_activity_advertiser_trans_date.dim_publisher.publisher_joindate FROM ((((((((fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date LEFT OUTER JOIN /*+ optional */ fact_activity_advertiser_trans_date.dim_publisher_group ON fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key = fact_activity_advertiser_trans_date.dim_publisher_group.advertiser_key AND fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.publisher_key = fact_activity_advertiser_trans_date.dim_publisher_group.publisher_key) LEFT OUTER JOIN /*+ optional */ fact_activity_advertiser_trans_date.dim_group_mid ON convert(fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key, string) = fact_activity_advertiser_trans_date.dim_group_mid.mid) INNER JOIN /*+ optional */ fact_activity_advertiser_trans_date.dim_advertiser ON fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key = fact_activity_advertiser_trans_date.dim_advertiser.advertiser_key) INNER JOIN /*+ optional */ fact_activity_advertiser_trans_date.dim_network ON convert(fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.network_key, long) = fact_activity_advertiser_trans_date.dim_network.network_key) INNER JOIN /*+ optional */ fact_activity_advertiser_trans_date.dim_publisher ON fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.publisher_key = fact_activity_advertiser_trans_date.dim_publisher.publisher_key) INNER JOIN /*+ optional */ fact_activity_advertiser_trans_date.dim_date ON fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key = fact_activity_advertiser_trans_date.dim_date.date_key) INNER JOIN /*+ optional */ fact_activity_advertiser_trans_date.dim_creative_type ON fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.creative_type_key = convert(fact_activity_advertiser_trans_date.dim_creative_type.creative_type_key, long)) INNER JOIN /*+ optional */ fact_activity_advertiser_trans_date.dim_offer ON fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.offer_key = fact_activity_advertiser_trans_date.dim_offer.offer_key) LEFT OUTER JOIN /*+ optional */ fact_activity_advertiser_trans_date.ref_click_comm ON fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.offer_key = fact_activity_advertiser_trans_date.ref_click_comm.offer_key AND fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.publisher_key = fact_activity_advertiser_trans_date.ref_click_comm.publisher_key AND fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key = fact_activity_advertiser_trans_date.ref_click_comm.advertiser_key AND fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key >= fact_activity_advertiser_trans_date.ref_click_comm.click_month_start_date_key AND fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key <= fact_activity_advertiser_trans_date.ref_click_comm.click_month_end_date_key, SYMBOL_MAP={ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.num_impressions=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_impressions, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.num_clicks=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_clicks, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.est_click_comm=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.est_click_comm, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.sales=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.sales, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.quantity=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.quantity, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.num_items=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_items, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.num_items_cancel=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_items_cancel, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.num_items_net=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_items_net, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.pub_comm_adj=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.pub_comm_adj, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.pub_comm_base=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.pub_comm_base, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.pub_comm_base_totl=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.pub_comm_base_totl, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.pub_comm_totl=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.pub_comm_totl, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.pub_comm_totl_w_click=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.pub_comm_totl_w_click, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.pub_comm_gross=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.pub_comm_gross, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.pub_comm_gross_totl=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.pub_comm_gross_totl, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.rktn_comm_totl=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.rktn_comm_totl, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.sales_gross=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.sales_gross, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.sales_returned=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.sales_returned, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.publisher_key=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.publisher_key, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.network_key=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.network_key, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_date_key=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.advertiser_key=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.advertiser_name=fact_activity_advertiser_trans_date.dim_advertiser.advertiser_name, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.advertiser_primary_industry=fact_activity_advertiser_trans_date.dim_advertiser.advertiser_primary_industry, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.advertiser_secondary_industry=fact_activity_advertiser_trans_date.dim_advertiser.advertiser_secondary_industry, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.advertiser_is_active=CASE WHEN left(fact_activity_advertiser_trans_date.dim_advertiser.advertiser_name, 3) = '{*}' THEN FALSE ELSE TRUE END, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.network_name=fact_activity_advertiser_trans_date.dim_network.network_name, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.network_cancellation_window=fact_activity_advertiser_trans_date.dim_network.network_cancellation_window, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.network_locale=fact_activity_advertiser_trans_date.dim_network.network_locale, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.publisher_secondary_industry=fact_activity_advertiser_trans_date.dim_publisher.publisher_secondary_industry, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.publisher_primary_industry=fact_activity_advertiser_trans_date.dim_publisher.publisher_primary_industry, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.publisher_encr_id=fact_activity_advertiser_trans_date.dim_publisher.publisher_encr_id, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.publisher_url=fact_activity_advertiser_trans_date.dim_publisher.publisher_url, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.publisher_tertiary_industry=fact_activity_advertiser_trans_date.dim_publisher.publisher_tertiary_industry, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.publisher_name=fact_activity_advertiser_trans_date.dim_publisher.publisher_name, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_year=fact_activity_advertiser_trans_date.dim_date.year_name, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_month=fact_activity_advertiser_trans_date.dim_date.month_num, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_month_name=fact_activity_advertiser_trans_date.dim_date.month_name, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_day_num=fact_activity_advertiser_trans_date.dim_date.day_num, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_day_name=fact_activity_advertiser_trans_date.dim_date.day_name, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_week_day_num=fact_activity_advertiser_trans_date.dim_date.week_day_num, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_week_num=fact_activity_advertiser_trans_date.dim_date.week_num, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_week_name=fact_activity_advertiser_trans_date.dim_date.week_name, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_week_begin_date=fact_activity_advertiser_trans_date.dim_date.week_begin_date, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_week_end_date=fact_activity_advertiser_trans_date.dim_date.week_end_date, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_month_day=concat(concat(LPAD(convert(fact_activity_advertiser_trans_date.dim_date.month_num, string), 2, '0'), '-'), LPAD(convert(fact_activity_advertiser_trans_date.dim_date.day_num, string), 2, '0')), ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_month_year=concat(concat(LPAD(convert(fact_activity_advertiser_trans_date.dim_date.month_num, string), 2, '0'), '-'), convert(fact_activity_advertiser_trans_date.dim_date.year_name, string)), ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_last_year_date_key=fact_activity_advertiser_trans_date.dim_date.last_year_date_key, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_last_month_date_key=fact_activity_advertiser_trans_date.dim_date.last_month_date_key, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_last_week_date_key=fact_activity_advertiser_trans_date.dim_date.last_week_date_key, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_yesterday_date_key=fact_activity_advertiser_trans_date.dim_date.yesterday_date_key, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.publisher_group_name=fact_activity_advertiser_trans_date.dim_publisher_group.publisher_group_name, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.publisher_group_id=fact_activity_advertiser_trans_date.dim_publisher_group.publisher_group_id, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.group_id=fact_activity_advertiser_trans_date.dim_group_mid.group_id, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.creative_type_name=fact_activity_advertiser_trans_date.dim_creative_type.creative_type_name, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.offer_name=fact_activity_advertiser_trans_date.dim_offer.offer_name, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.group_offer_key=fact_activity_advertiser_trans_date.dim_offer.group_offer_key, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.group_offer_name=fact_activity_advertiser_trans_date.dim_offer.group_offer_name, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.group_offer_id=fact_activity_advertiser_trans_date.dim_offer.group_offer_id, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.orderid=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.orderid, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.order_pub_comm_base=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.order_pub_comm_base, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.cpc_comm=fact_activity_advertiser_trans_date.ref_click_comm.cpc_comm, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.cpc_comm_calc=(CASE WHEN convert(fact_activity_advertiser_trans_date.ref_click_comm.cpc_comm, double) IS NOT NULL THEN (convert(fact_activity_advertiser_trans_date.ref_click_comm.cpc_comm, double) * ifnull(convert(fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_clicks, double), 0.0)) ELSE 0.0 END + ifnull(convert(fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.pub_comm_totl, double), 0.0)), ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.offer_key=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.offer_key, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.network_currency=fact_activity_advertiser_trans_date.dim_network.network_currency, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.publisher_category=fact_activity_advertiser_trans_date.dim_publisher.publisher_category, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.publisher_joindate=fact_activity_advertiser_trans_date.dim_publisher.publisher_joindate}})                Project(groups=[fact_activity_advertiser_trans_date.ref_click_comm, fact_activity_advertiser_trans_date.dim_publisher_group, fact_activity_advertiser_trans_date.dim_advertiser, fact_activity_advertiser_trans_date.dim_network, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, fact_activity_advertiser_trans_date.dim_creative_type, fact_activity_advertiser_trans_date.dim_group_mid, fact_activity_advertiser_trans_date.dim_date, fact_activity_advertiser_trans_date.dim_offer, fact_activity_advertiser_trans_date.dim_publisher], props={PROJECT_COLS=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_impressions, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_clicks, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.est_click_comm, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.sales, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.quantity, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_items, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_items_cancel, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_items_net, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.pub_comm_adj, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.pub_comm_base, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.pub_comm_base_totl, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.pub_comm_totl, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.pub_comm_totl_w_click, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.pub_comm_gross, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.pub_comm_gross_totl, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.rktn_comm_totl, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.sales_gross, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.sales_returned, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.publisher_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.network_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key, fact_activity_advertiser_trans_date.dim_advertiser.advertiser_name, fact_activity_advertiser_trans_date.dim_advertiser.advertiser_primary_industry, fact_activity_advertiser_trans_date.dim_advertiser.advertiser_secondary_industry, CASE WHEN left(fact_activity_advertiser_trans_date.dim_advertiser.advertiser_name, 3) = '{*}' THEN FALSE ELSE TRUE END AS advertiser_is_active, fact_activity_advertiser_trans_date.dim_network.network_name, fact_activity_advertiser_trans_date.dim_network.network_cancellation_window, fact_activity_advertiser_trans_date.dim_network.network_locale, fact_activity_advertiser_trans_date.dim_publisher.publisher_secondary_industry, fact_activity_advertiser_trans_date.dim_publisher.publisher_primary_industry, fact_activity_advertiser_trans_date.dim_publisher.publisher_encr_id, fact_activity_advertiser_trans_date.dim_publisher.publisher_url, fact_activity_advertiser_trans_date.dim_publisher.publisher_tertiary_industry, fact_activity_advertiser_trans_date.dim_publisher.publisher_name, fact_activity_advertiser_trans_date.dim_date.year_name AS trans_year, fact_activity_advertiser_trans_date.dim_date.month_num AS trans_month, fact_activity_advertiser_trans_date.dim_date.month_name AS trans_month_name, fact_activity_advertiser_trans_date.dim_date.day_num AS trans_day_num, fact_activity_advertiser_trans_date.dim_date.day_name AS trans_day_name, fact_activity_advertiser_trans_date.dim_date.week_day_num AS trans_week_day_num, fact_activity_advertiser_trans_date.dim_date.week_num AS trans_week_num, fact_activity_advertiser_trans_date.dim_date.week_name AS trans_week_name, fact_activity_advertiser_trans_date.dim_date.week_begin_date AS trans_week_begin_date, fact_activity_advertiser_trans_date.dim_date.week_end_date AS trans_week_end_date, concat(concat(LPAD(convert(fact_activity_advertiser_trans_date.dim_date.month_num, string), 2, '0'), '-'), LPAD(convert(fact_activity_advertiser_trans_date.dim_date.day_num, string), 2, '0')) AS trans_month_day, concat(concat(LPAD(convert(fact_activity_advertiser_trans_date.dim_date.month_num, string), 2, '0'), '-'), convert(fact_activity_advertiser_trans_date.dim_date.year_name, string)) AS trans_month_year, fact_activity_advertiser_trans_date.dim_date.last_year_date_key AS trans_last_year_date_key, fact_activity_advertiser_trans_date.dim_date.last_month_date_key AS trans_last_month_date_key, fact_activity_advertiser_trans_date.dim_date.last_week_date_key AS trans_last_week_date_key, fact_activity_advertiser_trans_date.dim_date.yesterday_date_key AS trans_yesterday_date_key, fact_activity_advertiser_trans_date.dim_publisher_group.publisher_group_name, fact_activity_advertiser_trans_date.dim_publisher_group.publisher_group_id, fact_activity_advertiser_trans_date.dim_group_mid.group_id, fact_activity_advertiser_trans_date.dim_creative_type.creative_type_name, fact_activity_advertiser_trans_date.dim_offer.offer_name, fact_activity_advertiser_trans_date.dim_offer.group_offer_key, fact_activity_advertiser_trans_date.dim_offer.group_offer_name, fact_activity_advertiser_trans_date.dim_offer.group_offer_id, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.orderid, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.order_pub_comm_base, fact_activity_advertiser_trans_date.ref_click_comm.cpc_comm, (CASE WHEN convert(fact_activity_advertiser_trans_date.ref_click_comm.cpc_comm, double) IS NOT NULL THEN (convert(fact_activity_advertiser_trans_date.ref_click_comm.cpc_comm, double) * ifnull(convert(fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_clicks, double), 0.0)) ELSE 0.0 END + ifnull(convert(fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.pub_comm_totl, double), 0.0)) AS cpc_comm_calc, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.offer_key, fact_activity_advertiser_trans_date.dim_network.network_currency, fact_activity_advertiser_trans_date.dim_publisher.publisher_category, fact_activity_advertiser_trans_date.dim_publisher.publisher_joindate]})                  Join(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, fact_activity_advertiser_trans_date.dim_publisher_group, fact_activity_advertiser_trans_date.dim_group_mid, fact_activity_advertiser_trans_date.dim_advertiser, fact_activity_advertiser_trans_date.dim_network, fact_activity_advertiser_trans_date.dim_publisher, fact_activity_advertiser_trans_date.dim_date, fact_activity_advertiser_trans_date.dim_creative_type, fact_activity_advertiser_trans_date.dim_offer, fact_activity_advertiser_trans_date.ref_click_comm], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.offer_key = fact_activity_advertiser_trans_date.ref_click_comm.offer_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.publisher_key = fact_activity_advertiser_trans_date.ref_click_comm.publisher_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key = fact_activity_advertiser_trans_date.ref_click_comm.advertiser_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key >= fact_activity_advertiser_trans_date.ref_click_comm.click_month_start_date_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key <= fact_activity_advertiser_trans_date.ref_click_comm.click_month_end_date_key]})                    Join(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, fact_activity_advertiser_trans_date.dim_publisher_group, fact_activity_advertiser_trans_date.dim_group_mid, fact_activity_advertiser_trans_date.dim_advertiser, fact_activity_advertiser_trans_date.dim_network, fact_activity_advertiser_trans_date.dim_publisher, fact_activity_advertiser_trans_date.dim_date, fact_activity_advertiser_trans_date.dim_creative_type, fact_activity_advertiser_trans_date.dim_offer], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.offer_key = fact_activity_advertiser_trans_date.dim_offer.offer_key]})                      Join(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, fact_activity_advertiser_trans_date.dim_publisher_group, fact_activity_advertiser_trans_date.dim_group_mid, fact_activity_advertiser_trans_date.dim_advertiser, fact_activity_advertiser_trans_date.dim_network, fact_activity_advertiser_trans_date.dim_publisher, fact_activity_advertiser_trans_date.dim_date, fact_activity_advertiser_trans_date.dim_creative_type], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.creative_type_key = convert(fact_activity_advertiser_trans_date.dim_creative_type.creative_type_key, long)]})                        Join(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, fact_activity_advertiser_trans_date.dim_publisher_group, fact_activity_advertiser_trans_date.dim_group_mid, fact_activity_advertiser_trans_date.dim_advertiser, fact_activity_advertiser_trans_date.dim_network, fact_activity_advertiser_trans_date.dim_publisher, fact_activity_advertiser_trans_date.dim_date], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key = fact_activity_advertiser_trans_date.dim_date.date_key]})                          Join(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, fact_activity_advertiser_trans_date.dim_publisher_group, fact_activity_advertiser_trans_date.dim_group_mid, fact_activity_advertiser_trans_date.dim_advertiser, fact_activity_advertiser_trans_date.dim_network, fact_activity_advertiser_trans_date.dim_publisher], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.publisher_key = fact_activity_advertiser_trans_date.dim_publisher.publisher_key]})                            Join(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, fact_activity_advertiser_trans_date.dim_publisher_group, fact_activity_advertiser_trans_date.dim_group_mid, fact_activity_advertiser_trans_date.dim_advertiser, fact_activity_advertiser_trans_date.dim_network], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[convert(fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.network_key, long) = fact_activity_advertiser_trans_date.dim_network.network_key]})                              Join(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, fact_activity_advertiser_trans_date.dim_publisher_group, fact_activity_advertiser_trans_date.dim_group_mid, fact_activity_advertiser_trans_date.dim_advertiser], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key = fact_activity_advertiser_trans_date.dim_advertiser.advertiser_key]})                                Join(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, fact_activity_advertiser_trans_date.dim_publisher_group, fact_activity_advertiser_trans_date.dim_group_mid], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[convert(fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key, string) = fact_activity_advertiser_trans_date.dim_group_mid.mid]})                                  Join(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, fact_activity_advertiser_trans_date.dim_publisher_group], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key = fact_activity_advertiser_trans_date.dim_publisher_group.advertiser_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.publisher_key = fact_activity_advertiser_trans_date.dim_publisher_group.publisher_key]})                                    Source(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date])                                    Source(groups=[fact_activity_advertiser_trans_date.dim_publisher_group], props={IS_OPTIONAL=true})                                  Source(groups=[fact_activity_advertiser_trans_date.dim_group_mid], props={IS_OPTIONAL=true})                                Source(groups=[fact_activity_advertiser_trans_date.dim_advertiser], props={IS_OPTIONAL=true})                              Source(groups=[fact_activity_advertiser_trans_date.dim_network], props={IS_OPTIONAL=true})                            Source(groups=[fact_activity_advertiser_trans_date.dim_publisher], props={IS_OPTIONAL=true})                          Source(groups=[fact_activity_advertiser_trans_date.dim_date], props={IS_OPTIONAL=true})                        Source(groups=[fact_activity_advertiser_trans_date.dim_creative_type], props={IS_OPTIONAL=true})                      Source(groups=[fact_activity_advertiser_trans_date.dim_offer], props={IS_OPTIONAL=true})                    Source(groups=[fact_activity_advertiser_trans_date.ref_click_comm], props={IS_OPTIONAL=true})      ============================================================================  EXECUTING PlaceAccess    AFTER:   TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=1})    Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol0 AS trans_year, convert((anon_grp0.agg0 / convert(anon_grp0.agg1, long)), double) AS net_items_per_order]})      Group(groups=[ActivityAdvertiserTransDate.ActivityAdvertiserTransDate, anon_grp0], props={GROUP_COLS=[ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_year, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_date_key], SYMBOL_MAP={anon_grp0.gcol0=ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_year, anon_grp0.gcol1=ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_date_key, anon_grp0.agg0=SUM(ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.num_items_net), anon_grp0.agg1=COUNT(DISTINCT CASE WHEN ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.order_pub_comm_base >= 0 THEN ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.orderid END)}})        Select(groups=[ActivityAdvertiserTransDate.ActivityAdvertiserTransDate], props={SELECT_CRITERIA=ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.advertiser_key = 111})          Select(groups=[ActivityAdvertiserTransDate.ActivityAdvertiserTransDate], props={SELECT_CRITERIA=ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_date_key <= '2015-01-01'})            Select(groups=[ActivityAdvertiserTransDate.ActivityAdvertiserTransDate], props={SELECT_CRITERIA=ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_date_key >= '2015-01-01'})              Source(groups=[ActivityAdvertiserTransDate.ActivityAdvertiserTransDate], props={NESTED_COMMAND=SELECT fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_impressions, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_clicks, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.est_click_comm, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.sales, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.quantity, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_items, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_items_cancel, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_items_net, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.pub_comm_adj, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.pub_comm_base, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.pub_comm_base_totl, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.pub_comm_totl, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.pub_comm_totl_w_click, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.pub_comm_gross, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.pub_comm_gross_totl, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.rktn_comm_totl, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.sales_gross, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.sales_returned, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.publisher_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.network_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key, fact_activity_advertiser_trans_date.dim_advertiser.advertiser_name, fact_activity_advertiser_trans_date.dim_advertiser.advertiser_primary_industry, fact_activity_advertiser_trans_date.dim_advertiser.advertiser_secondary_industry, CASE WHEN left(fact_activity_advertiser_trans_date.dim_advertiser.advertiser_name, 3) = '{*}' THEN FALSE ELSE TRUE END AS advertiser_is_active, fact_activity_advertiser_trans_date.dim_network.network_name, fact_activity_advertiser_trans_date.dim_network.network_cancellation_window, fact_activity_advertiser_trans_date.dim_network.network_locale, fact_activity_advertiser_trans_date.dim_publisher.publisher_secondary_industry, fact_activity_advertiser_trans_date.dim_publisher.publisher_primary_industry, fact_activity_advertiser_trans_date.dim_publisher.publisher_encr_id, fact_activity_advertiser_trans_date.dim_publisher.publisher_url, fact_activity_advertiser_trans_date.dim_publisher.publisher_tertiary_industry, fact_activity_advertiser_trans_date.dim_publisher.publisher_name, fact_activity_advertiser_trans_date.dim_date.year_name AS trans_year, fact_activity_advertiser_trans_date.dim_date.month_num AS trans_month, fact_activity_advertiser_trans_date.dim_date.month_name AS trans_month_name, fact_activity_advertiser_trans_date.dim_date.day_num AS trans_day_num, fact_activity_advertiser_trans_date.dim_date.day_name AS trans_day_name, fact_activity_advertiser_trans_date.dim_date.week_day_num AS trans_week_day_num, fact_activity_advertiser_trans_date.dim_date.week_num AS trans_week_num, fact_activity_advertiser_trans_date.dim_date.week_name AS trans_week_name, fact_activity_advertiser_trans_date.dim_date.week_begin_date AS trans_week_begin_date, fact_activity_advertiser_trans_date.dim_date.week_end_date AS trans_week_end_date, concat(concat(LPAD(convert(fact_activity_advertiser_trans_date.dim_date.month_num, string), 2, '0'), '-'), LPAD(convert(fact_activity_advertiser_trans_date.dim_date.day_num, string), 2, '0')) AS trans_month_day, concat(concat(LPAD(convert(fact_activity_advertiser_trans_date.dim_date.month_num, string), 2, '0'), '-'), convert(fact_activity_advertiser_trans_date.dim_date.year_name, string)) AS trans_month_year, fact_activity_advertiser_trans_date.dim_date.last_year_date_key AS trans_last_year_date_key, fact_activity_advertiser_trans_date.dim_date.last_month_date_key AS trans_last_month_date_key, fact_activity_advertiser_trans_date.dim_date.last_week_date_key AS trans_last_week_date_key, fact_activity_advertiser_trans_date.dim_date.yesterday_date_key AS trans_yesterday_date_key, fact_activity_advertiser_trans_date.dim_publisher_group.publisher_group_name, fact_activity_advertiser_trans_date.dim_publisher_group.publisher_group_id, fact_activity_advertiser_trans_date.dim_group_mid.group_id, fact_activity_advertiser_trans_date.dim_creative_type.creative_type_name, fact_activity_advertiser_trans_date.dim_offer.offer_name, fact_activity_advertiser_trans_date.dim_offer.group_offer_key, fact_activity_advertiser_trans_date.dim_offer.group_offer_name, fact_activity_advertiser_trans_date.dim_offer.group_offer_id, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.orderid, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.order_pub_comm_base, fact_activity_advertiser_trans_date.ref_click_comm.cpc_comm, (CASE WHEN convert(fact_activity_advertiser_trans_date.ref_click_comm.cpc_comm, double) IS NOT NULL THEN (convert(fact_activity_advertiser_trans_date.ref_click_comm.cpc_comm, double) * ifnull(convert(fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_clicks, double), 0.0)) ELSE 0.0 END + ifnull(convert(fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.pub_comm_totl, double), 0.0)) AS cpc_comm_calc, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.offer_key, fact_activity_advertiser_trans_date.dim_network.network_currency, fact_activity_advertiser_trans_date.dim_publisher.publisher_category, fact_activity_advertiser_trans_date.dim_publisher.publisher_joindate FROM ((((((((fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date LEFT OUTER JOIN /*+ optional */ fact_activity_advertiser_trans_date.dim_publisher_group ON fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key = fact_activity_advertiser_trans_date.dim_publisher_group.advertiser_key AND fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.publisher_key = fact_activity_advertiser_trans_date.dim_publisher_group.publisher_key) LEFT OUTER JOIN /*+ optional */ fact_activity_advertiser_trans_date.dim_group_mid ON convert(fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key, string) = fact_activity_advertiser_trans_date.dim_group_mid.mid) INNER JOIN /*+ optional */ fact_activity_advertiser_trans_date.dim_advertiser ON fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key = fact_activity_advertiser_trans_date.dim_advertiser.advertiser_key) INNER JOIN /*+ optional */ fact_activity_advertiser_trans_date.dim_network ON convert(fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.network_key, long) = fact_activity_advertiser_trans_date.dim_network.network_key) INNER JOIN /*+ optional */ fact_activity_advertiser_trans_date.dim_publisher ON fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.publisher_key = fact_activity_advertiser_trans_date.dim_publisher.publisher_key) INNER JOIN /*+ optional */ fact_activity_advertiser_trans_date.dim_date ON fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key = fact_activity_advertiser_trans_date.dim_date.date_key) INNER JOIN /*+ optional */ fact_activity_advertiser_trans_date.dim_creative_type ON fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.creative_type_key = convert(fact_activity_advertiser_trans_date.dim_creative_type.creative_type_key, long)) INNER JOIN /*+ optional */ fact_activity_advertiser_trans_date.dim_offer ON fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.offer_key = fact_activity_advertiser_trans_date.dim_offer.offer_key) LEFT OUTER JOIN /*+ optional */ fact_activity_advertiser_trans_date.ref_click_comm ON fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.offer_key = fact_activity_advertiser_trans_date.ref_click_comm.offer_key AND fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.publisher_key = fact_activity_advertiser_trans_date.ref_click_comm.publisher_key AND fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key = fact_activity_advertiser_trans_date.ref_click_comm.advertiser_key AND fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key >= fact_activity_advertiser_trans_date.ref_click_comm.click_month_start_date_key AND fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key <= fact_activity_advertiser_trans_date.ref_click_comm.click_month_end_date_key, SYMBOL_MAP={ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.num_impressions=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_impressions, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.num_clicks=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_clicks, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.est_click_comm=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.est_click_comm, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.sales=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.sales, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.quantity=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.quantity, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.num_items=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_items, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.num_items_cancel=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_items_cancel, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.num_items_net=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_items_net, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.pub_comm_adj=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.pub_comm_adj, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.pub_comm_base=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.pub_comm_base, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.pub_comm_base_totl=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.pub_comm_base_totl, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.pub_comm_totl=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.pub_comm_totl, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.pub_comm_totl_w_click=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.pub_comm_totl_w_click, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.pub_comm_gross=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.pub_comm_gross, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.pub_comm_gross_totl=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.pub_comm_gross_totl, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.rktn_comm_totl=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.rktn_comm_totl, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.sales_gross=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.sales_gross, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.sales_returned=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.sales_returned, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.publisher_key=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.publisher_key, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.network_key=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.network_key, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_date_key=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.advertiser_key=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.advertiser_name=fact_activity_advertiser_trans_date.dim_advertiser.advertiser_name, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.advertiser_primary_industry=fact_activity_advertiser_trans_date.dim_advertiser.advertiser_primary_industry, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.advertiser_secondary_industry=fact_activity_advertiser_trans_date.dim_advertiser.advertiser_secondary_industry, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.advertiser_is_active=CASE WHEN left(fact_activity_advertiser_trans_date.dim_advertiser.advertiser_name, 3) = '{*}' THEN FALSE ELSE TRUE END, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.network_name=fact_activity_advertiser_trans_date.dim_network.network_name, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.network_cancellation_window=fact_activity_advertiser_trans_date.dim_network.network_cancellation_window, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.network_locale=fact_activity_advertiser_trans_date.dim_network.network_locale, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.publisher_secondary_industry=fact_activity_advertiser_trans_date.dim_publisher.publisher_secondary_industry, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.publisher_primary_industry=fact_activity_advertiser_trans_date.dim_publisher.publisher_primary_industry, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.publisher_encr_id=fact_activity_advertiser_trans_date.dim_publisher.publisher_encr_id, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.publisher_url=fact_activity_advertiser_trans_date.dim_publisher.publisher_url, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.publisher_tertiary_industry=fact_activity_advertiser_trans_date.dim_publisher.publisher_tertiary_industry, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.publisher_name=fact_activity_advertiser_trans_date.dim_publisher.publisher_name, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_year=fact_activity_advertiser_trans_date.dim_date.year_name, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_month=fact_activity_advertiser_trans_date.dim_date.month_num, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_month_name=fact_activity_advertiser_trans_date.dim_date.month_name, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_day_num=fact_activity_advertiser_trans_date.dim_date.day_num, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_day_name=fact_activity_advertiser_trans_date.dim_date.day_name, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_week_day_num=fact_activity_advertiser_trans_date.dim_date.week_day_num, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_week_num=fact_activity_advertiser_trans_date.dim_date.week_num, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_week_name=fact_activity_advertiser_trans_date.dim_date.week_name, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_week_begin_date=fact_activity_advertiser_trans_date.dim_date.week_begin_date, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_week_end_date=fact_activity_advertiser_trans_date.dim_date.week_end_date, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_month_day=concat(concat(LPAD(convert(fact_activity_advertiser_trans_date.dim_date.month_num, string), 2, '0'), '-'), LPAD(convert(fact_activity_advertiser_trans_date.dim_date.day_num, string), 2, '0')), ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_month_year=concat(concat(LPAD(convert(fact_activity_advertiser_trans_date.dim_date.month_num, string), 2, '0'), '-'), convert(fact_activity_advertiser_trans_date.dim_date.year_name, string)), ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_last_year_date_key=fact_activity_advertiser_trans_date.dim_date.last_year_date_key, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_last_month_date_key=fact_activity_advertiser_trans_date.dim_date.last_month_date_key, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_last_week_date_key=fact_activity_advertiser_trans_date.dim_date.last_week_date_key, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_yesterday_date_key=fact_activity_advertiser_trans_date.dim_date.yesterday_date_key, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.publisher_group_name=fact_activity_advertiser_trans_date.dim_publisher_group.publisher_group_name, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.publisher_group_id=fact_activity_advertiser_trans_date.dim_publisher_group.publisher_group_id, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.group_id=fact_activity_advertiser_trans_date.dim_group_mid.group_id, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.creative_type_name=fact_activity_advertiser_trans_date.dim_creative_type.creative_type_name, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.offer_name=fact_activity_advertiser_trans_date.dim_offer.offer_name, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.group_offer_key=fact_activity_advertiser_trans_date.dim_offer.group_offer_key, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.group_offer_name=fact_activity_advertiser_trans_date.dim_offer.group_offer_name, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.group_offer_id=fact_activity_advertiser_trans_date.dim_offer.group_offer_id, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.orderid=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.orderid, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.order_pub_comm_base=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.order_pub_comm_base, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.cpc_comm=fact_activity_advertiser_trans_date.ref_click_comm.cpc_comm, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.cpc_comm_calc=(CASE WHEN convert(fact_activity_advertiser_trans_date.ref_click_comm.cpc_comm, double) IS NOT NULL THEN (convert(fact_activity_advertiser_trans_date.ref_click_comm.cpc_comm, double) * ifnull(convert(fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_clicks, double), 0.0)) ELSE 0.0 END + ifnull(convert(fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.pub_comm_totl, double), 0.0)), ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.offer_key=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.offer_key, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.network_currency=fact_activity_advertiser_trans_date.dim_network.network_currency, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.publisher_category=fact_activity_advertiser_trans_date.dim_publisher.publisher_category, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.publisher_joindate=fact_activity_advertiser_trans_date.dim_publisher.publisher_joindate}})                Project(groups=[fact_activity_advertiser_trans_date.ref_click_comm, fact_activity_advertiser_trans_date.dim_publisher_group, fact_activity_advertiser_trans_date.dim_advertiser, fact_activity_advertiser_trans_date.dim_network, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, fact_activity_advertiser_trans_date.dim_creative_type, fact_activity_advertiser_trans_date.dim_group_mid, fact_activity_advertiser_trans_date.dim_date, fact_activity_advertiser_trans_date.dim_offer, fact_activity_advertiser_trans_date.dim_publisher], props={PROJECT_COLS=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_impressions, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_clicks, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.est_click_comm, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.sales, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.quantity, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_items, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_items_cancel, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_items_net, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.pub_comm_adj, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.pub_comm_base, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.pub_comm_base_totl, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.pub_comm_totl, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.pub_comm_totl_w_click, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.pub_comm_gross, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.pub_comm_gross_totl, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.rktn_comm_totl, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.sales_gross, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.sales_returned, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.publisher_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.network_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key, fact_activity_advertiser_trans_date.dim_advertiser.advertiser_name, fact_activity_advertiser_trans_date.dim_advertiser.advertiser_primary_industry, fact_activity_advertiser_trans_date.dim_advertiser.advertiser_secondary_industry, CASE WHEN left(fact_activity_advertiser_trans_date.dim_advertiser.advertiser_name, 3) = '{*}' THEN FALSE ELSE TRUE END AS advertiser_is_active, fact_activity_advertiser_trans_date.dim_network.network_name, fact_activity_advertiser_trans_date.dim_network.network_cancellation_window, fact_activity_advertiser_trans_date.dim_network.network_locale, fact_activity_advertiser_trans_date.dim_publisher.publisher_secondary_industry, fact_activity_advertiser_trans_date.dim_publisher.publisher_primary_industry, fact_activity_advertiser_trans_date.dim_publisher.publisher_encr_id, fact_activity_advertiser_trans_date.dim_publisher.publisher_url, fact_activity_advertiser_trans_date.dim_publisher.publisher_tertiary_industry, fact_activity_advertiser_trans_date.dim_publisher.publisher_name, fact_activity_advertiser_trans_date.dim_date.year_name AS trans_year, fact_activity_advertiser_trans_date.dim_date.month_num AS trans_month, fact_activity_advertiser_trans_date.dim_date.month_name AS trans_month_name, fact_activity_advertiser_trans_date.dim_date.day_num AS trans_day_num, fact_activity_advertiser_trans_date.dim_date.day_name AS trans_day_name, fact_activity_advertiser_trans_date.dim_date.week_day_num AS trans_week_day_num, fact_activity_advertiser_trans_date.dim_date.week_num AS trans_week_num, fact_activity_advertiser_trans_date.dim_date.week_name AS trans_week_name, fact_activity_advertiser_trans_date.dim_date.week_begin_date AS trans_week_begin_date, fact_activity_advertiser_trans_date.dim_date.week_end_date AS trans_week_end_date, concat(concat(LPAD(convert(fact_activity_advertiser_trans_date.dim_date.month_num, string), 2, '0'), '-'), LPAD(convert(fact_activity_advertiser_trans_date.dim_date.day_num, string), 2, '0')) AS trans_month_day, concat(concat(LPAD(convert(fact_activity_advertiser_trans_date.dim_date.month_num, string), 2, '0'), '-'), convert(fact_activity_advertiser_trans_date.dim_date.year_name, string)) AS trans_month_year, fact_activity_advertiser_trans_date.dim_date.last_year_date_key AS trans_last_year_date_key, fact_activity_advertiser_trans_date.dim_date.last_month_date_key AS trans_last_month_date_key, fact_activity_advertiser_trans_date.dim_date.last_week_date_key AS trans_last_week_date_key, fact_activity_advertiser_trans_date.dim_date.yesterday_date_key AS trans_yesterday_date_key, fact_activity_advertiser_trans_date.dim_publisher_group.publisher_group_name, fact_activity_advertiser_trans_date.dim_publisher_group.publisher_group_id, fact_activity_advertiser_trans_date.dim_group_mid.group_id, fact_activity_advertiser_trans_date.dim_creative_type.creative_type_name, fact_activity_advertiser_trans_date.dim_offer.offer_name, fact_activity_advertiser_trans_date.dim_offer.group_offer_key, fact_activity_advertiser_trans_date.dim_offer.group_offer_name, fact_activity_advertiser_trans_date.dim_offer.group_offer_id, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.orderid, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.order_pub_comm_base, fact_activity_advertiser_trans_date.ref_click_comm.cpc_comm, (CASE WHEN convert(fact_activity_advertiser_trans_date.ref_click_comm.cpc_comm, double) IS NOT NULL THEN (convert(fact_activity_advertiser_trans_date.ref_click_comm.cpc_comm, double) * ifnull(convert(fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_clicks, double), 0.0)) ELSE 0.0 END + ifnull(convert(fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.pub_comm_totl, double), 0.0)) AS cpc_comm_calc, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.offer_key, fact_activity_advertiser_trans_date.dim_network.network_currency, fact_activity_advertiser_trans_date.dim_publisher.publisher_category, fact_activity_advertiser_trans_date.dim_publisher.publisher_joindate]})                  Join(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, fact_activity_advertiser_trans_date.dim_publisher_group, fact_activity_advertiser_trans_date.dim_group_mid, fact_activity_advertiser_trans_date.dim_advertiser, fact_activity_advertiser_trans_date.dim_network, fact_activity_advertiser_trans_date.dim_publisher, fact_activity_advertiser_trans_date.dim_date, fact_activity_advertiser_trans_date.dim_creative_type, fact_activity_advertiser_trans_date.dim_offer, fact_activity_advertiser_trans_date.ref_click_comm], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.offer_key = fact_activity_advertiser_trans_date.ref_click_comm.offer_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.publisher_key = fact_activity_advertiser_trans_date.ref_click_comm.publisher_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key = fact_activity_advertiser_trans_date.ref_click_comm.advertiser_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key >= fact_activity_advertiser_trans_date.ref_click_comm.click_month_start_date_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key <= fact_activity_advertiser_trans_date.ref_click_comm.click_month_end_date_key]})                    Join(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, fact_activity_advertiser_trans_date.dim_publisher_group, fact_activity_advertiser_trans_date.dim_group_mid, fact_activity_advertiser_trans_date.dim_advertiser, fact_activity_advertiser_trans_date.dim_network, fact_activity_advertiser_trans_date.dim_publisher, fact_activity_advertiser_trans_date.dim_date, fact_activity_advertiser_trans_date.dim_creative_type, fact_activity_advertiser_trans_date.dim_offer], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.offer_key = fact_activity_advertiser_trans_date.dim_offer.offer_key]})                      Join(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, fact_activity_advertiser_trans_date.dim_publisher_group, fact_activity_advertiser_trans_date.dim_group_mid, fact_activity_advertiser_trans_date.dim_advertiser, fact_activity_advertiser_trans_date.dim_network, fact_activity_advertiser_trans_date.dim_publisher, fact_activity_advertiser_trans_date.dim_date, fact_activity_advertiser_trans_date.dim_creative_type], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.creative_type_key = convert(fact_activity_advertiser_trans_date.dim_creative_type.creative_type_key, long)]})                        Join(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, fact_activity_advertiser_trans_date.dim_publisher_group, fact_activity_advertiser_trans_date.dim_group_mid, fact_activity_advertiser_trans_date.dim_advertiser, fact_activity_advertiser_trans_date.dim_network, fact_activity_advertiser_trans_date.dim_publisher, fact_activity_advertiser_trans_date.dim_date], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key = fact_activity_advertiser_trans_date.dim_date.date_key]})                          Join(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, fact_activity_advertiser_trans_date.dim_publisher_group, fact_activity_advertiser_trans_date.dim_group_mid, fact_activity_advertiser_trans_date.dim_advertiser, fact_activity_advertiser_trans_date.dim_network, fact_activity_advertiser_trans_date.dim_publisher], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.publisher_key = fact_activity_advertiser_trans_date.dim_publisher.publisher_key]})                            Join(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, fact_activity_advertiser_trans_date.dim_publisher_group, fact_activity_advertiser_trans_date.dim_group_mid, fact_activity_advertiser_trans_date.dim_advertiser, fact_activity_advertiser_trans_date.dim_network], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[convert(fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.network_key, long) = fact_activity_advertiser_trans_date.dim_network.network_key]})                              Join(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, fact_activity_advertiser_trans_date.dim_publisher_group, fact_activity_advertiser_trans_date.dim_group_mid, fact_activity_advertiser_trans_date.dim_advertiser], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key = fact_activity_advertiser_trans_date.dim_advertiser.advertiser_key]})                                Join(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, fact_activity_advertiser_trans_date.dim_publisher_group, fact_activity_advertiser_trans_date.dim_group_mid], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[convert(fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key, string) = fact_activity_advertiser_trans_date.dim_group_mid.mid]})                                  Join(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, fact_activity_advertiser_trans_date.dim_publisher_group], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key = fact_activity_advertiser_trans_date.dim_publisher_group.advertiser_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.publisher_key = fact_activity_advertiser_trans_date.dim_publisher_group.publisher_key]})                                    Access(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date], props={SOURCE_HINT=null, MODEL_ID=Schema name=fact_activity_advertiser_trans_date, nameInSource=null, uuid=mmuuid:501c6893-dc93-4ed9-a3b3-be86c10ea039})                                      Source(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date])                                    Access(groups=[fact_activity_advertiser_trans_date.dim_publisher_group], props={SOURCE_HINT=null, IS_OPTIONAL=true, MODEL_ID=Schema name=fact_activity_advertiser_trans_date, nameInSource=null, uuid=mmuuid:501c6893-dc93-4ed9-a3b3-be86c10ea039})                                      Source(groups=[fact_activity_advertiser_trans_date.dim_publisher_group], props={})                                  Access(groups=[fact_activity_advertiser_trans_date.dim_group_mid], props={SOURCE_HINT=null, IS_OPTIONAL=true, MODEL_ID=Schema name=fact_activity_advertiser_trans_date, nameInSource=null, uuid=mmuuid:501c6893-dc93-4ed9-a3b3-be86c10ea039})                                    Source(groups=[fact_activity_advertiser_trans_date.dim_group_mid], props={})                                Access(groups=[fact_activity_advertiser_trans_date.dim_advertiser], props={SOURCE_HINT=null, IS_OPTIONAL=true, MODEL_ID=Schema name=fact_activity_advertiser_trans_date, nameInSource=null, uuid=mmuuid:501c6893-dc93-4ed9-a3b3-be86c10ea039})                                  Source(groups=[fact_activity_advertiser_trans_date.dim_advertiser], props={})                              Access(groups=[fact_activity_advertiser_trans_date.dim_network], props={SOURCE_HINT=null, IS_OPTIONAL=true, MODEL_ID=Schema name=fact_activity_advertiser_trans_date, nameInSource=null, uuid=mmuuid:501c6893-dc93-4ed9-a3b3-be86c10ea039})                                Source(groups=[fact_activity_advertiser_trans_date.dim_network], props={})                            Access(groups=[fact_activity_advertiser_trans_date.dim_publisher], props={SOURCE_HINT=null, IS_OPTIONAL=true, MODEL_ID=Schema name=fact_activity_advertiser_trans_date, nameInSource=null, uuid=mmuuid:501c6893-dc93-4ed9-a3b3-be86c10ea039})                              Source(groups=[fact_activity_advertiser_trans_date.dim_publisher], props={})                          Access(groups=[fact_activity_advertiser_trans_date.dim_date], props={SOURCE_HINT=null, IS_OPTIONAL=true, MODEL_ID=Schema name=fact_activity_advertiser_trans_date, nameInSource=null, uuid=mmuuid:501c6893-dc93-4ed9-a3b3-be86c10ea039})                            Source(groups=[fact_activity_advertiser_trans_date.dim_date], props={})                        Access(groups=[fact_activity_advertiser_trans_date.dim_creative_type], props={SOURCE_HINT=null, IS_OPTIONAL=true, MODEL_ID=Schema name=fact_activity_advertiser_trans_date, nameInSource=null, uuid=mmuuid:501c6893-dc93-4ed9-a3b3-be86c10ea039})                          Source(groups=[fact_activity_advertiser_trans_date.dim_creative_type], props={})                      Access(groups=[fact_activity_advertiser_trans_date.dim_offer], props={SOURCE_HINT=null, IS_OPTIONAL=true, MODEL_ID=Schema name=fact_activity_advertiser_trans_date, nameInSource=null, uuid=mmuuid:501c6893-dc93-4ed9-a3b3-be86c10ea039})                        Source(groups=[fact_activity_advertiser_trans_date.dim_offer], props={})                    Access(groups=[fact_activity_advertiser_trans_date.ref_click_comm], props={SOURCE_HINT=null, IS_OPTIONAL=true, MODEL_ID=Schema name=fact_activity_advertiser_trans_date, nameInSource=null, uuid=mmuuid:501c6893-dc93-4ed9-a3b3-be86c10ea039})                      Source(groups=[fact_activity_advertiser_trans_date.ref_click_comm], props={})      ============================================================================  EXECUTING AssignOutputElements    AFTER:   TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=1, OUTPUT_COLS=[anon_grp0.gcol0 AS trans_year, convert((anon_grp0.agg0 / convert(anon_grp0.agg1, long)), double) AS net_items_per_order]})    Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol0 AS trans_year, convert((anon_grp0.agg0 / convert(anon_grp0.agg1, long)), double) AS net_items_per_order], OUTPUT_COLS=[anon_grp0.gcol0 AS trans_year, convert((anon_grp0.agg0 / convert(anon_grp0.agg1, long)), double) AS net_items_per_order]})      Group(groups=[ActivityAdvertiserTransDate.ActivityAdvertiserTransDate, anon_grp0], props={GROUP_COLS=[ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_year, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_date_key], SYMBOL_MAP={anon_grp0.gcol0=ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_year, anon_grp0.gcol1=ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_date_key, anon_grp0.agg0=SUM(ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.num_items_net), anon_grp0.agg1=COUNT(DISTINCT CASE WHEN ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.order_pub_comm_base >= 0 THEN ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.orderid END)}, OUTPUT_COLS=[anon_grp0.gcol0, anon_grp0.agg0, anon_grp0.agg1]})        Select(groups=[ActivityAdvertiserTransDate.ActivityAdvertiserTransDate], props={SELECT_CRITERIA=ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.advertiser_key = 111, OUTPUT_COLS=[ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_year, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_date_key, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.num_items_net, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.order_pub_comm_base, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.orderid]})          Select(groups=[ActivityAdvertiserTransDate.ActivityAdvertiserTransDate], props={SELECT_CRITERIA=ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_date_key <= '2015-01-01', OUTPUT_COLS=[ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.advertiser_key, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_year, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_date_key, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.num_items_net, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.order_pub_comm_base, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.orderid]})            Select(groups=[ActivityAdvertiserTransDate.ActivityAdvertiserTransDate], props={SELECT_CRITERIA=ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_date_key >= '2015-01-01', OUTPUT_COLS=[ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_date_key, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.advertiser_key, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_year, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.num_items_net, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.order_pub_comm_base, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.orderid]})              Source(groups=[ActivityAdvertiserTransDate.ActivityAdvertiserTransDate], props={NESTED_COMMAND=SELECT fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_impressions, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_clicks, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.est_click_comm, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.sales, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.quantity, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_items, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_items_cancel, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_items_net, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.pub_comm_adj, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.pub_comm_base, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.pub_comm_base_totl, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.pub_comm_totl, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.pub_comm_totl_w_click, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.pub_comm_gross, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.pub_comm_gross_totl, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.rktn_comm_totl, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.sales_gross, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.sales_returned, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.publisher_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.network_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key, fact_activity_advertiser_trans_date.dim_advertiser.advertiser_name, fact_activity_advertiser_trans_date.dim_advertiser.advertiser_primary_industry, fact_activity_advertiser_trans_date.dim_advertiser.advertiser_secondary_industry, CASE WHEN left(fact_activity_advertiser_trans_date.dim_advertiser.advertiser_name, 3) = '{*}' THEN FALSE ELSE TRUE END AS advertiser_is_active, fact_activity_advertiser_trans_date.dim_network.network_name, fact_activity_advertiser_trans_date.dim_network.network_cancellation_window, fact_activity_advertiser_trans_date.dim_network.network_locale, fact_activity_advertiser_trans_date.dim_publisher.publisher_secondary_industry, fact_activity_advertiser_trans_date.dim_publisher.publisher_primary_industry, fact_activity_advertiser_trans_date.dim_publisher.publisher_encr_id, fact_activity_advertiser_trans_date.dim_publisher.publisher_url, fact_activity_advertiser_trans_date.dim_publisher.publisher_tertiary_industry, fact_activity_advertiser_trans_date.dim_publisher.publisher_name, fact_activity_advertiser_trans_date.dim_date.year_name AS trans_year, fact_activity_advertiser_trans_date.dim_date.month_num AS trans_month, fact_activity_advertiser_trans_date.dim_date.month_name AS trans_month_name, fact_activity_advertiser_trans_date.dim_date.day_num AS trans_day_num, fact_activity_advertiser_trans_date.dim_date.day_name AS trans_day_name, fact_activity_advertiser_trans_date.dim_date.week_day_num AS trans_week_day_num, fact_activity_advertiser_trans_date.dim_date.week_num AS trans_week_num, fact_activity_advertiser_trans_date.dim_date.week_name AS trans_week_name, fact_activity_advertiser_trans_date.dim_date.week_begin_date AS trans_week_begin_date, fact_activity_advertiser_trans_date.dim_date.week_end_date AS trans_week_end_date, concat(concat(LPAD(convert(fact_activity_advertiser_trans_date.dim_date.month_num, string), 2, '0'), '-'), LPAD(convert(fact_activity_advertiser_trans_date.dim_date.day_num, string), 2, '0')) AS trans_month_day, concat(concat(LPAD(convert(fact_activity_advertiser_trans_date.dim_date.month_num, string), 2, '0'), '-'), convert(fact_activity_advertiser_trans_date.dim_date.year_name, string)) AS trans_month_year, fact_activity_advertiser_trans_date.dim_date.last_year_date_key AS trans_last_year_date_key, fact_activity_advertiser_trans_date.dim_date.last_month_date_key AS trans_last_month_date_key, fact_activity_advertiser_trans_date.dim_date.last_week_date_key AS trans_last_week_date_key, fact_activity_advertiser_trans_date.dim_date.yesterday_date_key AS trans_yesterday_date_key, fact_activity_advertiser_trans_date.dim_publisher_group.publisher_group_name, fact_activity_advertiser_trans_date.dim_publisher_group.publisher_group_id, fact_activity_advertiser_trans_date.dim_group_mid.group_id, fact_activity_advertiser_trans_date.dim_creative_type.creative_type_name, fact_activity_advertiser_trans_date.dim_offer.offer_name, fact_activity_advertiser_trans_date.dim_offer.group_offer_key, fact_activity_advertiser_trans_date.dim_offer.group_offer_name, fact_activity_advertiser_trans_date.dim_offer.group_offer_id, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.orderid, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.order_pub_comm_base, fact_activity_advertiser_trans_date.ref_click_comm.cpc_comm, (CASE WHEN convert(fact_activity_advertiser_trans_date.ref_click_comm.cpc_comm, double) IS NOT NULL THEN (convert(fact_activity_advertiser_trans_date.ref_click_comm.cpc_comm, double) * ifnull(convert(fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_clicks, double), 0.0)) ELSE 0.0 END + ifnull(convert(fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.pub_comm_totl, double), 0.0)) AS cpc_comm_calc, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.offer_key, fact_activity_advertiser_trans_date.dim_network.network_currency, fact_activity_advertiser_trans_date.dim_publisher.publisher_category, fact_activity_advertiser_trans_date.dim_publisher.publisher_joindate FROM ((((((((fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date LEFT OUTER JOIN /*+ optional */ fact_activity_advertiser_trans_date.dim_publisher_group ON fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key = fact_activity_advertiser_trans_date.dim_publisher_group.advertiser_key AND fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.publisher_key = fact_activity_advertiser_trans_date.dim_publisher_group.publisher_key) LEFT OUTER JOIN /*+ optional */ fact_activity_advertiser_trans_date.dim_group_mid ON convert(fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key, string) = fact_activity_advertiser_trans_date.dim_group_mid.mid) INNER JOIN /*+ optional */ fact_activity_advertiser_trans_date.dim_advertiser ON fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key = fact_activity_advertiser_trans_date.dim_advertiser.advertiser_key) INNER JOIN /*+ optional */ fact_activity_advertiser_trans_date.dim_network ON convert(fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.network_key, long) = fact_activity_advertiser_trans_date.dim_network.network_key) INNER JOIN /*+ optional */ fact_activity_advertiser_trans_date.dim_publisher ON fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.publisher_key = fact_activity_advertiser_trans_date.dim_publisher.publisher_key) INNER JOIN /*+ optional */ fact_activity_advertiser_trans_date.dim_date ON fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key = fact_activity_advertiser_trans_date.dim_date.date_key) INNER JOIN /*+ optional */ fact_activity_advertiser_trans_date.dim_creative_type ON fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.creative_type_key = convert(fact_activity_advertiser_trans_date.dim_creative_type.creative_type_key, long)) INNER JOIN /*+ optional */ fact_activity_advertiser_trans_date.dim_offer ON fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.offer_key = fact_activity_advertiser_trans_date.dim_offer.offer_key) LEFT OUTER JOIN /*+ optional */ fact_activity_advertiser_trans_date.ref_click_comm ON fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.offer_key = fact_activity_advertiser_trans_date.ref_click_comm.offer_key AND fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.publisher_key = fact_activity_advertiser_trans_date.ref_click_comm.publisher_key AND fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key = fact_activity_advertiser_trans_date.ref_click_comm.advertiser_key AND fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key >= fact_activity_advertiser_trans_date.ref_click_comm.click_month_start_date_key AND fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key <= fact_activity_advertiser_trans_date.ref_click_comm.click_month_end_date_key, SYMBOL_MAP={ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_date_key=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.advertiser_key=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_year=fact_activity_advertiser_trans_date.dim_date.year_name, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.num_items_net=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_items_net, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.order_pub_comm_base=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.order_pub_comm_base, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.orderid=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.orderid}, OUTPUT_COLS=[ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_date_key, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.advertiser_key, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_year, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.num_items_net, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.order_pub_comm_base, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.orderid]})                Project(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, fact_activity_advertiser_trans_date.dim_date], props={PROJECT_COLS=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key, fact_activity_advertiser_trans_date.dim_date.year_name AS trans_year, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_items_net, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.order_pub_comm_base, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.orderid], OUTPUT_COLS=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key, fact_activity_advertiser_trans_date.dim_date.year_name AS trans_year, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_items_net, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.order_pub_comm_base, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.orderid]})                  Join(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, fact_activity_advertiser_trans_date.dim_publisher_group, fact_activity_advertiser_trans_date.dim_group_mid, fact_activity_advertiser_trans_date.dim_advertiser, fact_activity_advertiser_trans_date.dim_network, fact_activity_advertiser_trans_date.dim_publisher, fact_activity_advertiser_trans_date.dim_date, fact_activity_advertiser_trans_date.dim_creative_type, fact_activity_advertiser_trans_date.dim_offer, fact_activity_advertiser_trans_date.ref_click_comm], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.offer_key = fact_activity_advertiser_trans_date.ref_click_comm.offer_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.publisher_key = fact_activity_advertiser_trans_date.ref_click_comm.publisher_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key = fact_activity_advertiser_trans_date.ref_click_comm.advertiser_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key >= fact_activity_advertiser_trans_date.ref_click_comm.click_month_start_date_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key <= fact_activity_advertiser_trans_date.ref_click_comm.click_month_end_date_key], OUTPUT_COLS=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key, fact_activity_advertiser_trans_date.dim_date.year_name, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_items_net, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.order_pub_comm_base, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.orderid]})                    Join(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, fact_activity_advertiser_trans_date.dim_publisher_group, fact_activity_advertiser_trans_date.dim_group_mid, fact_activity_advertiser_trans_date.dim_advertiser, fact_activity_advertiser_trans_date.dim_network, fact_activity_advertiser_trans_date.dim_publisher, fact_activity_advertiser_trans_date.dim_date, fact_activity_advertiser_trans_date.dim_creative_type, fact_activity_advertiser_trans_date.dim_offer], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.offer_key = fact_activity_advertiser_trans_date.dim_offer.offer_key], OUTPUT_COLS=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.offer_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.publisher_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key, fact_activity_advertiser_trans_date.dim_date.year_name, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_items_net, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.order_pub_comm_base, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.orderid]})                      Join(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, fact_activity_advertiser_trans_date.dim_publisher_group, fact_activity_advertiser_trans_date.dim_group_mid, fact_activity_advertiser_trans_date.dim_advertiser, fact_activity_advertiser_trans_date.dim_network, fact_activity_advertiser_trans_date.dim_publisher, fact_activity_advertiser_trans_date.dim_date, fact_activity_advertiser_trans_date.dim_creative_type], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.creative_type_key = convert(fact_activity_advertiser_trans_date.dim_creative_type.creative_type_key, long)], OUTPUT_COLS=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.offer_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.publisher_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key, fact_activity_advertiser_trans_date.dim_date.year_name, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_items_net, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.order_pub_comm_base, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.orderid]})                        Join(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, fact_activity_advertiser_trans_date.dim_publisher_group, fact_activity_advertiser_trans_date.dim_group_mid, fact_activity_advertiser_trans_date.dim_advertiser, fact_activity_advertiser_trans_date.dim_network, fact_activity_advertiser_trans_date.dim_publisher, fact_activity_advertiser_trans_date.dim_date], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key = fact_activity_advertiser_trans_date.dim_date.date_key], OUTPUT_COLS=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.creative_type_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.offer_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.publisher_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key, fact_activity_advertiser_trans_date.dim_date.year_name, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_items_net, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.order_pub_comm_base, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.orderid]})                          Join(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, fact_activity_advertiser_trans_date.dim_publisher_group, fact_activity_advertiser_trans_date.dim_group_mid, fact_activity_advertiser_trans_date.dim_advertiser, fact_activity_advertiser_trans_date.dim_network, fact_activity_advertiser_trans_date.dim_publisher], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.publisher_key = fact_activity_advertiser_trans_date.dim_publisher.publisher_key], OUTPUT_COLS=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.creative_type_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.offer_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.publisher_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_items_net, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.order_pub_comm_base, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.orderid]})                            Join(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, fact_activity_advertiser_trans_date.dim_publisher_group, fact_activity_advertiser_trans_date.dim_group_mid, fact_activity_advertiser_trans_date.dim_advertiser, fact_activity_advertiser_trans_date.dim_network], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[convert(fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.network_key, long) = fact_activity_advertiser_trans_date.dim_network.network_key], OUTPUT_COLS=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.publisher_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.creative_type_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.offer_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_items_net, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.order_pub_comm_base, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.orderid]})                              Join(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, fact_activity_advertiser_trans_date.dim_publisher_group, fact_activity_advertiser_trans_date.dim_group_mid, fact_activity_advertiser_trans_date.dim_advertiser], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key = fact_activity_advertiser_trans_date.dim_advertiser.advertiser_key], OUTPUT_COLS=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.network_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.publisher_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.creative_type_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.offer_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_items_net, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.order_pub_comm_base, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.orderid]})                                Join(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, fact_activity_advertiser_trans_date.dim_publisher_group, fact_activity_advertiser_trans_date.dim_group_mid], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[convert(fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key, string) = fact_activity_advertiser_trans_date.dim_group_mid.mid], OUTPUT_COLS=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.network_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.publisher_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.creative_type_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.offer_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_items_net, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.order_pub_comm_base, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.orderid]})                                  Join(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, fact_activity_advertiser_trans_date.dim_publisher_group], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key = fact_activity_advertiser_trans_date.dim_publisher_group.advertiser_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.publisher_key = fact_activity_advertiser_trans_date.dim_publisher_group.publisher_key], OUTPUT_COLS=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.network_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.publisher_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.creative_type_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.offer_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_items_net, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.order_pub_comm_base, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.orderid]})                                    Access(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date], props={SOURCE_HINT=null, MODEL_ID=Schema name=fact_activity_advertiser_trans_date, nameInSource=null, uuid=mmuuid:501c6893-dc93-4ed9-a3b3-be86c10ea039, OUTPUT_COLS=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.publisher_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.network_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.creative_type_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.offer_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_items_net, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.order_pub_comm_base, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.orderid]})                                      Source(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date], props={OUTPUT_COLS=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.publisher_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.network_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.creative_type_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.offer_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_items_net, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.order_pub_comm_base, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.orderid]})                                    Access(groups=[fact_activity_advertiser_trans_date.dim_publisher_group], props={SOURCE_HINT=null, IS_OPTIONAL=true, MODEL_ID=Schema name=fact_activity_advertiser_trans_date, nameInSource=null, uuid=mmuuid:501c6893-dc93-4ed9-a3b3-be86c10ea039, OUTPUT_COLS=[fact_activity_advertiser_trans_date.dim_publisher_group.advertiser_key, fact_activity_advertiser_trans_date.dim_publisher_group.publisher_key]})                                      Source(groups=[fact_activity_advertiser_trans_date.dim_publisher_group], props={OUTPUT_COLS=[fact_activity_advertiser_trans_date.dim_publisher_group.advertiser_key, fact_activity_advertiser_trans_date.dim_publisher_group.publisher_key]})                                  Access(groups=[fact_activity_advertiser_trans_date.dim_group_mid], props={SOURCE_HINT=null, IS_OPTIONAL=true, MODEL_ID=Schema name=fact_activity_advertiser_trans_date, nameInSource=null, uuid=mmuuid:501c6893-dc93-4ed9-a3b3-be86c10ea039, OUTPUT_COLS=[fact_activity_advertiser_trans_date.dim_group_mid.mid]})                                    Source(groups=[fact_activity_advertiser_trans_date.dim_group_mid], props={OUTPUT_COLS=[fact_activity_advertiser_trans_date.dim_group_mid.mid]})                                Access(groups=[fact_activity_advertiser_trans_date.dim_advertiser], props={SOURCE_HINT=null, IS_OPTIONAL=true, MODEL_ID=Schema name=fact_activity_advertiser_trans_date, nameInSource=null, uuid=mmuuid:501c6893-dc93-4ed9-a3b3-be86c10ea039, OUTPUT_COLS=[fact_activity_advertiser_trans_date.dim_advertiser.advertiser_key]})                                  Source(groups=[fact_activity_advertiser_trans_date.dim_advertiser], props={OUTPUT_COLS=[fact_activity_advertiser_trans_date.dim_advertiser.advertiser_key]})                              Access(groups=[fact_activity_advertiser_trans_date.dim_network], props={SOURCE_HINT=null, IS_OPTIONAL=true, MODEL_ID=Schema name=fact_activity_advertiser_trans_date, nameInSource=null, uuid=mmuuid:501c6893-dc93-4ed9-a3b3-be86c10ea039, OUTPUT_COLS=[fact_activity_advertiser_trans_date.dim_network.network_key]})                                Source(groups=[fact_activity_advertiser_trans_date.dim_network], props={OUTPUT_COLS=[fact_activity_advertiser_trans_date.dim_network.network_key]})                            Access(groups=[fact_activity_advertiser_trans_date.dim_publisher], props={SOURCE_HINT=null, IS_OPTIONAL=true, MODEL_ID=Schema name=fact_activity_advertiser_trans_date, nameInSource=null, uuid=mmuuid:501c6893-dc93-4ed9-a3b3-be86c10ea039, OUTPUT_COLS=[fact_activity_advertiser_trans_date.dim_publisher.publisher_key]})                              Source(groups=[fact_activity_advertiser_trans_date.dim_publisher], props={OUTPUT_COLS=[fact_activity_advertiser_trans_date.dim_publisher.publisher_key]})                          Access(groups=[fact_activity_advertiser_trans_date.dim_date], props={SOURCE_HINT=null, IS_OPTIONAL=true, MODEL_ID=Schema name=fact_activity_advertiser_trans_date, nameInSource=null, uuid=mmuuid:501c6893-dc93-4ed9-a3b3-be86c10ea039, OUTPUT_COLS=[fact_activity_advertiser_trans_date.dim_date.date_key, fact_activity_advertiser_trans_date.dim_date.year_name]})                            Source(groups=[fact_activity_advertiser_trans_date.dim_date], props={OUTPUT_COLS=[fact_activity_advertiser_trans_date.dim_date.date_key, fact_activity_advertiser_trans_date.dim_date.year_name]})                        Access(groups=[fact_activity_advertiser_trans_date.dim_creative_type], props={SOURCE_HINT=null, IS_OPTIONAL=true, MODEL_ID=Schema name=fact_activity_advertiser_trans_date, nameInSource=null, uuid=mmuuid:501c6893-dc93-4ed9-a3b3-be86c10ea039, OUTPUT_COLS=[fact_activity_advertiser_trans_date.dim_creative_type.creative_type_key]})                          Source(groups=[fact_activity_advertiser_trans_date.dim_creative_type], props={OUTPUT_COLS=[fact_activity_advertiser_trans_date.dim_creative_type.creative_type_key]})                      Access(groups=[fact_activity_advertiser_trans_date.dim_offer], props={SOURCE_HINT=null, IS_OPTIONAL=true, MODEL_ID=Schema name=fact_activity_advertiser_trans_date, nameInSource=null, uuid=mmuuid:501c6893-dc93-4ed9-a3b3-be86c10ea039, OUTPUT_COLS=[fact_activity_advertiser_trans_date.dim_offer.offer_key]})                        Source(groups=[fact_activity_advertiser_trans_date.dim_offer], props={OUTPUT_COLS=[fact_activity_advertiser_trans_date.dim_offer.offer_key]})                    Access(groups=[fact_activity_advertiser_trans_date.ref_click_comm], props={SOURCE_HINT=null, IS_OPTIONAL=true, MODEL_ID=Schema name=fact_activity_advertiser_trans_date, nameInSource=null, uuid=mmuuid:501c6893-dc93-4ed9-a3b3-be86c10ea039, OUTPUT_COLS=[fact_activity_advertiser_trans_date.ref_click_comm.offer_key, fact_activity_advertiser_trans_date.ref_click_comm.publisher_key, fact_activity_advertiser_trans_date.ref_click_comm.advertiser_key, fact_activity_advertiser_trans_date.ref_click_comm.click_month_start_date_key, fact_activity_advertiser_trans_date.ref_click_comm.click_month_end_date_key]})                      Source(groups=[fact_activity_advertiser_trans_date.ref_click_comm], props={OUTPUT_COLS=[fact_activity_advertiser_trans_date.ref_click_comm.offer_key, fact_activity_advertiser_trans_date.ref_click_comm.publisher_key, fact_activity_advertiser_trans_date.ref_click_comm.advertiser_key, fact_activity_advertiser_trans_date.ref_click_comm.click_month_start_date_key, fact_activity_advertiser_trans_date.ref_click_comm.click_month_end_date_key]})      ============================================================================  EXECUTING RemoveOptionalJoins  LOW [Relational Planner] node was marked as optional  - Removing join node Join(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, fact_activity_advertiser_trans_date.dim_publisher_group, fact_activity_advertiser_trans_date.dim_group_mid, fact_activity_advertiser_trans_date.dim_advertiser, fact_activity_advertiser_trans_date.dim_network, fact_activity_advertiser_trans_date.dim_publisher, fact_activity_advertiser_trans_date.dim_date, fact_activity_advertiser_trans_date.dim_creative_type, fact_activity_advertiser_trans_date.dim_offer, fact_activity_advertiser_trans_date.ref_click_comm], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.offer_key = fact_activity_advertiser_trans_date.ref_click_comm.offer_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.publisher_key = fact_activity_advertiser_trans_date.ref_click_comm.publisher_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key = fact_activity_advertiser_trans_date.ref_click_comm.advertiser_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key >= fact_activity_advertiser_trans_date.ref_click_comm.click_month_start_date_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key <= fact_activity_advertiser_trans_date.ref_click_comm.click_month_end_date_key], OUTPUT_COLS=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key, fact_activity_advertiser_trans_date.dim_date.year_name, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_items_net, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.order_pub_comm_base, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.orderid]}  LOW [Relational Planner] node was marked as optional  - Removing join node Join(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, fact_activity_advertiser_trans_date.dim_publisher_group, fact_activity_advertiser_trans_date.dim_group_mid, fact_activity_advertiser_trans_date.dim_advertiser, fact_activity_advertiser_trans_date.dim_network, fact_activity_advertiser_trans_date.dim_publisher, fact_activity_advertiser_trans_date.dim_date, fact_activity_advertiser_trans_date.dim_creative_type, fact_activity_advertiser_trans_date.dim_offer], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.offer_key = fact_activity_advertiser_trans_date.dim_offer.offer_key], OUTPUT_COLS=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key, fact_activity_advertiser_trans_date.dim_date.year_name, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_items_net, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.order_pub_comm_base, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.orderid]}  LOW [Relational Planner] node was marked as optional  - Removing join node Join(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, fact_activity_advertiser_trans_date.dim_publisher_group, fact_activity_advertiser_trans_date.dim_group_mid, fact_activity_advertiser_trans_date.dim_advertiser, fact_activity_advertiser_trans_date.dim_network, fact_activity_advertiser_trans_date.dim_publisher, fact_activity_advertiser_trans_date.dim_date, fact_activity_advertiser_trans_date.dim_creative_type], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.creative_type_key = convert(fact_activity_advertiser_trans_date.dim_creative_type.creative_type_key, long)], OUTPUT_COLS=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key, fact_activity_advertiser_trans_date.dim_date.year_name, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_items_net, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.order_pub_comm_base, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.orderid]}  LOW [Relational Planner] node was marked as optional  - Removing join node Join(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, fact_activity_advertiser_trans_date.dim_publisher_group, fact_activity_advertiser_trans_date.dim_group_mid, fact_activity_advertiser_trans_date.dim_advertiser, fact_activity_advertiser_trans_date.dim_network, fact_activity_advertiser_trans_date.dim_publisher], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.publisher_key = fact_activity_advertiser_trans_date.dim_publisher.publisher_key], OUTPUT_COLS=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.creative_type_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.offer_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.publisher_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_items_net, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.order_pub_comm_base, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.orderid]}  LOW [Relational Planner] node was marked as optional  - Removing join node Join(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, fact_activity_advertiser_trans_date.dim_publisher_group, fact_activity_advertiser_trans_date.dim_group_mid, fact_activity_advertiser_trans_date.dim_advertiser, fact_activity_advertiser_trans_date.dim_network], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[convert(fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.network_key, long) = fact_activity_advertiser_trans_date.dim_network.network_key], OUTPUT_COLS=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.creative_type_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.offer_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.publisher_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_items_net, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.order_pub_comm_base, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.orderid]}  LOW [Relational Planner] node was marked as optional  - Removing join node Join(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, fact_activity_advertiser_trans_date.dim_publisher_group, fact_activity_advertiser_trans_date.dim_group_mid, fact_activity_advertiser_trans_date.dim_advertiser], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key = fact_activity_advertiser_trans_date.dim_advertiser.advertiser_key], OUTPUT_COLS=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.creative_type_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.offer_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.publisher_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_items_net, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.order_pub_comm_base, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.orderid]}  LOW [Relational Planner] node was marked as optional  - Removing join node Join(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, fact_activity_advertiser_trans_date.dim_publisher_group, fact_activity_advertiser_trans_date.dim_group_mid], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[convert(fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key, string) = fact_activity_advertiser_trans_date.dim_group_mid.mid], OUTPUT_COLS=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.creative_type_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.offer_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.publisher_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_items_net, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.order_pub_comm_base, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.orderid]}  LOW [Relational Planner] node was marked as optional  - Removing join node Join(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, fact_activity_advertiser_trans_date.dim_publisher_group], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key = fact_activity_advertiser_trans_date.dim_publisher_group.advertiser_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.publisher_key = fact_activity_advertiser_trans_date.dim_publisher_group.publisher_key], OUTPUT_COLS=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.creative_type_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.offer_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.publisher_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_items_net, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.order_pub_comm_base, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.orderid]}    AFTER:   TupleLimit(groups=[])    Project(groups=[anon_grp0])      Group(groups=[ActivityAdvertiserTransDate.ActivityAdvertiserTransDate, anon_grp0])        Select(groups=[ActivityAdvertiserTransDate.ActivityAdvertiserTransDate], props={SELECT_CRITERIA=ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.advertiser_key = 111, OUTPUT_COLS=[ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_year, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_date_key, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.num_items_net, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.order_pub_comm_base, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.orderid]})          Select(groups=[ActivityAdvertiserTransDate.ActivityAdvertiserTransDate])            Select(groups=[ActivityAdvertiserTransDate.ActivityAdvertiserTransDate])              Source(groups=[ActivityAdvertiserTransDate.ActivityAdvertiserTransDate])                Project(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, fact_activity_advertiser_trans_date.dim_date], props={PROJECT_COLS=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key, fact_activity_advertiser_trans_date.dim_date.year_name AS trans_year, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_items_net, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.order_pub_comm_base, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.orderid], OUTPUT_COLS=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key, fact_activity_advertiser_trans_date.dim_date.year_name AS trans_year, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_items_net, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.order_pub_comm_base, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.orderid]})                  Join(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, fact_activity_advertiser_trans_date.dim_date], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key = fact_activity_advertiser_trans_date.dim_date.date_key], OUTPUT_COLS=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key, fact_activity_advertiser_trans_date.dim_date.year_name, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_items_net, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.order_pub_comm_base, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.orderid]})                    Access(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date], props={SOURCE_HINT=null, MODEL_ID=Schema name=fact_activity_advertiser_trans_date, nameInSource=null, uuid=mmuuid:501c6893-dc93-4ed9-a3b3-be86c10ea039, OUTPUT_COLS=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.creative_type_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.offer_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.publisher_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_items_net, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.order_pub_comm_base, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.orderid]})                      Source(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date])                    Access(groups=[fact_activity_advertiser_trans_date.dim_date], props={SOURCE_HINT=null, IS_OPTIONAL=true, MODEL_ID=Schema name=fact_activity_advertiser_trans_date, nameInSource=null, uuid=mmuuid:501c6893-dc93-4ed9-a3b3-be86c10ea039, OUTPUT_COLS=[fact_activity_advertiser_trans_date.dim_date.date_key, fact_activity_advertiser_trans_date.dim_date.year_name]})                      Source(groups=[fact_activity_advertiser_trans_date.dim_date])      ============================================================================  EXECUTING PushSelectCriteria    AFTER:   TupleLimit(groups=[])    Project(groups=[anon_grp0])      Group(groups=[ActivityAdvertiserTransDate.ActivityAdvertiserTransDate, anon_grp0])        Select(groups=[ActivityAdvertiserTransDate.ActivityAdvertiserTransDate], props={SELECT_CRITERIA=ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.advertiser_key = 111, OUTPUT_COLS=[ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_year, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_date_key, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.num_items_net, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.order_pub_comm_base, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.orderid], IS_PHANTOM=true})          Select(groups=[ActivityAdvertiserTransDate.ActivityAdvertiserTransDate], props={SELECT_CRITERIA=ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_date_key <= '2015-01-01', OUTPUT_COLS=[ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.advertiser_key, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_year, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_date_key, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.num_items_net, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.order_pub_comm_base, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.orderid], IS_PHANTOM=true})            Select(groups=[ActivityAdvertiserTransDate.ActivityAdvertiserTransDate], props={SELECT_CRITERIA=ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_date_key >= '2015-01-01', OUTPUT_COLS=[ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_date_key, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.advertiser_key, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_year, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.num_items_net, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.order_pub_comm_base, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.orderid], IS_PHANTOM=true})              Source(groups=[ActivityAdvertiserTransDate.ActivityAdvertiserTransDate], props={NESTED_COMMAND=SELECT fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_impressions, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_clicks, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.est_click_comm, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.sales, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.quantity, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_items, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_items_cancel, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_items_net, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.pub_comm_adj, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.pub_comm_base, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.pub_comm_base_totl, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.pub_comm_totl, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.pub_comm_totl_w_click, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.pub_comm_gross, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.pub_comm_gross_totl, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.rktn_comm_totl, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.sales_gross, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.sales_returned, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.publisher_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.network_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key, fact_activity_advertiser_trans_date.dim_advertiser.advertiser_name, fact_activity_advertiser_trans_date.dim_advertiser.advertiser_primary_industry, fact_activity_advertiser_trans_date.dim_advertiser.advertiser_secondary_industry, CASE WHEN left(fact_activity_advertiser_trans_date.dim_advertiser.advertiser_name, 3) = '{*}' THEN FALSE ELSE TRUE END AS advertiser_is_active, fact_activity_advertiser_trans_date.dim_network.network_name, fact_activity_advertiser_trans_date.dim_network.network_cancellation_window, fact_activity_advertiser_trans_date.dim_network.network_locale, fact_activity_advertiser_trans_date.dim_publisher.publisher_secondary_industry, fact_activity_advertiser_trans_date.dim_publisher.publisher_primary_industry, fact_activity_advertiser_trans_date.dim_publisher.publisher_encr_id, fact_activity_advertiser_trans_date.dim_publisher.publisher_url, fact_activity_advertiser_trans_date.dim_publisher.publisher_tertiary_industry, fact_activity_advertiser_trans_date.dim_publisher.publisher_name, fact_activity_advertiser_trans_date.dim_date.year_name AS trans_year, fact_activity_advertiser_trans_date.dim_date.month_num AS trans_month, fact_activity_advertiser_trans_date.dim_date.month_name AS trans_month_name, fact_activity_advertiser_trans_date.dim_date.day_num AS trans_day_num, fact_activity_advertiser_trans_date.dim_date.day_name AS trans_day_name, fact_activity_advertiser_trans_date.dim_date.week_day_num AS trans_week_day_num, fact_activity_advertiser_trans_date.dim_date.week_num AS trans_week_num, fact_activity_advertiser_trans_date.dim_date.week_name AS trans_week_name, fact_activity_advertiser_trans_date.dim_date.week_begin_date AS trans_week_begin_date, fact_activity_advertiser_trans_date.dim_date.week_end_date AS trans_week_end_date, concat(concat(LPAD(convert(fact_activity_advertiser_trans_date.dim_date.month_num, string), 2, '0'), '-'), LPAD(convert(fact_activity_advertiser_trans_date.dim_date.day_num, string), 2, '0')) AS trans_month_day, concat(concat(LPAD(convert(fact_activity_advertiser_trans_date.dim_date.month_num, string), 2, '0'), '-'), convert(fact_activity_advertiser_trans_date.dim_date.year_name, string)) AS trans_month_year, fact_activity_advertiser_trans_date.dim_date.last_year_date_key AS trans_last_year_date_key, fact_activity_advertiser_trans_date.dim_date.last_month_date_key AS trans_last_month_date_key, fact_activity_advertiser_trans_date.dim_date.last_week_date_key AS trans_last_week_date_key, fact_activity_advertiser_trans_date.dim_date.yesterday_date_key AS trans_yesterday_date_key, fact_activity_advertiser_trans_date.dim_publisher_group.publisher_group_name, fact_activity_advertiser_trans_date.dim_publisher_group.publisher_group_id, fact_activity_advertiser_trans_date.dim_group_mid.group_id, fact_activity_advertiser_trans_date.dim_creative_type.creative_type_name, fact_activity_advertiser_trans_date.dim_offer.offer_name, fact_activity_advertiser_trans_date.dim_offer.group_offer_key, fact_activity_advertiser_trans_date.dim_offer.group_offer_name, fact_activity_advertiser_trans_date.dim_offer.group_offer_id, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.orderid, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.order_pub_comm_base, fact_activity_advertiser_trans_date.ref_click_comm.cpc_comm, (CASE WHEN convert(fact_activity_advertiser_trans_date.ref_click_comm.cpc_comm, double) IS NOT NULL THEN (convert(fact_activity_advertiser_trans_date.ref_click_comm.cpc_comm, double) * ifnull(convert(fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_clicks, double), 0.0)) ELSE 0.0 END + ifnull(convert(fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.pub_comm_totl, double), 0.0)) AS cpc_comm_calc, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.offer_key, fact_activity_advertiser_trans_date.dim_network.network_currency, fact_activity_advertiser_trans_date.dim_publisher.publisher_category, fact_activity_advertiser_trans_date.dim_publisher.publisher_joindate FROM ((((((((fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date LEFT OUTER JOIN /*+ optional */ fact_activity_advertiser_trans_date.dim_publisher_group ON fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key = fact_activity_advertiser_trans_date.dim_publisher_group.advertiser_key AND fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.publisher_key = fact_activity_advertiser_trans_date.dim_publisher_group.publisher_key) LEFT OUTER JOIN /*+ optional */ fact_activity_advertiser_trans_date.dim_group_mid ON convert(fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key, string) = fact_activity_advertiser_trans_date.dim_group_mid.mid) INNER JOIN /*+ optional */ fact_activity_advertiser_trans_date.dim_advertiser ON fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key = fact_activity_advertiser_trans_date.dim_advertiser.advertiser_key) INNER JOIN /*+ optional */ fact_activity_advertiser_trans_date.dim_network ON convert(fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.network_key, long) = fact_activity_advertiser_trans_date.dim_network.network_key) INNER JOIN /*+ optional */ fact_activity_advertiser_trans_date.dim_publisher ON fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.publisher_key = fact_activity_advertiser_trans_date.dim_publisher.publisher_key) INNER JOIN /*+ optional */ fact_activity_advertiser_trans_date.dim_date ON fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key = fact_activity_advertiser_trans_date.dim_date.date_key) INNER JOIN /*+ optional */ fact_activity_advertiser_trans_date.dim_creative_type ON fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.creative_type_key = convert(fact_activity_advertiser_trans_date.dim_creative_type.creative_type_key, long)) INNER JOIN /*+ optional */ fact_activity_advertiser_trans_date.dim_offer ON fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.offer_key = fact_activity_advertiser_trans_date.dim_offer.offer_key) LEFT OUTER JOIN /*+ optional */ fact_activity_advertiser_trans_date.ref_click_comm ON fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.offer_key = fact_activity_advertiser_trans_date.ref_click_comm.offer_key AND fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.publisher_key = fact_activity_advertiser_trans_date.ref_click_comm.publisher_key AND fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key = fact_activity_advertiser_trans_date.ref_click_comm.advertiser_key AND fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key >= fact_activity_advertiser_trans_date.ref_click_comm.click_month_start_date_key AND fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key <= fact_activity_advertiser_trans_date.ref_click_comm.click_month_end_date_key, SYMBOL_MAP={ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_date_key=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.advertiser_key=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_year=fact_activity_advertiser_trans_date.dim_date.year_name, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.num_items_net=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_items_net, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.order_pub_comm_base=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.order_pub_comm_base, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.orderid=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.orderid}, OUTPUT_COLS=[ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_date_key, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.advertiser_key, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_year, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.num_items_net, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.order_pub_comm_base, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.orderid]})                Project(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, fact_activity_advertiser_trans_date.dim_date], props={PROJECT_COLS=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key, fact_activity_advertiser_trans_date.dim_date.year_name AS trans_year, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_items_net, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.order_pub_comm_base, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.orderid], OUTPUT_COLS=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key, fact_activity_advertiser_trans_date.dim_date.year_name AS trans_year, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_items_net, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.order_pub_comm_base, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.orderid]})                  Join(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, fact_activity_advertiser_trans_date.dim_date], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key = fact_activity_advertiser_trans_date.dim_date.date_key], OUTPUT_COLS=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key, fact_activity_advertiser_trans_date.dim_date.year_name, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_items_net, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.order_pub_comm_base, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.orderid]})                    Access(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date], props={SOURCE_HINT=null, MODEL_ID=Schema name=fact_activity_advertiser_trans_date, nameInSource=null, uuid=mmuuid:501c6893-dc93-4ed9-a3b3-be86c10ea039, OUTPUT_COLS=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.creative_type_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.offer_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.publisher_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_items_net, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.order_pub_comm_base, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.orderid]})                      Select(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date], props={SELECT_CRITERIA=(fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key >= '2015-01-01') AND (fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key <= '2015-01-01') AND (fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key = 111)})                        Source(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date], props={OUTPUT_COLS=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.publisher_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.network_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.creative_type_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.offer_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_items_net, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.order_pub_comm_base, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.orderid]})                    Access(groups=[fact_activity_advertiser_trans_date.dim_date])                      Source(groups=[fact_activity_advertiser_trans_date.dim_date])      ============================================================================  EXECUTING MergeVirtual    AFTER:   TupleLimit(groups=[])    Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol0 AS trans_year, convert((anon_grp0.agg0 / convert(anon_grp0.agg1, long)), double) AS net_items_per_order], OUTPUT_COLS=[anon_grp0.gcol0 AS trans_year, convert((anon_grp0.agg0 / convert(anon_grp0.agg1, long)), double) AS net_items_per_order]})      Group(groups=[fact_activity_advertiser_trans_date.dim_date, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, anon_grp0], props={GROUP_COLS=[fact_activity_advertiser_trans_date.dim_date.year_name, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key], SYMBOL_MAP={anon_grp0.gcol0=fact_activity_advertiser_trans_date.dim_date.year_name, anon_grp0.gcol1=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key, anon_grp0.agg0=SUM(fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_items_net), anon_grp0.agg1=COUNT(DISTINCT CASE WHEN fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.order_pub_comm_base >= 0 THEN fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.orderid END)}, OUTPUT_COLS=[anon_grp0.gcol0, anon_grp0.agg0, anon_grp0.agg1]})        Select(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date], props={SELECT_CRITERIA=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key = 111, OUTPUT_COLS=[ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_year, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_date_key, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.num_items_net, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.order_pub_comm_base, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.orderid], IS_PHANTOM=true})          Select(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date], props={SELECT_CRITERIA=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key <= '2015-01-01', OUTPUT_COLS=[ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.advertiser_key, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_year, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_date_key, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.num_items_net, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.order_pub_comm_base, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.orderid], IS_PHANTOM=true})            Select(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date], props={SELECT_CRITERIA=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key >= '2015-01-01', OUTPUT_COLS=[ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_date_key, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.advertiser_key, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.trans_year, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.num_items_net, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.order_pub_comm_base, ActivityAdvertiserTransDate.ActivityAdvertiserTransDate.orderid], IS_PHANTOM=true})              Join(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, fact_activity_advertiser_trans_date.dim_date], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key = fact_activity_advertiser_trans_date.dim_date.date_key], OUTPUT_COLS=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key, fact_activity_advertiser_trans_date.dim_date.year_name, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_items_net, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.order_pub_comm_base, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.orderid]})                Access(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date])                  Select(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date])                    Source(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date])                Access(groups=[fact_activity_advertiser_trans_date.dim_date])                  Source(groups=[fact_activity_advertiser_trans_date.dim_date])      ============================================================================  EXECUTING PushNonJoinCriteria    AFTER:   TupleLimit(groups=[])    Project(groups=[anon_grp0])      Group(groups=[fact_activity_advertiser_trans_date.dim_date, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, anon_grp0])        Select(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date])          Select(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date])            Select(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date])              Join(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, fact_activity_advertiser_trans_date.dim_date], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key = fact_activity_advertiser_trans_date.dim_date.date_key], OUTPUT_COLS=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key, fact_activity_advertiser_trans_date.dim_date.year_name, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_items_net, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.order_pub_comm_base, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.orderid]})                Access(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date])                  Select(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date])                    Source(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date])                Access(groups=[fact_activity_advertiser_trans_date.dim_date])                  Source(groups=[fact_activity_advertiser_trans_date.dim_date])      ============================================================================  EXECUTING CleanCriteria    AFTER:   TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=1, OUTPUT_COLS=null})    Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol0 AS trans_year, convert((anon_grp0.agg0 / convert(anon_grp0.agg1, long)), double) AS net_items_per_order], OUTPUT_COLS=null})      Group(groups=[fact_activity_advertiser_trans_date.dim_date, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, anon_grp0], props={GROUP_COLS=[fact_activity_advertiser_trans_date.dim_date.year_name, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key], SYMBOL_MAP={anon_grp0.gcol0=fact_activity_advertiser_trans_date.dim_date.year_name, anon_grp0.gcol1=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key, anon_grp0.agg0=SUM(fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_items_net), anon_grp0.agg1=COUNT(DISTINCT CASE WHEN fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.order_pub_comm_base >= 0 THEN fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.orderid END)}, OUTPUT_COLS=null})        Select(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date], props={SELECT_CRITERIA=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key = 111, OUTPUT_COLS=null, IS_PHANTOM=true})          Select(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date], props={SELECT_CRITERIA=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key <= '2015-01-01', OUTPUT_COLS=null, IS_PHANTOM=true})            Select(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date], props={SELECT_CRITERIA=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key >= '2015-01-01', OUTPUT_COLS=null, IS_PHANTOM=true})              Join(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, fact_activity_advertiser_trans_date.dim_date], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key = fact_activity_advertiser_trans_date.dim_date.date_key], OUTPUT_COLS=null})                Access(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date], props={SOURCE_HINT=null, MODEL_ID=Schema name=fact_activity_advertiser_trans_date, nameInSource=null, uuid=mmuuid:501c6893-dc93-4ed9-a3b3-be86c10ea039, OUTPUT_COLS=null})                  Select(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date], props={SELECT_CRITERIA=(fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key >= '2015-01-01') AND (fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key <= '2015-01-01') AND (fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key = 111), OUTPUT_COLS=null})                    Source(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date], props={OUTPUT_COLS=null})                Access(groups=[fact_activity_advertiser_trans_date.dim_date], props={SOURCE_HINT=null, IS_OPTIONAL=true, MODEL_ID=Schema name=fact_activity_advertiser_trans_date, nameInSource=null, uuid=mmuuid:501c6893-dc93-4ed9-a3b3-be86c10ea039, OUTPUT_COLS=null})                  Source(groups=[fact_activity_advertiser_trans_date.dim_date], props={OUTPUT_COLS=null})      ============================================================================  EXECUTING RaiseAccess    AFTER:   Access(groups=[fact_activity_advertiser_trans_date.dim_date, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, anon_grp0], props={SOURCE_HINT=null, MODEL_ID=Schema name=fact_activity_advertiser_trans_date, nameInSource=null, uuid=mmuuid:501c6893-dc93-4ed9-a3b3-be86c10ea039, OUTPUT_COLS=null, CONFORMED_SOURCES=null})    TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=1, OUTPUT_COLS=null})      Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol0 AS trans_year, convert((anon_grp0.agg0 / convert(anon_grp0.agg1, long)), double) AS net_items_per_order], OUTPUT_COLS=null})        Group(groups=[fact_activity_advertiser_trans_date.dim_date, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, anon_grp0], props={GROUP_COLS=[fact_activity_advertiser_trans_date.dim_date.year_name, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key], SYMBOL_MAP={anon_grp0.gcol0=fact_activity_advertiser_trans_date.dim_date.year_name, anon_grp0.gcol1=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key, anon_grp0.agg0=SUM(fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_items_net), anon_grp0.agg1=COUNT(DISTINCT CASE WHEN fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.order_pub_comm_base >= 0 THEN fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.orderid END)}, OUTPUT_COLS=null})          Select(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date], props={SELECT_CRITERIA=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key = 111, OUTPUT_COLS=null, IS_PHANTOM=true})            Select(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date], props={SELECT_CRITERIA=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key <= '2015-01-01', OUTPUT_COLS=null, IS_PHANTOM=true})              Select(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date], props={SELECT_CRITERIA=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key >= '2015-01-01', OUTPUT_COLS=null, IS_PHANTOM=true})                Join(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, fact_activity_advertiser_trans_date.dim_date], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key = fact_activity_advertiser_trans_date.dim_date.date_key], OUTPUT_COLS=null, MODEL_ID=Schema name=fact_activity_advertiser_trans_date, nameInSource=null, uuid=mmuuid:501c6893-dc93-4ed9-a3b3-be86c10ea039})                  Select(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date], props={SELECT_CRITERIA=(fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key >= '2015-01-01') AND (fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key <= '2015-01-01') AND (fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key = 111), OUTPUT_COLS=null})                    Source(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date])                  Source(groups=[fact_activity_advertiser_trans_date.dim_date], props={OUTPUT_COLS=null})      ============================================================================  EXECUTING CopyCriteria    AFTER:   Access(groups=[fact_activity_advertiser_trans_date.dim_date, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, anon_grp0])    TupleLimit(groups=[])      Project(groups=[anon_grp0])        Group(groups=[fact_activity_advertiser_trans_date.dim_date, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, anon_grp0])          Select(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date], props={SELECT_CRITERIA=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key = 111, OUTPUT_COLS=null, IS_PHANTOM=true, IS_COPIED=true})            Select(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date], props={SELECT_CRITERIA=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key <= '2015-01-01', OUTPUT_COLS=null, IS_PHANTOM=true, IS_COPIED=true})              Select(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date], props={SELECT_CRITERIA=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key >= '2015-01-01', OUTPUT_COLS=null, IS_PHANTOM=true, IS_COPIED=true})                Join(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, fact_activity_advertiser_trans_date.dim_date], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key = fact_activity_advertiser_trans_date.dim_date.date_key, fact_activity_advertiser_trans_date.dim_date.date_key >= '2015-01-01', fact_activity_advertiser_trans_date.dim_date.date_key <= '2015-01-01'], OUTPUT_COLS=null, MODEL_ID=Schema name=fact_activity_advertiser_trans_date, nameInSource=null, uuid=mmuuid:501c6893-dc93-4ed9-a3b3-be86c10ea039, IS_COPIED=true})                  Select(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date], props={SELECT_CRITERIA=(fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key >= '2015-01-01') AND (fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key <= '2015-01-01') AND (fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key = 111), OUTPUT_COLS=null, IS_COPIED=true})                    Source(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date])                  Source(groups=[fact_activity_advertiser_trans_date.dim_date])      ============================================================================  EXECUTING PushNonJoinCriteria    AFTER:   Access(groups=[fact_activity_advertiser_trans_date.dim_date, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, anon_grp0])    TupleLimit(groups=[])      Project(groups=[anon_grp0])        Group(groups=[fact_activity_advertiser_trans_date.dim_date, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, anon_grp0])          Select(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date])            Select(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date])              Select(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date])                Join(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, fact_activity_advertiser_trans_date.dim_date], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key = fact_activity_advertiser_trans_date.dim_date.date_key], OUTPUT_COLS=null, MODEL_ID=Schema name=fact_activity_advertiser_trans_date, nameInSource=null, uuid=mmuuid:501c6893-dc93-4ed9-a3b3-be86c10ea039, IS_COPIED=true})                  Select(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date])                    Source(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date])                  Select(groups=[fact_activity_advertiser_trans_date.dim_date], props={SELECT_CRITERIA=fact_activity_advertiser_trans_date.dim_date.date_key <= '2015-01-01'})                    Select(groups=[fact_activity_advertiser_trans_date.dim_date], props={SELECT_CRITERIA=fact_activity_advertiser_trans_date.dim_date.date_key >= '2015-01-01'})                      Source(groups=[fact_activity_advertiser_trans_date.dim_date], props={OUTPUT_COLS=null})      ============================================================================  EXECUTING PushSelectCriteria    AFTER:   Access(groups=[fact_activity_advertiser_trans_date.dim_date, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, anon_grp0])    TupleLimit(groups=[])      Project(groups=[anon_grp0])        Group(groups=[fact_activity_advertiser_trans_date.dim_date, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, anon_grp0])          Select(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date], props={SELECT_CRITERIA=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key = 111, OUTPUT_COLS=null, IS_PHANTOM=true, IS_COPIED=true})            Select(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date], props={SELECT_CRITERIA=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key <= '2015-01-01', OUTPUT_COLS=null, IS_PHANTOM=true, IS_COPIED=true})              Select(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date], props={SELECT_CRITERIA=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key >= '2015-01-01', OUTPUT_COLS=null, IS_PHANTOM=true, IS_COPIED=true})                Join(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, fact_activity_advertiser_trans_date.dim_date])                  Select(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date], props={SELECT_CRITERIA=(fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key >= '2015-01-01') AND (fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key <= '2015-01-01') AND (fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key = 111), OUTPUT_COLS=null, IS_COPIED=true})                    Source(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date])                  Select(groups=[fact_activity_advertiser_trans_date.dim_date])                    Select(groups=[fact_activity_advertiser_trans_date.dim_date])                      Source(groups=[fact_activity_advertiser_trans_date.dim_date])      ============================================================================  EXECUTING RaiseAccess    AFTER:   Access(groups=[fact_activity_advertiser_trans_date.dim_date, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, anon_grp0])    TupleLimit(groups=[])      Project(groups=[anon_grp0])        Group(groups=[fact_activity_advertiser_trans_date.dim_date, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, anon_grp0])          Select(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date])            Select(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date])              Select(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date])                Join(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, fact_activity_advertiser_trans_date.dim_date])                  Select(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date])                    Source(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date])                  Select(groups=[fact_activity_advertiser_trans_date.dim_date])                    Select(groups=[fact_activity_advertiser_trans_date.dim_date])                      Source(groups=[fact_activity_advertiser_trans_date.dim_date])      ============================================================================  EXECUTING CopyCriteria    AFTER:   Access(groups=[fact_activity_advertiser_trans_date.dim_date, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, anon_grp0])    TupleLimit(groups=[])      Project(groups=[anon_grp0])        Group(groups=[fact_activity_advertiser_trans_date.dim_date, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, anon_grp0])          Select(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date], props={SELECT_CRITERIA=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key = 111, OUTPUT_COLS=null, IS_PHANTOM=true, IS_COPIED=true})            Select(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date], props={SELECT_CRITERIA=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key <= '2015-01-01', OUTPUT_COLS=null, IS_PHANTOM=true, IS_COPIED=true})              Select(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date], props={SELECT_CRITERIA=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key >= '2015-01-01', OUTPUT_COLS=null, IS_PHANTOM=true, IS_COPIED=true})                Join(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, fact_activity_advertiser_trans_date.dim_date], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key = fact_activity_advertiser_trans_date.dim_date.date_key], OUTPUT_COLS=null, MODEL_ID=Schema name=fact_activity_advertiser_trans_date, nameInSource=null, uuid=mmuuid:501c6893-dc93-4ed9-a3b3-be86c10ea039, IS_COPIED=true})                  Select(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date], props={SELECT_CRITERIA=(fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key >= '2015-01-01') AND (fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key <= '2015-01-01') AND (fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key = 111), OUTPUT_COLS=null, IS_COPIED=true})                    Source(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date])                  Select(groups=[fact_activity_advertiser_trans_date.dim_date], props={SELECT_CRITERIA=fact_activity_advertiser_trans_date.dim_date.date_key <= '2015-01-01', IS_COPIED=true})                    Select(groups=[fact_activity_advertiser_trans_date.dim_date], props={SELECT_CRITERIA=fact_activity_advertiser_trans_date.dim_date.date_key >= '2015-01-01', IS_COPIED=true})                      Source(groups=[fact_activity_advertiser_trans_date.dim_date])      ============================================================================  EXECUTING CleanCriteria    AFTER:   Access(groups=[fact_activity_advertiser_trans_date.dim_date, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, anon_grp0], props={SOURCE_HINT=null, MODEL_ID=Schema name=fact_activity_advertiser_trans_date, nameInSource=null, uuid=mmuuid:501c6893-dc93-4ed9-a3b3-be86c10ea039, OUTPUT_COLS=null, CONFORMED_SOURCES=null})    TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=1, OUTPUT_COLS=null})      Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol0 AS trans_year, convert((anon_grp0.agg0 / convert(anon_grp0.agg1, long)), double) AS net_items_per_order], OUTPUT_COLS=null})        Group(groups=[fact_activity_advertiser_trans_date.dim_date, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, anon_grp0], props={GROUP_COLS=[fact_activity_advertiser_trans_date.dim_date.year_name, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key], SYMBOL_MAP={anon_grp0.gcol0=fact_activity_advertiser_trans_date.dim_date.year_name, anon_grp0.gcol1=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key, anon_grp0.agg0=SUM(fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_items_net), anon_grp0.agg1=COUNT(DISTINCT CASE WHEN fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.order_pub_comm_base >= 0 THEN fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.orderid END)}, OUTPUT_COLS=null})          Join(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, fact_activity_advertiser_trans_date.dim_date], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key = fact_activity_advertiser_trans_date.dim_date.date_key], OUTPUT_COLS=null, MODEL_ID=Schema name=fact_activity_advertiser_trans_date, nameInSource=null, uuid=mmuuid:501c6893-dc93-4ed9-a3b3-be86c10ea039, IS_COPIED=true})            Select(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date], props={SELECT_CRITERIA=(fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key >= '2015-01-01') AND (fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key <= '2015-01-01') AND (fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key = 111), OUTPUT_COLS=null, IS_COPIED=true})              Source(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date], props={OUTPUT_COLS=null})            Select(groups=[fact_activity_advertiser_trans_date.dim_date], props={SELECT_CRITERIA=fact_activity_advertiser_trans_date.dim_date.date_key <= '2015-01-01', IS_COPIED=true, OUTPUT_COLS=null})              Select(groups=[fact_activity_advertiser_trans_date.dim_date], props={SELECT_CRITERIA=fact_activity_advertiser_trans_date.dim_date.date_key >= '2015-01-01', IS_COPIED=true, OUTPUT_COLS=null})                Source(groups=[fact_activity_advertiser_trans_date.dim_date], props={OUTPUT_COLS=null})      ============================================================================  EXECUTING PlanJoins    AFTER:   Access(groups=[fact_activity_advertiser_trans_date.dim_date, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, anon_grp0])    TupleLimit(groups=[])      Project(groups=[anon_grp0])        Group(groups=[fact_activity_advertiser_trans_date.dim_date, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, anon_grp0])          Join(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, fact_activity_advertiser_trans_date.dim_date])            Select(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date])              Source(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date])            Select(groups=[fact_activity_advertiser_trans_date.dim_date])              Select(groups=[fact_activity_advertiser_trans_date.dim_date])                Source(groups=[fact_activity_advertiser_trans_date.dim_date])      ============================================================================  EXECUTING PushSelectCriteria    AFTER:   Access(groups=[fact_activity_advertiser_trans_date.dim_date, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, anon_grp0])    TupleLimit(groups=[])      Project(groups=[anon_grp0])        Group(groups=[fact_activity_advertiser_trans_date.dim_date, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, anon_grp0])          Join(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, fact_activity_advertiser_trans_date.dim_date])            Select(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date], props={SELECT_CRITERIA=(fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key >= '2015-01-01') AND (fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key <= '2015-01-01') AND (fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key = 111), OUTPUT_COLS=null, IS_COPIED=true})              Source(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date])            Select(groups=[fact_activity_advertiser_trans_date.dim_date], props={SELECT_CRITERIA=fact_activity_advertiser_trans_date.dim_date.date_key <= '2015-01-01', IS_COPIED=true, OUTPUT_COLS=null})              Select(groups=[fact_activity_advertiser_trans_date.dim_date], props={SELECT_CRITERIA=fact_activity_advertiser_trans_date.dim_date.date_key >= '2015-01-01', IS_COPIED=true, OUTPUT_COLS=null})                Source(groups=[fact_activity_advertiser_trans_date.dim_date])      ============================================================================  EXECUTING RaiseAccess    AFTER:   Access(groups=[fact_activity_advertiser_trans_date.dim_date, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, anon_grp0])    TupleLimit(groups=[])      Project(groups=[anon_grp0])        Group(groups=[fact_activity_advertiser_trans_date.dim_date, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, anon_grp0])          Join(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, fact_activity_advertiser_trans_date.dim_date])            Select(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date])              Source(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date])            Select(groups=[fact_activity_advertiser_trans_date.dim_date])              Select(groups=[fact_activity_advertiser_trans_date.dim_date])                Source(groups=[fact_activity_advertiser_trans_date.dim_date])      ============================================================================  EXECUTING ChooseJoinStrategy    AFTER:   Access(groups=[fact_activity_advertiser_trans_date.dim_date, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, anon_grp0])    TupleLimit(groups=[])      Project(groups=[anon_grp0])        Group(groups=[fact_activity_advertiser_trans_date.dim_date, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, anon_grp0])          Join(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, fact_activity_advertiser_trans_date.dim_date])            Select(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date])              Source(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date])            Select(groups=[fact_activity_advertiser_trans_date.dim_date])              Select(groups=[fact_activity_advertiser_trans_date.dim_date])                Source(groups=[fact_activity_advertiser_trans_date.dim_date])      ============================================================================  EXECUTING ChooseDependent    AFTER:   Access(groups=[fact_activity_advertiser_trans_date.dim_date, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, anon_grp0])    TupleLimit(groups=[])      Project(groups=[anon_grp0])        Group(groups=[fact_activity_advertiser_trans_date.dim_date, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, anon_grp0])          Join(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, fact_activity_advertiser_trans_date.dim_date])            Select(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date])              Source(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date])            Select(groups=[fact_activity_advertiser_trans_date.dim_date])              Select(groups=[fact_activity_advertiser_trans_date.dim_date])                Source(groups=[fact_activity_advertiser_trans_date.dim_date])      ============================================================================  EXECUTING PushAggregates    AFTER:   Access(groups=[fact_activity_advertiser_trans_date.dim_date, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, anon_grp0])    TupleLimit(groups=[])      Project(groups=[anon_grp0])        Group(groups=[fact_activity_advertiser_trans_date.dim_date, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, anon_grp0])          Join(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, fact_activity_advertiser_trans_date.dim_date])            Select(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date])              Source(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date])            Select(groups=[fact_activity_advertiser_trans_date.dim_date])              Select(groups=[fact_activity_advertiser_trans_date.dim_date])                Source(groups=[fact_activity_advertiser_trans_date.dim_date])      ============================================================================  EXECUTING ChooseDependent    AFTER:   Access(groups=[fact_activity_advertiser_trans_date.dim_date, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, anon_grp0])    TupleLimit(groups=[])      Project(groups=[anon_grp0])        Group(groups=[fact_activity_advertiser_trans_date.dim_date, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, anon_grp0])          Join(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, fact_activity_advertiser_trans_date.dim_date])            Select(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date])              Source(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date])            Select(groups=[fact_activity_advertiser_trans_date.dim_date])              Select(groups=[fact_activity_advertiser_trans_date.dim_date])                Source(groups=[fact_activity_advertiser_trans_date.dim_date])      ============================================================================  EXECUTING PushLimit    AFTER:   Access(groups=[fact_activity_advertiser_trans_date.dim_date, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, anon_grp0])    TupleLimit(groups=[])      Project(groups=[anon_grp0])        Group(groups=[fact_activity_advertiser_trans_date.dim_date, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, anon_grp0])          Join(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, fact_activity_advertiser_trans_date.dim_date])            Select(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date])              Source(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date])            Select(groups=[fact_activity_advertiser_trans_date.dim_date])              Select(groups=[fact_activity_advertiser_trans_date.dim_date])                Source(groups=[fact_activity_advertiser_trans_date.dim_date])      ============================================================================  EXECUTING AssignOutputElements    AFTER:   Access(groups=[fact_activity_advertiser_trans_date.dim_date, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, anon_grp0], props={SOURCE_HINT=null, MODEL_ID=Schema name=fact_activity_advertiser_trans_date, nameInSource=null, uuid=mmuuid:501c6893-dc93-4ed9-a3b3-be86c10ea039, OUTPUT_COLS=[anon_grp0.gcol0 AS trans_year, convert((anon_grp0.agg0 / convert(anon_grp0.agg1, long)), double) AS net_items_per_order], CONFORMED_SOURCES=null})    TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=1, OUTPUT_COLS=[anon_grp0.gcol0 AS trans_year, convert((anon_grp0.agg0 / convert(anon_grp0.agg1, long)), double) AS net_items_per_order]})      Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol0 AS trans_year, convert((anon_grp0.agg0 / convert(anon_grp0.agg1, long)), double) AS net_items_per_order], OUTPUT_COLS=[anon_grp0.gcol0 AS trans_year, convert((anon_grp0.agg0 / convert(anon_grp0.agg1, long)), double) AS net_items_per_order]})        Group(groups=[fact_activity_advertiser_trans_date.dim_date, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, anon_grp0], props={GROUP_COLS=[fact_activity_advertiser_trans_date.dim_date.year_name, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key], SYMBOL_MAP={anon_grp0.gcol0=fact_activity_advertiser_trans_date.dim_date.year_name, anon_grp0.gcol1=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key, anon_grp0.agg0=SUM(fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_items_net), anon_grp0.agg1=COUNT(DISTINCT CASE WHEN fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.order_pub_comm_base >= 0 THEN fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.orderid END)}, OUTPUT_COLS=[anon_grp0.gcol0, anon_grp0.agg0, anon_grp0.agg1]})          Join(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, fact_activity_advertiser_trans_date.dim_date], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key = fact_activity_advertiser_trans_date.dim_date.date_key], OUTPUT_COLS=[fact_activity_advertiser_trans_date.dim_date.year_name, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_items_net, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.order_pub_comm_base, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.orderid], MODEL_ID=Schema name=fact_activity_advertiser_trans_date, nameInSource=null, uuid=mmuuid:501c6893-dc93-4ed9-a3b3-be86c10ea039, IS_COPIED=true})            Select(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date], props={SELECT_CRITERIA=(fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key >= '2015-01-01') AND (fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key <= '2015-01-01') AND (fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key = 111), OUTPUT_COLS=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_items_net, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.order_pub_comm_base, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.orderid], IS_COPIED=true})              Source(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date], props={OUTPUT_COLS=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_items_net, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.order_pub_comm_base, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.orderid]})            Select(groups=[fact_activity_advertiser_trans_date.dim_date], props={SELECT_CRITERIA=fact_activity_advertiser_trans_date.dim_date.date_key <= '2015-01-01', IS_COPIED=true, OUTPUT_COLS=[fact_activity_advertiser_trans_date.dim_date.date_key, fact_activity_advertiser_trans_date.dim_date.year_name]})              Select(groups=[fact_activity_advertiser_trans_date.dim_date], props={SELECT_CRITERIA=fact_activity_advertiser_trans_date.dim_date.date_key >= '2015-01-01', IS_COPIED=true, OUTPUT_COLS=[fact_activity_advertiser_trans_date.dim_date.date_key, fact_activity_advertiser_trans_date.dim_date.year_name]})                Source(groups=[fact_activity_advertiser_trans_date.dim_date], props={OUTPUT_COLS=[fact_activity_advertiser_trans_date.dim_date.date_key, fact_activity_advertiser_trans_date.dim_date.year_name]})      ============================================================================  EXECUTING CalculateCost    AFTER:   Access(groups=[fact_activity_advertiser_trans_date.dim_date, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, anon_grp0], props={SOURCE_HINT=null, MODEL_ID=Schema name=fact_activity_advertiser_trans_date, nameInSource=null, uuid=mmuuid:501c6893-dc93-4ed9-a3b3-be86c10ea039, OUTPUT_COLS=[anon_grp0.gcol0 AS trans_year, convert((anon_grp0.agg0 / convert(anon_grp0.agg1, long)), double) AS net_items_per_order], CONFORMED_SOURCES=null, EST_CARDINALITY=1.0, EST_COL_STATS={anon_grp0.gcol0 AS trans_year=[1.0, 1.0], convert((anon_grp0.agg0 / convert(anon_grp0.agg1, long)), double) AS net_items_per_order=[1.0, 1.0]}})    TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=1, OUTPUT_COLS=[anon_grp0.gcol0 AS trans_year, convert((anon_grp0.agg0 / convert(anon_grp0.agg1, long)), double) AS net_items_per_order], EST_CARDINALITY=1.0, EST_COL_STATS={anon_grp0.gcol0 AS trans_year=[1.0, 0.0], convert((anon_grp0.agg0 / convert(anon_grp0.agg1, long)), double) AS net_items_per_order=[1.0, 0.0]}})      Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol0 AS trans_year, convert((anon_grp0.agg0 / convert(anon_grp0.agg1, long)), double) AS net_items_per_order], OUTPUT_COLS=[anon_grp0.gcol0 AS trans_year, convert((anon_grp0.agg0 / convert(anon_grp0.agg1, long)), double) AS net_items_per_order], EST_CARDINALITY=-1.0})        Group(groups=[fact_activity_advertiser_trans_date.dim_date, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, anon_grp0], props={GROUP_COLS=[fact_activity_advertiser_trans_date.dim_date.year_name, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key], SYMBOL_MAP={anon_grp0.gcol0=fact_activity_advertiser_trans_date.dim_date.year_name, anon_grp0.gcol1=fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key, anon_grp0.agg0=SUM(fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_items_net), anon_grp0.agg1=COUNT(DISTINCT CASE WHEN fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.order_pub_comm_base >= 0 THEN fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.orderid END)}, OUTPUT_COLS=[anon_grp0.gcol0, anon_grp0.agg0, anon_grp0.agg1], EST_CARDINALITY=-1.0})          Join(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, fact_activity_advertiser_trans_date.dim_date], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key = fact_activity_advertiser_trans_date.dim_date.date_key], OUTPUT_COLS=[fact_activity_advertiser_trans_date.dim_date.year_name, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_items_net, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.order_pub_comm_base, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.orderid], MODEL_ID=Schema name=fact_activity_advertiser_trans_date, nameInSource=null, uuid=mmuuid:501c6893-dc93-4ed9-a3b3-be86c10ea039, IS_COPIED=true, EST_CARDINALITY=-1.0})            Select(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date], props={SELECT_CRITERIA=(fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key >= '2015-01-01') AND (fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key <= '2015-01-01') AND (fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key = 111), OUTPUT_COLS=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_items_net, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.order_pub_comm_base, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.orderid], IS_COPIED=true, EST_CARDINALITY=-1.0})              Source(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date], props={OUTPUT_COLS=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_items_net, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.order_pub_comm_base, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.orderid], EST_COL_STATS={fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key=[-1.0, -1.0], fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key=[-1.0, -1.0], fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_items_net=[-1.0, -1.0], fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.order_pub_comm_base=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0})            Select(groups=[fact_activity_advertiser_trans_date.dim_date], props={SELECT_CRITERIA=fact_activity_advertiser_trans_date.dim_date.date_key <= '2015-01-01', IS_COPIED=true, OUTPUT_COLS=[fact_activity_advertiser_trans_date.dim_date.date_key, fact_activity_advertiser_trans_date.dim_date.year_name], EST_CARDINALITY=-1.0})              Select(groups=[fact_activity_advertiser_trans_date.dim_date], props={SELECT_CRITERIA=fact_activity_advertiser_trans_date.dim_date.date_key >= '2015-01-01', IS_COPIED=true, OUTPUT_COLS=[fact_activity_advertiser_trans_date.dim_date.date_key, fact_activity_advertiser_trans_date.dim_date.year_name], EST_CARDINALITY=-1.0})                Source(groups=[fact_activity_advertiser_trans_date.dim_date], props={OUTPUT_COLS=[fact_activity_advertiser_trans_date.dim_date.date_key, fact_activity_advertiser_trans_date.dim_date.year_name], EST_COL_STATS={fact_activity_advertiser_trans_date.dim_date.date_key=[-1.0, -1.0], fact_activity_advertiser_trans_date.dim_date.year_name=[-1.0, -1.0]}, EST_CARDINALITY=-1.0})      ============================================================================  EXECUTING ImplementJoinStrategy    AFTER:   Access(groups=[fact_activity_advertiser_trans_date.dim_date, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, anon_grp0])    TupleLimit(groups=[])      Project(groups=[anon_grp0])        Group(groups=[fact_activity_advertiser_trans_date.dim_date, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, anon_grp0])          Join(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, fact_activity_advertiser_trans_date.dim_date])            Select(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date])              Source(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date])            Select(groups=[fact_activity_advertiser_trans_date.dim_date])              Select(groups=[fact_activity_advertiser_trans_date.dim_date])                Source(groups=[fact_activity_advertiser_trans_date.dim_date])      ============================================================================  EXECUTING MergeCriteria    AFTER:   Access(groups=[fact_activity_advertiser_trans_date.dim_date, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, anon_grp0])    TupleLimit(groups=[])      Project(groups=[anon_grp0])        Group(groups=[fact_activity_advertiser_trans_date.dim_date, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, anon_grp0])          Join(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, fact_activity_advertiser_trans_date.dim_date])            Select(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date])              Source(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date])            Select(groups=[fact_activity_advertiser_trans_date.dim_date])              Select(groups=[fact_activity_advertiser_trans_date.dim_date])                Source(groups=[fact_activity_advertiser_trans_date.dim_date])      ============================================================================  EXECUTING PlanSorts    AFTER:   Access(groups=[fact_activity_advertiser_trans_date.dim_date, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, anon_grp0])    TupleLimit(groups=[])      Project(groups=[anon_grp0])        Group(groups=[fact_activity_advertiser_trans_date.dim_date, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, anon_grp0])          Join(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, fact_activity_advertiser_trans_date.dim_date])            Select(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date])              Source(groups=[fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date])            Select(groups=[fact_activity_advertiser_trans_date.dim_date])              Select(groups=[fact_activity_advertiser_trans_date.dim_date])                Source(groups=[fact_activity_advertiser_trans_date.dim_date])      ============================================================================  EXECUTING CollapseSource    AFTER:   Access(groups=[fact_activity_advertiser_trans_date.dim_date, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date, anon_grp0], props={SOURCE_HINT=null, MODEL_ID=Schema name=fact_activity_advertiser_trans_date, nameInSource=null, uuid=mmuuid:501c6893-dc93-4ed9-a3b3-be86c10ea039, OUTPUT_COLS=[anon_grp0.gcol0 AS trans_year, convert((anon_grp0.agg0 / convert(anon_grp0.agg1, long)), double) AS net_items_per_order], CONFORMED_SOURCES=null, EST_CARDINALITY=1.0, EST_COL_STATS={anon_grp0.gcol0 AS trans_year=[1.0, 1.0], convert((anon_grp0.agg0 / convert(anon_grp0.agg1, long)), double) AS net_items_per_order=[1.0, 1.0]}, ATOMIC_REQUEST=SELECT fact_activity_advertiser_trans_date.dim_date.year_name AS trans_year, convert((SUM(fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.num_items_net) / convert(COUNT(DISTINCT CASE WHEN fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.order_pub_comm_base >= 0 THEN fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.orderid END), long)), double) AS net_items_per_order FROM fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date INNER JOIN fact_activity_advertiser_trans_date.dim_date ON fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key = fact_activity_advertiser_trans_date.dim_date.date_key WHERE (fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key >= '2015-01-01') AND (fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key <= '2015-01-01') AND (fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.advertiser_key = 111) AND (fact_activity_advertiser_trans_date.dim_date.date_key >= '2015-01-01') AND (fact_activity_advertiser_trans_date.dim_date.date_key <= '2015-01-01') GROUP BY fact_activity_advertiser_trans_date.dim_date.year_name, fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date.trans_date_key LIMIT 1})      ============================================================================  CONVERTING PLAN TREE TO PROCESS TREE    PROCESS PLAN =   AccessNode(1) output=[anon_grp0.gcol0 AS trans_year, convert((anon_grp0.agg0 / convert(anon_grp0.agg1, long)), double) AS net_items_per_order] SELECT g_1.year_name AS c_0, convert((SUM(g_0.num_items_net) / convert(COUNT(DISTINCT CASE WHEN g_0.order_pub_comm_base >= 0 THEN g_0.orderid END), long)), double) AS c_1 FROM fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date AS g_0 INNER JOIN fact_activity_advertiser_trans_date.dim_date AS g_1 ON g_0.trans_date_key = g_1.date_key WHERE (g_0.trans_date_key >= '2015-01-01') AND (g_0.trans_date_key <= '2015-01-01') AND (g_0.advertiser_key = 111) AND (g_1.date_key >= '2015-01-01') AND (g_1.date_key <= '2015-01-01') GROUP BY g_1.year_name, g_0.trans_date_key LIMIT 1    ============================================================================    ----------------------------------------------------------------------------  OPTIMIZATION COMPLETE:  PROCESSOR PLAN:  AccessNode(1) output=[anon_grp0.gcol0 AS trans_year, convert((anon_grp0.agg0 / convert(anon_grp0.agg1, long)), double) AS net_items_per_order] SELECT g_1.year_name AS c_0, convert((SUM(g_0.num_items_net) / convert(COUNT(DISTINCT CASE WHEN g_0.order_pub_comm_base >= 0 THEN g_0.orderid END), long)), double) AS c_1 FROM fact_activity_advertiser_trans_date.fact_activity_advertiser_trans_date AS g_0 INNER JOIN fact_activity_advertiser_trans_date.dim_date AS g_1 ON g_0.trans_date_key = g_1.date_key WHERE (g_0.trans_date_key >= '2015-01-01') AND (g_0.trans_date_key <= '2015-01-01') AND (g_0.advertiser_key = 111) AND (g_1.date_key >= '2015-01-01') AND (g_1.date_key <= '2015-01-01') GROUP BY g_1.year_name, g_0.trans_date_key LIMIT 1    ============================================================================  
1> set showplan off
2> go
(0 rows affected)
(0 rows affected)
1> Elapsed Time:  0 hr, 0 min, 5 sec, 694 ms.
2> go