[1201] in I/T Delivery
Data Warehouse Status Report - May 2003
daemon@ATHENA.MIT.EDU (Mary Weisse)
Thu Jun 5 17:05:08 2003
Message-Id: <4.3.2.7.2.20030605165414.00a849e0@hesiod>
Date: Thu, 05 Jun 2003 17:03:09 -0400
To: delivery@mit.edu
From: Mary Weisse <mca@MIT.EDU>
Mime-Version: 1.0
Content-Type: multipart/alternative;
boundary="=====================_173220728==_.ALT"
--=====================_173220728==_.ALT
Content-Type: text/plain; charset="iso-8859-1"; format=flowed
Content-Transfer-Encoding: quoted-printable
Team Name: Data Warehouse
Team Leader: Mary Weisse
Report Date: June 5, 2003
URL: http://web.mit.edu/warehouse/
This month's accomplishments (May, 2003)
=B7 EHS
o Entered training metadata.
o Completed prototype of EHS training data.
o Rolled out training prototype for end user testing.
o Created problem_checking mechanism to detect and report all=20
people with 999999 MitId ,
that are blocked from the EHS training views and need to=20
be cleaned
=B7 Continue work on SAP/HR.
o Completed first draft of the DW HR reporting model(s)/data stars.
o Analyze, extract, and load HR lookup data from SAP to Warehouse.
o Continued working on HR reporting authorizations.
=B7 Analyzed, designed, and loaded Graduate Admissions Survey data.
=B7 Analyzed, designed, and made appropriate modifications to Sloan School=
of=20
Management Tuition Sharing project.
=B7 Added new iPass feed to the Telephone data.
=B7 Began to analyze work to be done for fiscal year close.
=B7 Test parallel degree processing to improve data load processing time.
=B7 Begin work to automate DW user creation, granting roles, and sending=20
notification.
=B7 Continue working with TLO and FSS on loading and testing TLO Financial=
data.
=B7 Added new data items to the whosp_award table for OSP.
=B7 Met with athletics to discuss data needs.
=B7 Met with Price Waterhouse for yearly DW audit.
=B7 Student Activities web reporting application:
o Analyzed SAO reports created by FSS.
o Wrote SQL scripts to set up the various SAO reports.
o Set up special web views on some fact tables for WWWUSER on the=
=20
web.
o Created/updated stored procedure as needed.
o Set up authorizations in Access Control table.
=B7 AAUDE
o Completed analysis work on IPEDS Institution Characteristics.
o Loaded current year data for: IPEDS Fall Enrollment, CUPA=20
Administrative
Salary, AAUDE Faculty Salary.
=B7 Tested second Warehouse Web Server.
=B7 Continue testing of the brio 6 pc installer.
=B7 Reporting
o Worked with the Provosts Office to create statistical.
o Continued work on Cost Sharing Reports.
o Drafted EHS production reports
=B7 Training
o Delivered three Brio 6 classes for CAO.
o Delivered two Brio 6.6 intermediate classes to CAO/Facilities on=
=20
how to convert
5.5 queries to 6, make modifications to queries, and build=
=20
a simple query in 6.6.
o Continue working with training & Pubs to identify and create new=
=20
Brio 6 Classes.
o Prepared and gave a presentation at the IS forum.
Next Month's Plans (June, 2003)
=B7 Training
o Prepare and deliver a customized class for the Lincoln Labs=20
Benefits people on how
to use Brio 6.6 for Benefits reporting.
o Work one on one with EHS people to be sure they can create=20
appropriate reports.
=B7 Reporting:
o Work one on one with EHS people to be sure they can create=20
appropriate reports.
=B7 Continue meeting with Medical Dept and CAO to discuss the analysis and=
=20
design of
Medical Line of Business reporting out of the warehouse.
=B7 Demos:
o Prepare and Deliver Data Warehouse demo for Publishing Services=
=20
Bureau.
o Prepare and Deliver AAUDE Data Warehouse demo for COFHE.
o Prepare and speak at AIM and ACTII meetings. What the community=
=20
can
expect to see in the DW when SAP/HR rolls out in September.
=B7 AAUDE:
o Implement and load "Tuition and Required Fees" data
o Compile new/updated documentations for the "AAUDE Data Caretaker=
=20
Manual".
o Analyze IPEDS Institution Characteristics
o Load current year data for Graduation & Retention
=B7 Implement access control (using Roles Database) on Graduate Admissions=
data.
=B7 Continue to set up/configure the Taj warehouse web server. Start=20
migrating programs
from blue-goose to taj to run in production.
=B7 Continue with Web Hits change processing procedures to include a new web=
=20
browser
(Mozilla) and a couple of new browser versions for Netscape in Web=
=20
Hits reporting.
Create 3 dimension tables for the Web Hits Star/Data Model.
=B7 Continue work to automate DW user creation, granting roles, and sending=
=20
notification.
=B7 Continued analysis of work to be done for fiscal year close.
o Make appropriate database configuration changes for fiscal year=
=20
close.
o Modify the whbalances and whsummary_statement detail index=20
creation scripts to use parallel degree.
o Create a temporary tablespace for wareuser in ORCA.
=B7 Continue work on Student Activities web reporting application.
=B7 Make appropriate changes to HR data from Cyborg to help facilitate the=
=20
DLC data cleanup.
=B7 Continue working with TLO and FSS on loading and testing TLO Financial=
data.
=B7 Present work on Project Intersections Team to ASPCC.
=B7 Lana will attend taking Oracle DBA 'Backup and Recovery' class.
=B7 Continue work on SAP/HR.
=B7 Continue with Brio 6 rollout.
Next Community Milestones:
=B7 Rollout of Student Activities Web Reporting Application - July 2003.
=B7 Rollout of the SAP/HR/CYBORG - September 2003.
=B7 Rollout EHS Training Reporting June 2003.
=B7 Load summary (by service) MIT Medical data into the DW. On Hold.
=B7 Load TLO case data into the DW On Hold.
=B7 Load MIT Card Office data (including pictures) into the DW.
--=====================_173220728==_.ALT
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<html>
<font size=3D4><b>Team Name</b>: Data Warehouse<br>
<b>Team Leader:</b> Mary Weisse<br>
<b>Report Date:</b> June 5, 2003<br>
<b>URL:</b>
</font><a href=3D"http://web.mit.edu/warehouse/" eudora=3D"autourl"><font=
size=3D4 color=3D"#0000FF"><u>http://web.mit.edu/warehouse/</a><br>
<br>
</u></font><font size=3D4><b>This month's accomplishments (May, 2003)<br>
</b></font><font face=3D"Symbol" size=3D4>=B7 </font>EHS<br>
<font face=3D"Courier New, Courier"=
size=3D4><x-tab> </x-tab>o=
</font>Entered training metadata.<br>
<font face=3D"Courier New, Courier"=
size=3D4><x-tab> </x-tab>o=
</font>Completed prototype of EHS training data. <br>
<font face=3D"Courier New, Courier"=
size=3D4><x-tab> </x-tab>o=
</font>Rolled out training prototype for end user testing.<br>
<font face=3D"Courier New, Courier"=
size=3D4><x-tab> </x-tab>o=
</font>Created problem_checking mechanism to detect and report all people=
with 999999 MitId , <br>
<x-tab> </x-tab><x-tab> =
</x-tab>that are blocked from the=
EHS training views and need to be cleaned<br>
<font face=3D"Symbol" size=3D4>=B7 </font>Continue work on=
SAP/HR.<x-tab> </x-tab><br>
<font face=3D"Courier New, Courier"=
size=3D4><x-tab> </x-tab>o=
</font>Completed first draft of the DW HR reporting model(s)/data stars.=
<br>
<font face=3D"Courier New, Courier"=
size=3D4><x-tab> </x-tab>o=
</font>Analyze, extract, and load HR lookup data from SAP to Warehouse.<br>
<font face=3D"Courier New, Courier"=
size=3D4><x-tab> </x-tab>o=
</font>Continued working on HR reporting authorizations.<br>
<font face=3D"Symbol" size=3D4>=B7 </font>Analyzed, designed, and loaded=
Graduate Admissions Survey data. <br>
<font face=3D"Symbol" size=3D4>=B7 </font>Analyzed, designed, and made=
appropriate modifications to Sloan School of Management Tuition Sharing=
project.<br>
<font face=3D"Symbol" size=3D4>=B7 </font>Added new iPass feed to the=
Telephone data.<br>
<font face=3D"Symbol" size=3D4>=B7 </font>Began to analyze work to be done=
for fiscal year close.<br>
<font face=3D"Symbol" size=3D4>=B7 </font>Test parallel degree processing to=
improve data load processing time.<br>
<font face=3D"Symbol" size=3D4>=B7 </font>Begin work to automate DW user=
creation, granting roles, and sending notification.<br>
<font face=3D"Symbol" size=3D4>=B7 </font>Continue working with TLO and FSS=
on loading and testing TLO Financial data.<br>
<font face=3D"Symbol" size=3D4>=B7 </font>Added new data items to the=
whosp_award table for OSP.<br>
<font face=3D"Symbol" size=3D4>=B7 </font>Met with athletics to discuss data=
needs.<br>
<font face=3D"Symbol" size=3D4>=B7 </font>Met with Price Waterhouse for=
yearly DW audit.<br>
<font face=3D"Symbol" size=3D4>=B7 </font>Student Activities web reporting=
application:<br>
<font face=3D"Courier New, Courier"=
size=3D4><x-tab> </x-tab>o=
</font>Analyzed SAO reports created by FSS.<br>
<font face=3D"Courier New, Courier"=
size=3D4><x-tab> </x-tab>o=
</font>Wrote SQL scripts to set up the various SAO reports. <br>
<font face=3D"Courier New, Courier"=
size=3D4><x-tab> </x-tab>o=
</font>Set up special web views on some fact tables for WWWUSER on the web.=
<br>
<font face=3D"Courier New, Courier"=
size=3D4><x-tab> </x-tab>o=
</font>Created/updated stored procedure as needed. <br>
<font face=3D"Courier New, Courier"=
size=3D4><x-tab> </x-tab>o=
</font>Set up authorizations in Access Control table.<br>
<font face=3D"Symbol" size=3D4>=B7 </font>AAUDE<br>
<font face=3D"Courier New, Courier"=
size=3D4><x-tab> </x-tab>o=
</font>Completed<b> </b>analysis work on IPEDS Institution=
Characteristics.<br>
<font face=3D"Courier New, Courier"=
size=3D4><x-tab> </x-tab>o=
</font>Loaded current year data for: IPEDS Fall Enrollment, CUPA=
Administrative <br>
<x-tab> </x-tab><x-tab> =
</x-tab>Salary, AAUDE Faculty=
Salary.<br>
<font face=3D"Symbol" size=3D4>=B7 </font>Tested second Warehouse Web=
Server. <br>
<font face=3D"Symbol" size=3D4>=B7 </font>Continue testing of the brio 6 pc=
installer.<br>
<font face=3D"Symbol" size=3D4>=B7 </font>Reporting<br>
<font face=3D"Courier New, Courier"=
size=3D4><x-tab> </x-tab>o=
</font>Worked with the Provosts Office to create statistical.<br>
<font face=3D"Courier New, Courier"=
size=3D4><x-tab> </x-tab>o=
</font>Continued work on Cost Sharing Reports.<br>
<font face=3D"Courier New, Courier"=
size=3D4><x-tab> </x-tab>o=
</font>Drafted EHS production reports<br>
<font face=3D"Symbol" size=3D4>=B7 </font>Training<br>
<font face=3D"Courier New, Courier"=
size=3D4><x-tab> </x-tab>o=
</font>Delivered three Brio 6 classes for CAO. <br>
<font face=3D"Courier New, Courier"=
size=3D4><x-tab> </x-tab>o=
</font>Delivered two Brio 6.6 intermediate classes to CAO/Facilities on how=
to convert <br>
<x-tab> </x-tab><x-tab> =
</x-tab>5.5 queries to 6, make=
modifications to queries, and build a simple query in 6.6.<br>
<font face=3D"Courier New, Courier"=
size=3D4><x-tab> </x-tab>o=
</font>Continue working with training & Pubs to identify and create new=
Brio 6 Classes. <br>
<font face=3D"Courier New, Courier"=
size=3D4><x-tab> </x-tab>o=
</font>Prepared and gave a presentation at the IS forum.<br>
<br>
<br>
<b>Next Month's Plans (June, 2003)<br>
</b><font face=3D"Symbol"=
size=3D4>=B7<x-tab> </x-tab></font=
>Training<br>
<font face=3D"Courier New, Courier"=
size=3D4><x-tab> </x-tab>&nb=
sp; o </font>Prepare and deliver a customized class for the Lincoln Labs=
Benefits people on how <br>
<x-tab> </x-tab><x-tab> =
</x-tab>to use Brio 6.6 for=
Benefits reporting.<br>
<font face=3D"Courier New, Courier"=
size=3D4><x-tab> </x-tab>o=
</font>Work one on one with EHS people to be sure they can create=
appropriate reports.<br>
<font face=3D"Symbol" size=3D4>=B7 </font>Reporting:<br>
<font face=3D"Courier New, Courier"=
size=3D4><x-tab> </x-tab>o=
</font>Work one on one with EHS people to be sure they can create=
appropriate reports.<br>
<font face=3D"Symbol" size=3D4>=B7 </font>Continue meeting with Medical Dept=
and CAO to discuss the analysis and design of <br>
<x-tab> </x-tab>Medical Line=
of Business reporting out of the warehouse.<br>
<font face=3D"Symbol" size=3D4>=B7 </font>Demos:<br>
<font face=3D"Courier New, Courier"=
size=3D4><x-tab> </x-tab>o=
</font>Prepare and Deliver Data Warehouse demo for Publishing Services=
Bureau. <br>
<font face=3D"Courier New, Courier"=
size=3D4><x-tab> </x-tab>o=
</font>Prepare and Deliver AAUDE Data Warehouse demo for COFHE. <br>
<font face=3D"Courier New, Courier"=
size=3D4><x-tab> </x-tab>o=
</font>Prepare and speak at AIM and ACTII meetings. What the=
community can <br>
<x-tab> </x-tab><x-tab> =
</x-tab>expect to see in the DW=
when SAP/HR rolls out in September. <br>
<font face=3D"Symbol" size=3D4>=B7 </font>AAUDE:<br>
<font face=3D"Courier New, Courier"=
size=3D4><x-tab> </x-tab>o=
</font>Implement and load "Tuition and Required Fees" data<br>
<font face=3D"Courier New, Courier"=
size=3D4><x-tab> </x-tab>o=
</font>Compile new/updated documentations for the "AAUDE Data=
Caretaker Manual". <br>
<font face=3D"Courier New, Courier"=
size=3D4><x-tab> </x-tab>o=
</font>Analyze IPEDS Institution Characteristics <br>
<font face=3D"Courier New, Courier"=
size=3D4><x-tab> </x-tab>o=
</font>Load current year data for Graduation & Retention<br>
<font face=3D"Symbol" size=3D4>=B7 </font>Implement access control (using=
Roles Database) on Graduate Admissions data.<br>
<font face=3D"Symbol" size=3D4>=B7 </font>Continue to set up/configure the=
Taj warehouse web server. Start migrating programs <br>
<x-tab> </x-tab>from=
blue-goose to taj to run in production.<br>
<font face=3D"Symbol" size=3D4>=B7 </font>Continue with Web Hits change=
processing procedures to include a new web browser <br>
<x-tab> </x-tab>(Mozilla) and=
a couple of new browser versions for Netscape in Web Hits reporting. <br>
<x-tab> </x-tab>Create 3=
dimension tables for the Web Hits Star/Data Model.<br>
<font face=3D"Symbol" size=3D4>=B7 </font>Continue work to automate DW user=
creation, granting roles, and sending notification.<br>
<font face=3D"Symbol" size=3D4>=B7 </font>Continued analysis of work to be=
done for fiscal year close.<br>
<font face=3D"Courier New, Courier"=
size=3D4><x-tab> </x-tab>o=
</font>Make appropriate database configuration changes for fiscal year=
close. <br>
<font face=3D"Courier New, Courier"=
size=3D4><x-tab> </x-tab>o=
</font>Modify the whbalances and whsummary_statement detail index creation=
scripts to use parallel degree.<br>
<font face=3D"Courier New, Courier"=
size=3D4><x-tab> </x-tab>o=
</font>Create a temporary tablespace for wareuser in ORCA.<br>
<font face=3D"Symbol" size=3D4>=B7 </font>Continue work on Student=
Activities web reporting application. <br>
<font face=3D"Symbol" size=3D4>=B7 </font>Make appropriate changes to HR=
data from Cyborg to help facilitate the DLC data cleanup.<br>
<font face=3D"Symbol" size=3D4>=B7 </font>Continue working with TLO and FSS=
on loading and testing TLO Financial data.<br>
<font face=3D"Symbol" size=3D4>=B7 </font>Present work on Project=
Intersections Team to ASPCC.<br>
<font face=3D"Symbol" size=3D4>=B7 </font>Lana will attend taking Oracle DBA=
'Backup and Recovery' class.<br>
<font face=3D"Symbol" size=3D4>=B7 </font>Continue work on SAP/HR.<br>
<font face=3D"Symbol" size=3D4>=B7 </font>Continue with Brio 6 rollout.<br>
<br>
<br>
<br>
<b>Next Community Milestones:<br>
</b><font face=3D"Symbol" size=3D4>=B7 </font>Rollout of Student Activities=
Web Reporting Application - July 2003.<br>
<font face=3D"Symbol" size=3D4>=B7 </font>Rollout of the SAP/HR/CYBORG -=
September 2003.<br>
<font face=3D"Symbol" size=3D4>=B7 </font>Rollout EHS Training Reporting=
June 2003.<br>
<font face=3D"Symbol" size=3D4>=B7 </font>Load summary (by service) MIT=
Medical data into the DW. On Hold.<br>
<font face=3D"Symbol" size=3D4>=B7 </font>Load TLO case data into the=
DW On Hold.<br>
<font face=3D"Symbol" size=3D4>=B7 </font>Load MIT Card Office data=
(including pictures) into the DW.<br>
<br>
</html>
--=====================_173220728==_.ALT--
