CPM Work In Progress

Below is a list of high-level features that have been prioritized:

PriorityNameUser StoryStatus
Current Owner
Blocker
1Upgrade TM1 (to 10.0) and BI (to 10.2)Needed to prevent run-away processes from BI reports from locking up TM1 server InvestigationBarb Schnell 
1
Migrate existing BI reports to new IR framework to support the IRMC

The following reports have been identified as needed IR versions. Link to requirements:

  •  Expense Class by Account
  • Contract Status by Expense Class
  • Contract Status by Expense Class V2
  • Account Status with Expanded Budget and Division Summary
  • Account Status with Expanded budget and Division Summary and expense class

In development
Barb Schnell (Janaki and Cindy)Technical resource - performance tuning
1
Web Service to pull CPM actuals to COMET EVMS tool

COMET would like to automate the populate of their tool with actual loaded salary costs for COMET accounts by pay period. Link to requirements
Deployed 2/27/14 - a 2nd web service is required for Award pay and salary transfers
Barb Schnell, Karl Werner 
1Various changes to copy processes
Update N2 to include fund source, copy to expense class code; N3 process copy non salary Actuals to WP, N4, copy Non salary IFAS Budget vs Actual amount to remaining months in the year from WP.
In test, development

N2, N3 - Reta

N4 - Karl

 
1.1Server Optimization- move snapshot cubes to another server to reduce memory consumption on fatahoe and improve response time/performancePlanning
Barb Schnell, Karl Werner 
1.2Report Distribution Automation - release 2
 Add functionality and refine features for roll-out to other labs/programs. Link to requirements.In development - Target date pushed from Feb month-end to March Month-end (early April).  This roll-out to new divisions/programs will slow down substantially due to expectations of IT groups and lack of sys admin resource in FandA IT.
Barb Schnell 
1.3
FinOrg restructure

Some groups want to refine their FinOrg.  Need to do outreach to identify who and provide upload format for making their changes.  Explore use of subfacility for NCAR and UCP to identify what FinOrg parent the key should go to.
RequirementsReta KublerOut reach needed to collect changes
1.4
Training / out-reach

  • Schedule some focused trainins sessions ontips and tricks in FAB
  • other TBD
RequirementsReta Kubler 
 1.5
Allocation Mapping

Administrators need to be able to map salary (by employee) and non salary expenses to Projects / Activities at the lab level and Strategic Plan items at the Entity Level.  They also need the ability to assign Priority and Ranking to lab Projects and Activities and to add new Projects/Activities, Priosirites, and Strategic Plan items for mapping as needed. Placed On Hold 11/7/13.  Requirements review and/or Testing resource needed.
Deployed, not in use Barb Schnell, Geoff CheesemanTesting and acceptance/validation
1.6Sunset DW, Migrate existing datawarehouse reports to BINeed to move old data warehouse reports to BI so we do not have to support 2 data warehouses.  Gap Analysis startedBarb Schnell 
1.7Snapshot - purge/save-offThe snapshot cubes are growing really fast because we are snapshotting off all FY's every month.  Need to explore ways to control this by rolling them off and/or purging every 24 months.Need direction/requirements input?? 

1.9
Time card integration enhancements
Update time cards with new account keys added to profiles in CPM nightly to reduce thenumber of mistakes made by employees in coding time to the correct account keys.
 Not startedBarb Schnell 
2.0PoP-based reportsThere is a request to have reports that are PoP Based.  IT needs to doa proof of concept for monthly cumulative and contratc-year-based summariesNot startedBarb Schnell, Cindy Zhang 
3.0New IR reportsThere is a request to add Division, Lab, Subfacility, Facility to some of the IR reports.  As well to add Contract State (e.g. WRAP) to the reports. - can be pulled out of grid in the UI.Not started  

 

new N4 process to copy IFAS Budget vs Actual Variance into the remaining months of the Working Plan.