Category Archives: VISIBILITY

Phil 12.3.13

8:00 – 4:00 SR

  • Backups
  • SQL changes
  • Changes made to queries in query builder are not updating correctly
  • Obligations may only be appearing in the month that they occurred. They need to carry forward, then overwrite as the next obligation comes in.
  • Still a problem with EAs. Req assistent shows correct outlays through September of the first year, but is blank in October of the second year, then roughly four times the amount that it should be. Queries are wrong, with no discernible pattern. MIPRs are ok.
  • Change “Committed Amount” to REQ Funded Amount”
  • Got spreadsheets ingesting
  • Found a date bug that may have had something to do with ints vs. longs. Adding more lines fixed the problem.

Dong Shin 12.02.2013

  • tried the failed query back at the office, no success? How did I run this?
  • new query to update obligations/outlays….
  • UPDATE obligations_outlays o1
    JOIN obligations_outlays o2
    ON o1.funding_id = o2.funding_id AND o1.project_id = o2.project_id
    SET o1.month_1 = o1.month_1 + IF(ISNULL(o2.month_12), 0, o2.month_12),
    o1.month_2 = o1.month_2 + IF(ISNULL(o2.month_12), 0, o2.month_12),
    o1.month_3 = o1.month_3 + IF(ISNULL(o2.month_12), 0, o2.month_12),
    o1.month_4 = o1.month_4 + IF(ISNULL(o2.month_12), 0, o2.month_12),
    o1.month_5 = o1.month_5 + IF(ISNULL(o2.month_12), 0, o2.month_12),
    o1.month_6 = o1.month_6 + IF(ISNULL(o2.month_12), 0, o2.month_12),
    o1.month_7 = o1.month_7 + IF(ISNULL(o2.month_12), 0, o2.month_12),
    o1.month_8 = o1.month_8 + IF(ISNULL(o2.month_12), 0, o2.month_12),
    o1.month_9 = o1.month_9 + IF(ISNULL(o2.month_12), 0, o2.month_12),
    o1.month_10 = o1.month_10 + IF(ISNULL(o2.month_12), 0, o2.month_12),
    o1.month_11 = o1.month_11 + IF(ISNULL(o2.month_12), 0, o2.month_12),
    o1.month_12 = o1.month_12 + IF(ISNULL(o2.month_12), 0, o2.month_12),
    WHERE o1.type = ‘Outlay $ (Reported in FACTS)’ AND (o1.year + o1.year_count) <= (IF(MONTH(CURDATE()) > 9, YEAR(CURDATE()) + 2, YEAR(CURDATE()) + 1))
    AND o1.year_count = 2
    AND o2.type = ‘Outlay $ (Reported in FACTS)’ AND o2.year_count = 1

Phil 11.29.13

8:00 – 10:30 SR

  • Backups
  • Paperwork – finally worked out the receipts from the YUIconf trip.
  • Timesheets!

10:00 – 4:00 FP

  • Checked to see if learning time made was significant. Nope.
  • Make any changes to Ravi’s paper
  • Change all references to “normalized” reaction times to “percentage”. Hopefully that will be more clear.
  • Cut down paper to 6 (CHI WIP format) and 2 page (Haptics or 3DUI?)  versions.
  • If the office is open, run ANOVA on the time-to-learn (session 2 – session 1)

Phil 11.27.13

8:00 – 4:00 SR

  • One day the sky will be blue again…
  • Backups
  • Deployed new FA
  • Got completely flummoxed about why the year-summing query is misbehaving. Numerous attempts to fix, with no joy. Dong’s going to mull this one over the holiday
  • Working on iterating over sub-budget centers to write out correct data. Once that’s working, I start on screwing it up.
    • Committed date(s)
    • Committed amount(s)
    • Obligation date(s)
    • Obligation amount(s)
    • Expensed date(s)
    • Expensed amount(s)
    • Iterate over all SBCs and add lines from SBCs that have their project set.
    • A random number of rows >= 1 gets returned.  Data is synthesized from the ObligationOutlays class.
  • Done and running. Need to make a little more general. Right now there are only two rows per type – an entry from halfway from today to the beginning of teh project and an entry from last week.

