Thursday, December 31, 2009

Finance General Ledger Mart

Finance reporting data was initially created by the CSU Chancellor Office (CO) and was a flavor of Oracle’s Enterprise Performance Management (EPM) data warehouse developed for PeopleSoft 8.4. Chico State was the pilot campus for EPM, and since implementation the CO has abandoned the product and discontinued development.

In March 2009 Chico State was scheduled to upgrade to PeopleSoft 9.0. Due to table changes and change in processes for 9.0, the data mart would have to be updated. To complicate the situation the stand-alone version of the reporting tool the Finance department used was also being discontinued.

Due to both discontinuation of support for EPM and discontinuation of our reporting tool we decided to replace our entire finance reporting system with a home grown data mart and the campus’ enterprise reporting tool.

I was appointed lead on the data mart which was successfully implemented before the deadline and has since then been adopted by 4 of the 23 California State Universities supported by the CO. The data mart mostly follows Ralph Kimball’s model with conformed dimensions that are used in multiple marts.

Tools: SSRS for Reporting
Language: PL/SQL, SQL for table development
Database: Oracle

No comments:

Post a Comment