Dong Shin 02.12.2014

  • deployed new queries to update COGNOS data mapping – working!
  • changed Reqonciler to retrieve the list of queries in ‘order’ order…
  • working on reconfiguring Commited Amounts/Date in Query Builder
    • created view for Committed Amount/Date – __view_committed_totals
      • CREATE ALGORITHM = UNDEFINED VIEW `__view_committed_totals` AS SELECT budget_center_id, MAX( committed_date ) AS committed_date, SUM( committed_amount ) AS committed_amount, GROUP_CONCAT( committed_amount )
        FROM `committed_amounts`
        GROUP BY budget_center_id
    • added __view_committed_totals join queryBuilderConfig.xml – vct
    • change queries – committed_date to vct.committed_date in queries!