DWAG Minutes August 18, 2003
Attending: Amy Bauer, Donna Duprey, Steve Ettinger, Janet Evans, Reta Gates, Steve Hinson, Barb Holub, Janice Kauvar, Mike Moran, Shawn Winkelman, and Justin Young.
Announcement of New Members
Reta Gates is the new DWAG Representative for ATD. She is also part of the Crystal Reports User Group.
Amy Bauer is attending to assist Janice with taking minutes.
The DWAG will plan to meet every six weeks.
Members are to email Janice with days they are available.
Each division will be assigned to a representative member of the DWAG.
DataWarehouse Updates Steve Hinson
Current Staff:
Joe Bitzko Currently contracting as the database administrator. He will be in this position full-time through at least the end of the fiscal year. There will be someone in this role permanently, but currently the position is pending.
Donna Duprey Full-time working on the Datawarehouse; report and project support as well as user support
Barb Holub Part-time working on the Datawarehouse; mostly in-depth report and project support
Steve Hinson General resource; can be contacted as part of his job function; to be in direct touch with users for support
If a user is working in a DataWarehouse application and needs immediate support, they are still to use the x8888 Help Desk resource which is currently manned by Todd Munson. He can assist with user account passwords, resets, etc. IT is currently working on new mechanisms to address and streamline the report requests, this can be discussed further at future DWAG meetings.
Software, hardware and licensing Updates
The upgrade to version 8.5 is stable and running. The status of upgrading to version 9.0 will be addressed at the next DWAG meeting.
The DataWarehouse server went down over the weekend, it will be repaired with hardware that is in house.
Steve will work with Contracts to see about licensing and maintenance renewals for the Crystal Reports software company-wide through IT. Donna will see who is currently covered through IT and those who are covered on their own agreements.
Outstanding Reports
A-133 A report for Finance schedule of expenses for regulatory reporting. IT is making progress, waiting for feedback from Finance.
Period of Performance Barb has sent the report to Mike for review. For use in determining costs associated with agreements with Period of Performance dates not associated with the 9/30 Year End date. Need input from DWAG as well. (i.e. What is the usefulness?)
Mike will send out requests to a subgroup of DWAG to test and provide feedback. Caron and Reta are members with these types of awards. Justin will check with Jana and Melissa.
Contracts Buyer Information and Dollar Volume Donna is working on this report. Part of the data is in Bi-Tech. Pam Ballard needs to get the modified business plan to IT. The first part of this report should be up by 10/01/03. The second part with the Threshold of Amount should be available after FY04.
Job Scheduler Donna is working with JOSS to develop a Job Scheduler function of the Datawarehouse to send out reports in Adobe or Excel via email or to an FTP server accessible via the web. Need to determine the top 8-10 reports that could be modified to pull most current data for scheduling.
Budget Variance Donna is working with Justin and Jana to lessen the workload for monthly budget variance reporting for the Presidents Council.
ABR Donna and Janet are working on the process of planning for the ABR.
Report Library Mike had asked if a list of all reports, including customized reports, could be made available to the user community. This could be very time consuming, but is being considered.
Action Items:
Janice will set up reoccurring meetings on Meeting Maker.
For review, Janice will send out list of members and what groups they represent.
Mike will put together a subgroup of the DWAG to review the POP report.
Minutes will be sent to DW user list. Future meeting agendas will also be forwarded to DW users for input on agenda items.
IT will create a webpage to maintain members list, minutes, and agenda items.
For the Next Meeting:
Steve will go over each project on the list with DWAG. He will send out the list prior to the meeting for review. Steve will give updates on Crystal 9.0 and the new hardware for the DW database.