Finance Data Warehouse Phase II

The original CFS Data Warehouse 11G will be retired on December 31, 2015 and replaced with a newly redesigned data warehouse known as Finance Data Warehouse Phase II.  The two data warehouse versions are currently available and users already have access to both.   All links to the original data warehouse will be removed from CSYou on January 4, 2016.

We encourage current users to prepare themselves to switch over completely to FDW-P2 by enrolling in the Overview of Finance Data Warehouse (Course No.: FIN013), or obtaining assistance during a Finance Open Lab.  These sessions will provide you the perfect time to recreate your DW-11G saved reports in the new environment.

Finance Data Warehouse Phase II is very different from the current version. The dashboard content has been consolidated and reorganized, and the layout has been rearranged.  A wider range of filters and new formatting options are available to provide increased flexibility in creating reports which could be more meaningful for you and your departments.  Some of the enhancements include:

  • Manage My Budget, Operations, and Management Reporting dashboards have been consolidated into two dashboards: Financial Reporting and Transaction Inquiry.
  • Removal of 220 reports and a streamlined report structure.
  • More report filter options available such as the Not fields (Not Fund, Not DeptID, Not Account…)
  • Reports in the Financial Reporting dashboard now come in a standard six column format. A new feature has been added to allow users to hide or unhide columns as needed for reporting requirements. This eliminates the need to create reports with different column versions (2, 3, 4, and 5 columns).

Current DW users will have access to FDW-P2 so there is no need to submit a System Access Request form; however, due to the consolidation and reorganization of the dashboards, users will have to recreate any DW-11G saved reports in the new environment.

Finance Open Lab Schedule for January to June 2016

Finance Open Labs have been scheduled for January to June 2016.

Open labs are informal sessions where qualified personnel are available to assist department users who have access to the finance applications: CFS, FTS, Finance Data Warehouse, and Campus Marketplace. Come to an open lab for help on a number of topics:

  • Understanding procurement and finance policies and guidelines
  • Entering Requisitions or Travel Authorizations/Reimbursements in FTS
  • Ordering from Campus Marketplace and Staples Advantage
  • Running or reviewing Finance Data Warehouse reports
  • Managing PO encumbrances
  • Recording receipts and inspections
  • Reviewing PO/requisition information in CFS
  • Locating payment status of a Direct Payment or Reimbursement

Unless noted, majority of the labs run on Fridays from 9:00 a.m. to 11:00 a.m. in Clark Hall 505 on each of the days listed below. Be sure to bring your login information with you. Please refer back to this announcement for schedule changes.

  • January 15
  • January 29
  • February 5
  • February 19
  • March 4
  • March 18
  • April 1
  • April 22 ** Cancelled.
  • May 6
  • May 20
  • June 10
  • June 17
  • June 24 ** Cancelled.