Dong Shin 02.21.2014

  • working on the query for Lenny/Chris
    • capability AS Capability, bcc.budget_center_name AS ‘Budget Center’, req_id AS ‘Req ID’, req_description AS ‘Req Title’, vrt.req_id_total AS ‘Req Funded Amount’,
      SUM(IF(o.type=’Planned Outlay $:’,month_1,0)) AS ‘Oct 14′,
      SUM(IF(o.type=’Planned Outlay $:’,month_2,0)) AS ‘Nov 14′,
      SUM(IF(o.type=’Planned Outlay $:’,month_3,0)) AS ‘Dec 14′,
      SUM(IF(o.type=’Planned Outlay $:’,month_4,0)) AS ‘Jan 14′,
      SUM(IF(o.type=’Planned Outlay $:’,month_5,0)) AS ‘Feb 14′,
      SUM(IF(o.type=’Planned Outlay $:’,month_6,0)) AS ‘Mar 14′,
      SUM(IF(o.type=’Planned Outlay $:’,month_7,0)) AS ‘Apr 14′,
      SUM(IF(o.type=’Planned Outlay $:’,month_8,0)) AS ‘May 14′,
      SUM(IF(o.type=’Planned Outlay $:’,month_9,0)) AS ‘Jun 14′,
      SUM(IF(o.type=’Planned Outlay $:’,month_10,0)) AS ‘Jul 14′,
      SUM(IF(o.type=’Planned Outlay $:’,month_11,0)) AS ‘Aug 14′,
      SUM(IF(o.type=’Planned Outlay $:’,month_12,0)) AS ‘Sep 14’
      WHERE fiscal_year = 2014
      GROUP BY capability, req_id
    • getting the second year will be tricky….