[796] in I/T Delivery
Data Warehouse Status Report
daemon@ATHENA.MIT.EDU (Mary Weisse)
Mon Jun 10 13:23:29 2002
Message-Id: <4.3.2.7.2.20020610132304.01765678@hesiod>
Date: Mon, 10 Jun 2002 13:27:42 -0400
To: delivery@mit.edu
From: Mary Weisse <mca@MIT.EDU>
Mime-Version: 1.0
Content-Type: multipart/alternative;
boundary="=====================_21562925==_.ALT"
--=====================_21562925==_.ALT
Content-Type: text/plain; charset="iso-8859-1"; format=flowed
Content-Transfer-Encoding: quoted-printable
Team Name: Data Warehouse
Team Leader: Scott Thorne
Report Date: June 10, 2002
URL: http://web.mit.edu/warehouse/
This month's accomplishments (May 2002)
=B7 Creating, testing and loading HR_LOOKUP table (wh_hrp1000/wh_hrp9001) -=
=20
extracting data,
splitting HRP files and filtering out ONLY valid records for a=20
particular object type, plan version
and planning status, and loading the data
=B7 Library systems: Analyzed, designed, tested, and moved to production=20
acquisition part1
=B7 Library systems: Finished analysis, and began design of Library Order=20
arrival detail schema.
=B7 AAUDE Data Warehouse: Started working on items in Phase II of AAUDE=
Data=20
Warehouse:
=B7 AAUDE Data Warehouse: Analyzed, designed, tested, and moved to=20
production "CUPA
Administrative Salary".
=B7 AAUDE Data Warehouse: Completed analysis of "AAUDE Admin Salaries".
=B7 AAUDE Data Warehouse: Completed analysis of "Graduate Student=
Stipend=94.
=B7 AAUDE Data Warehouse: Tightened up the tables for some of the exchange=
=20
items in
Phase I, including AAUDE Faculty Salary by CIP, AAUP Faculty Salary.
=B7 AAUDE Data Warehouse: Added more information to the Data Warehouse=
metadata
web site -- tnanames.ora, sqlnet files, information about connecting=20
to the Data Warehouse
using Filemaker, BrioQuery OCE, SQL scripts of sample queries, Oracle=
=20
common errors, etc.
Fixed all the discrepancies in the star table groups on the website.
=B7 Completed programming work for unique count of students by SSM (Sloan=20
School of
Management) revenue type and revenue group for the Sloan School=20
Tuition Revenue project.
=B7 Loaded student biographic records in the MITSIS archive system to the=20
STUDENT ARCHIVE
table in Data Warehouse. Grant access to this table to Alumni.
=B7 Worked with Student Financial Services staff to generate a report for=20
"Needy undergrads
from Massachusetts public schools" with awarded MIT Grant data.
=B7 Taught second Data Warehouse/Libraries class.
=B7 Taught two additional Data Warehouse/Benefits classes.
=B7 Created a 1-day Class for novice library users.
=B7 Completed data modeling with Publications Services Bureau.
=B7 Moved sqlexport bug fix to production.
=B7 Completed training material for AAUDE at AIR Conference in Toronto June=
2-4.
=B7 Continue to work on the analysis of the SAP/HR implementation in the=20
warehouse.
=B7 Attended and presented 5 separate sessions at the AAUDE Annual=
Conference=20
in Eugene Oregon.
=B7 Continued data modeling sessions with the Consortium for Functional=20
Glycomics.
=B7 Continue working with ASST and DS to get a new Production DW machine up=
=20
and running.
=B7 Continue to train Lana Lemeshov
Next Month's Plans (June, 2002)
=B7 Attend AIR Conference in Toronto, Canada June 3 - June 5. Give a Data=
=20
Warehouse/AAUDE class.
=B7 AAUDE Data Warehouse -- continue development work on Phase II and Phase=
=20
III and
maintenance work on Phase I.
=B7 Start working with Jim Repa on Master Department Hierarchy at MIT.
=B7 Complete Federal Work Study for Student Financial Aid
=B7 Hand off facilities application to Mike Sherman (Facilities IT).
=B7 Begin hiring process (Replace Steve Turner who is transitioning out of=
DW=20
as of June 30).
=B7 Continue to work on the analysis of the SAP/HR implementation in the=20
warehouse.
=B7 Work with database group on ORCA upgrade.
=B7 Continue design and implementation of new HR Org hierarchy.
=B7 Continue researching reporting tools.
=B7 Begin to bring the "official" (new) department hierarchy into the=
warehouse.
=B7 Continue data modeling sessions with the Consortium for Functional=
Glycomics.
=B7 Prepare for Data Warehouse rollout of the SAP/HR/CYBORG MIT Telephone=20
Directory Data.
=B7 Meet with Price Waterhouse Data Warehouse audit.
=B7 Continue working with ASST and DS to get a new Production DW machine=20
(Freewilly) up and running.
=B7 Work with ASST and DS to get a new make the current Orca the new test=20
warehouse machine.
=B7 Prepare for AAUDR training here at MIT.
=B7 Prepare for AAUDE training at CalTech in August.
Next Community Milestones:
=B7 Rollout of the SAP/HR/CYBORG MIT Telephone Directory Data. July 1, 2002
=B7 Rollout of Library Acquisitions Part1 -- May 2002
=B7 Completed Sloan School Tuition Revenue project -- May 2002
--=====================_21562925==_.ALT
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<html>
<b>Team Name</b>: Data Warehouse<br>
<b>Team Leader:</b> Scott Thorne<br>
<b>Report Date:</b> June 10, 2002<br>
<b>URL:</b>
<a href=3D"http://web.mit.edu/warehouse/" eudora=3D"autourl"><font=
color=3D"#0000FF"><u>http://web.mit.edu/warehouse/</a><br>
<br>
<br>
</u></font><b>This month's accomplishments (May 2002)<br>
</b><font face=3D"Symbol">=B7 </font>Creating, testing and loading HR_LOOKUP=
table (wh_hrp1000/wh_hrp9001) - extracting data, <br>
splitting HRP files and filtering out ONLY valid records=
for a particular object type, plan version <br>
and planning status, and loading the data<br>
<font face=3D"Symbol">=B7 </font>Library systems: Analyzed, designed,=
tested, and moved to production acquisition part1 <br>
<font face=3D"Symbol">=B7 </font>Library systems: Finished analysis, and=
began design of Library Order arrival detail schema.<br>
<font face=3D"Symbol">=B7 </font>AAUDE Data Warehouse: Started working=
on items in Phase II of AAUDE Data Warehouse: <br>
<font face=3D"Symbol">=B7 </font>AAUDE Data Warehouse: Analyzed,=
designed, tested, and moved to production "CUPA <br>
Administrative Salary".<br>
<font face=3D"Symbol">=B7 </font>AAUDE Data Warehouse: Completed=
analysis of "AAUDE Admin Salaries".<br>
<font face=3D"Symbol">=B7 </font>AAUDE Data Warehouse: Completed=
analysis of "Graduate Student Stipend=94.<br>
<font face=3D"Symbol">=B7 </font>AAUDE Data Warehouse: Tightened up=
the tables for some of the exchange items in <br>
Phase I, including AAUDE Faculty Salary by CIP, AAUP=
Faculty Salary. <br>
<font face=3D"Symbol">=B7 </font>AAUDE Data Warehouse: Added more=
information to the Data Warehouse metadata <br>
web site -- tnanames.ora, sqlnet files, information about=
connecting to the Data Warehouse <br>
using Filemaker, BrioQuery OCE, SQL scripts of sample=
queries, Oracle common errors, etc. <br>
Fixed all the discrepancies in the star table groups on=
the website. <br>
<font face=3D"Symbol">=B7 </font>Completed programming work for unique count=
of students by SSM (Sloan School of <br>
Management) revenue type and revenue group for the Sloan=
School Tuition Revenue project.<br>
<font face=3D"Symbol">=B7 </font>Loaded student biographic records in the=
MITSIS archive system to the STUDENT ARCHIVE <br>
table in Data Warehouse. Grant access to this table to=
Alumni.<br>
<font face=3D"Symbol">=B7 </font>Worked with Student Financial Services=
staff to generate a report for "Needy undergrads <br>
from Massachusetts public schools" with awarded MIT=
Grant data.<br>
<font face=3D"Symbol">=B7 </font>Taught second Data Warehouse/Libraries=
class.<br>
<font face=3D"Symbol">=B7 </font>Taught two additional Data=
Warehouse/Benefits classes.<br>
<font face=3D"Symbol">=B7 </font>Created a 1-day Class for novice library=
users.<br>
<font face=3D"Symbol">=B7 </font>Completed data modeling with Publications=
Services Bureau.<br>
<font face=3D"Symbol">=B7 </font>Moved sqlexport bug fix to production.<br>
<font face=3D"Symbol">=B7 </font>Completed training material for AAUDE at=
AIR Conference in Toronto June 2-4.<br>
<font face=3D"Symbol">=B7 </font>Continue to work on the analysis of the=
SAP/HR implementation in the warehouse.<br>
<font face=3D"Symbol">=B7 </font>Attended and presented 5 separate sessions=
at the AAUDE Annual Conference in Eugene Oregon.<br>
<font face=3D"Symbol">=B7 </font>Continued data modeling sessions with the=
Consortium for Functional Glycomics.<br>
<font face=3D"Symbol">=B7 </font>Continue working with ASST and DS to get a=
new Production DW machine up and running.<br>
<font face=3D"Symbol">=B7 </font>Continue to train Lana Lemeshov<br>
<br>
<br>
<b>Next Month's Plans (June, 2002)<br>
</b><font face=3D"Symbol">=B7 </font>Attend AIR Conference in Toronto,=
Canada June 3 - June 5. Give a Data Warehouse/AAUDE class.<br>
<font face=3D"Symbol">=B7 </font>AAUDE Data Warehouse -- continue=
development work on Phase II and Phase III and <br>
maintenance work on Phase I.<br>
<font face=3D"Symbol">=B7 </font>Start working with Jim Repa on Master=
Department Hierarchy at MIT.<br>
<font face=3D"Symbol">=B7 </font>Complete Federal Work Study for Student=
Financial Aid<br>
<font face=3D"Symbol">=B7 </font>Hand off facilities application to Mike=
Sherman (Facilities IT).<br>
<font face=3D"Symbol">=B7 </font>Begin hiring process (Replace Steve Turner=
who is transitioning out of DW as of June 30).<br>
<font face=3D"Symbol">=B7 </font>Continue to work on the analysis of the=
SAP/HR implementation in the warehouse.<br>
<font face=3D"Symbol">=B7 </font>Work with database group on ORCA=
upgrade.<br>
<font face=3D"Symbol">=B7 </font>Continue design and implementation of new=
HR Org hierarchy.<br>
<font face=3D"Symbol">=B7 </font>Continue researching reporting tools.<br>
<font face=3D"Symbol">=B7 </font>Begin to bring the "official"=
(new) department hierarchy into the warehouse.<br>
<font face=3D"Symbol">=B7 </font>Continue data modeling sessions with the=
Consortium for Functional Glycomics.<br>
<font face=3D"Symbol">=B7 </font>Prepare for Data Warehouse rollout of the=
SAP/HR/CYBORG MIT Telephone Directory Data.<br>
<font face=3D"Symbol">=B7 </font>Meet with Price Waterhouse Data=
Warehouse audit.<br>
<font face=3D"Symbol">=B7 </font>Continue working with ASST and DS to get a=
new Production DW machine (Freewilly) up and running.<br>
<font face=3D"Symbol">=B7 </font>Work with ASST and DS to get a new make the=
current Orca the new test warehouse machine.<br>
<font face=3D"Symbol">=B7 </font>Prepare for AAUDR training here at MIT.<br>
<font face=3D"Symbol">=B7 </font>Prepare for AAUDE training at CalTech in=
August.<br>
<br>
<br>
<b>Next Community Milestones:<br>
</b><font face=3D"Symbol">=B7 </font>Rollout of the SAP/HR/CYBORG MIT=
Telephone Directory Data. July 1, 2002<br>
<font face=3D"Symbol">=B7 </font>Rollout of Library Acquisitions Part1 --=
May 2002<br>
<font face=3D"Symbol">=B7 </font>Completed Sloan School Tuition Revenue=
project -- May 2002<br>
<br>
</html>
--=====================_21562925==_.ALT--
