- VizTool meeting cancelled
- Weird PA problem. SQL error I saw at the Mill happened on-site, couldn’t figure out how it was able run before…. restored to 02.04 version
- removed the Status “(UNFUNDED)” from the PA – ProjectStatusItemRenderer
- built PA for deployment tomorrow
- working on ProjectManager
- created vendors, contracts_cognos tables
- added sample data from Excel spreadsheets to the tables
- query to generate contracts data
- SELECT c.budget_center, c.appropriation_year, c.po_reference, c.acr, v.vendor_name, v.address_line_1, v.city, v.postal_code, c.committed_date, c.committed_amount, c.obligation_date, c.obligated_amount, c.expensed_date, c.expensed_amount, v.vendor_id, v.vendor_abbr, c.po_start_date, c.po_end_date, c.contract_type, c.po_type_code, c.contract_no
FROM contracts_cognos c
LEFT OUTER JOIN vendors AS v ON c.vendor_id = v.vendor_id
- SELECT c.budget_center, c.appropriation_year, c.po_reference, c.acr, v.vendor_name, v.address_line_1, v.city, v.postal_code, c.committed_date, c.committed_amount, c.obligation_date, c.obligated_amount, c.expensed_date, c.expensed_amount, v.vendor_id, v.vendor_abbr, c.po_start_date, c.po_end_date, c.contract_type, c.po_type_code, c.contract_no
viztales
Dimension reduction, State, Orientation, and Speed
viztales 