Monthly Archives: November 2012

Phil 11.29.12

8:00 – 4:00 ESSO

Advertisements

Dong Shin 11.29.2012

  • weekly cum bi-weekly status meeting is now weekly again.
  • added scroll bars to PA
  • created visibility_scripting.stored_procedures.sql – missing from today’s deployment
  • burned a cd for tomorrow

Phil 11.28.12

8:00 – 4:00 ESSO

  • Backups
  • Many meetings, plus setup for tomorrows bi weekley
  • More JDeveloper tutorials
  • The server seems to get completely messed up when my box sleeps (is left alone?)
  • Binding a JSF Page to a Managed Bean – Done. Very cool IDE.

Dong Shin 11.28.2012

  • continue working on update FACTS Outlays script
    • adding getColumn method to ScriptFacades – done
  • burned VisibilityScripting on a CD for deployment tomorrow

Dong Shin 11.27.2012

  • COGNOS Data to update PPM data
    1. Match COGNOS Requisition ID to MIPR (Funding Transaction Number)
    2. COGNOS Expensed Amount summed by month
    3. Overwrite existing PPM data
    4. Update continuously (daily?)
    5. If there is no value for Expensed Amount COGNOS column, then skip
    6. If there is a negative amount – i.e. ($10,123), subtract in the sum
    7. Ingest as “FACTS_Outlay_update”
  • created dummy FACTS_Outlay_update spreadsheet and ingested it – FACTS_Outlay_update.xls
  • working on queries to update PPM data – update query can be constructed in python script using the query below
    • SELECT requisition_id,
      appropriation_year,
      SUBSTR(expensed_date, 1, LOCATE(‘/’, expensed_date)-1) as month,
      expensed_date,
      SUM(expensed_amount),
      CONCAT(‘UPDATE project_portfolio.obligations_outlays o SET ‘,
      IF (SUBSTR(expensed_date, 1, LOCATE(‘/’, expensed_date)-1) = 1, ‘month_4’,
      IF (SUBSTR(expensed_date, 1, LOCATE(‘/’, expensed_date)-1) = 2, ‘month_5’,
      IF (SUBSTR(expensed_date, 1, LOCATE(‘/’, expensed_date)-1) = 3, ‘month_6’,
      IF (SUBSTR(expensed_date, 1, LOCATE(‘/’, expensed_date)-1) = 4, ‘month_7’,
      IF (SUBSTR(expensed_date, 1, LOCATE(‘/’, expensed_date)-1) = 5, ‘month_8’,
      IF (SUBSTR(expensed_date, 1, LOCATE(‘/’, expensed_date)-1) = 6, ‘month_9’,
      IF (SUBSTR(expensed_date, 1, LOCATE(‘/’, expensed_date)-1) = 7, ‘month_1-‘,
      IF (SUBSTR(expensed_date, 1, LOCATE(‘/’, expensed_date)-1) = 8, ‘month_11’,
      IF (SUBSTR(expensed_date, 1, LOCATE(‘/’, expensed_date)-1) = 9, ‘month_12’,
      IF (SUBSTR(expensed_date, 1, LOCATE(‘/’, expensed_date)-1) = 10, ‘month_1’,
      IF (SUBSTR(expensed_date, 1, LOCATE(‘/’, expensed_date)-1) = 11, ‘month_2’,
      IF (SUBSTR(expensed_date, 1, LOCATE(‘/’, expensed_date)-1) = 12, ‘month_3’, ‘unknown’))))))))))))
      , “=”, SUM(expensed_amount), ” WHERE o.year + o.year_count = ” + appropriation_year + ” AND o.year_count = 1 AND o.type = ‘Outlay $ (Reported in FACTS'” ) as sqlstring
      FROM `facts_outlay_update`
      WHERE LENGTH(requisition_id) > 6 AND
      (SUBSTR(expensed_date, 1, LOCATE(‘/’, expensed_date)-1)  > 0 AND SUBSTR(expensed_date, 1, LOCATE(‘/’, expensed_date)-1)  < 13)
      GROUP BY month, requisition_id
  • When adding Budget Center to a Project, Budget Center columns selection should default to previous entry except for
    • Funding Transaction Name
    • Funding Transaction Number
    • Funding Transaction Type
    • Org
    • Location

Phil 11.27.12

8:00 – 2:00 ESSO

  • Discussion with Lenny and Dong about how to read in cognos data and use it to populate the FACTS fields in PPM and PA.
  • Backups
  • Working on the JDeveloper JSF tutorials – managed to crash JDeveloper.
  • Talked to Dong about next dev environments. We discussed Adobe and Netbeans in addition to what we’re using now. My thought is that if we can make a table and chart that allow us to visualize data sitting in a DB here and on site, we have a viable option. If it’s open source and supported by a player unlikely to go out of business any time soon, then so much the better.

2:00 – 4:00 FP

  • Qualitative Methods.

Phil 11.26.12

8:30 – 4:30 ESSO

  • Backups
  • More interaction with Don abo0ut what kind of visualizations he wants. Printed out a description of the putative table that we need to produce. Dong and I will try to code it tomorrow in site.
  • Put together FlexiCharts of ACC, since that appears to have vanished.
  • Got started back on JDeveloper and ADF.

Dong Shin 11.26.2012

  • got Visibility Login working using Oracle ADF!

Phil 11.21.12

8:00 – 4:00 ESSO

  • Meetings with everyone, Dan, Lenny, Chris.
  • Backups
  • 2:00pm meeting with Kristen
    • Meeting went well. I basically walked through how to use the Data Visualization and how PPM and PA generated data and where it was stored. We then talked about generating more graphics for her and how scripting could produce the tables she (implicitly) needs for the charts she wants.

Dong Shin 11.21.2012