Dong Shin 11.26.2013

  • deployed new FA/RA
    • outlay not adding up from the previous year
    • add Total Funded to Project Mgmt Panel
  • working on FA
    • query to update second year of Outlays
    • UPDATE obligations_outlays o1,
      (SELECT month_12 FROM obligations_outlays oo2 WHERE type = ‘Outlay $ (Reported in FACTS)’ AND year_count = 1
      AND o1.funding_id = o2.funding_id AND o1.project_id = o2.project_id
      ) AS o2
      SET o1.month_1 = o2.month_12 + o1.month_1,
      o1.month_2 = o2.month_12 + o1.month_2,
      o1.month_3 = o2.month_12 + o1.month_3,
      o1.month_4 = o2.month_12 + o1.month_4,
      o1.month_5 = o2.month_12 + o1.month_5,
      o1.month_6 = o2.month_12 + o1.month_6,
      o1.month_7 = o2.month_12 + o1.month_7,
      o1.month_8 = o2.month_12 + o1.month_8,
      o1.month_9 = o2.month_12 + o1.month_9,
      o1.month_10 = o2.month_12 + o1.month_10,
      o1.month_11 = o2.month_12 + o1.month_11,
      o1.month_12 = o2.month_12 + o1.month_12
      WHERE type = ‘Outlay $ (Reported in FACTS)’
      AND (year + year_count) <= (IF(MONTH(CURDATE()) > 9, YEAR(CURDATE()) + 2, YEAR(CURDATE()) + 1))
      AND year_count = 2

Phil 11.26.13

8:00 – 5:00 SR

  • Backups
  • Deployed new FA, RA, RQ swfs, RQ jar and some additional sql for queries and Reqonciler
  • Looks like I lost one of my access privileges. Hopefully this will be fixed before I loose access to the servers…
  • Meeting with Chris
  • PM Actuals are vanishing from the database. For John Parker, at least….
  • Needed to have the following jars to make this java->excel example run:
    • poi-3.9.jar
    • poi-ooxml-3.9.jar
    • poi-ooxml-schemas-3.9.jar
    • xbean.jar
  • Working on writing to cells next – Done. The CognosRowObject class will contain and write out values for a Cognos.xslx file.
  • Currently writing out random data. Need to get the data from the projects next.

Dong Shin 11.25.2013

  • deployed new RA
  • verified that Fiscal Year is the cause of the incorrect outlay/obligations import…..
  • fixed login id not showing in RA
  • reworked views and update obligation/outlay queries for the Fiscal Year!
  • added ReqView in QueryBuilder – double clicking shows the requisition details, removed the project view
  • removed Upload COGNOS data button – use Reqonciler!
  • modified the FA server code to keep upload history – FinancialAssistant.jar

Phil 11.25.13

8:00 – 3:00 SR

Dong Shin 11.22.2013

  • continue working on FA/RA
    • added ReqDetailsWindow – show Requisition Details and financial data
    • successfully ingested test data from Phil’s code
    • added Portfolio Admins to view data in Requisition Assistant
    • working on COGNOS ingest queries

Phil 11.22.13

8:00 – 5:00 SR

  • Backups
  • Move back into the office
  • Add date handling based on project start and whether current ObligationOutlay.value(type) is at total budget. Done.
  • Project SQL output testing – done
  • Start cognos spreadsheet outputs
  • The portfolio managers on the project information tab should see all the requisitions (in RA) that are behind that project (High Priority)
  • Need to list what users are active, and what roles they have (Can just be a query)
  • Purge users that are not assigned to a project or requisition.
  • Because of the Cognos line matching algorithm, should we be only pulling the minimum columns?
  • There can be multiple projects per sub-budget center.

Dong Shin 11.21.2013

  • new Furniture!
  • working on Reqonciler
    • trouble-shooting incorrect ingest… changed budget_center to sub_budget_center in post-processing query
    • added update obligations and outlays queries to the post processing

Phil 11.21.13

8:00 – 4:00 SR

  • One month to go until the days start getting longer
  • Backups
  • New furniture
  • Need to change column names in vis export so that there are no spaces (special characters) in the column names. Underscores should be used to match ingestor.

Dong Shin 11.20.2013

  • deployed FA – Export to Viz works!
    • fixed table name not using the textInput
  • duplicate projects listed in Project Mgmt Panel – fixed
    • caused by incorrect parent id set from the server….. 0 instead of NULL
    • must use ResultSet.wasNull() to see if the last getXXX returned is NULL
  • created test XSLX spreadsheet to duplicate incorrect Outlay data on-site….

Phil 11.20.13

8:00 – 5:00 SR

  • Backups
  • Deployed new FA
  • Verified that we could connect to Visibility, but the default table name is in there.
  • Discussed path forward with Chris and Lenny. Next discussion will be next Tuesday
  • Duplicate project listing in “Project Management” in FA
  • Fake data
    • Need to add start date
    • Need to stop PM Actuals, Outlays from being written in the future
    • Change OO from being nxn arrays to arrays of n OO classes each with 12 months?
    • Only one sub budget center per project. BC can be shared, but SBCs are not
    • Future values are null, not zero
    • Started writing out Project sql. Need to know what a few things are before finishing.