The Latest HUBS Hubbub

Attention HUBS Users: Just in case you haven't heard, you have something to look forward to this Fall. Project work to upgrade HUBS from Oracle Hyperion version 9.3.1 to 11.1.2 is underway. Here is the project timeline:

Many standard features in the new version will have a positive impact for both HUBS users and administrators alike. Initially, the most significant impact of the upgrade to users will be a new look and feel of HUBS -- reports, business rules, web forms, and task lists that existed before the upgrade will still exist and be used in the same manner.

After the upgrade, administrators will have access to new tools that promise to simplify business rule and webform development for future HUBS releases. For example, formulas and data validation within a webform are standard features that can easily be added to a new webform.

Other exciting features that come with the upgrade include:

• Access to task lists and right-click menus in SmartView
• Flexibility in Process Management promotion and delegation functions
• Official support of Internet Explorer 8.x and Mozilla Firefox 3.5+

Stayed tuned for upgrade news and send any questions to hubs@harvard.edu.

August 2011 CREW Financial, Sponsored, CAPS, and Student Release Items

Category	Module	Report, View or Object	Description	Release	Actual or *Target Release Date
Capital Asset Management	REPORT	CPRSPND212: CAPS Renewal Spending Report	Apply PIS root(s) to closed projects for capital renewal spending calculations and several formatting changes.	CREW RPT 7.8	*8/19/2011

If you have any questions or concerns regarding these changes, please contact the HU IT Help Desk at 496-2001 or via email.

Human Resources Reporting News

HR Analytics QlikView

An updated version of the HR Analytics QlikView application is available. This business intelligence application is designed to provide a self-service analytical tool that can be used to explore current data and historical trends for the Harvard workforce.

The eight dashboards currently available in the HR Analytics QlikView application are described below:

Demographics	The Demographics Dashboard includes information about the employees and the positions they hold.
Demographics Costing (FIN FTE)	The Demographics Costing (FIN FTE) Dashboard represents the workforce effort associated with PeopleSoft default financial costing. This dashboard presents the current data and historical trends for positions funded by restricted, unrestricted, and sponsored funds.
Historical Demographics	**NEW** The Historical Demographics Dashboard allows users to look at a wide range of data elements about Harvard University employees for the years 1994 through 2002.
Mobility	The Mobility Dashboard tracks Harvard employees who moved into a primary position in the HR Core Workforce.
Terminations	The Terminations Dashboard tracks Harvard Employees who exited the University by leaving a primary position within the HR Core Workforce.
Churn	The Churn Dashboard allows users to quickly identify areas where the University is growing or shrinking by viewing the exit rates and the hire rates.
Workforce Scorecard	The Harvard University Workforce Scorecard displays historical trends for key measures to reflect current University-wide HR goals and priorities. Users can compare their affiliation to the University as a whole.
Absence Management	The Absence Management Dashboard provides data on the paid time off program.

Training PDF: On the HR Analytics QlikView home page, there is a link to the QlikView training document "Using QlikView." Please click on the button to view the PDF training document which provides clear instructions on how to use the application, including how to use bookmarks, search boxes, and other selection techniques.

WebEx Training:A WebEx Online Tutorial that covers the HR Analytics Demographics Costing (FIN FTE) dashboard as well as four QlikView features (bookmarks, search object, drop-down select, and cycle down buttons) is available for viewing. The tutorial is 30 minutes long. It was recorded on April 26, 2011. To view the training, please click on this link.

Access: The HR Analytics QlikView application is available to those who have been granted access. An authorized user can access "HR Analytics" via the HARVie website from the drop down list.

CREW HR Report Changes

Category	Production Date	Report Name	Description
Human Resources	Rel 7.8 (8/22/11)	HRJBMUL025 Departmental - Multiple Jobs	Updated report output to include Appointment End Date. Security Roles: HDW^HRUNV^TUB^Job No Comp, HDW^PUB^TUB^Reports User

If you have any questions or concerns about Qlikview or the recent report change please contact the HU IT Helpdesk at 496-2001 and ask the attendant to log a ticket to the HHR-Reporting Team.

Sponsored System Updates

Grants Management Application Suite (GMAS)

On June 18, 2011, a new release (1_29) was installed in GMAS that included several enhancements. Highlights include:

• A new segment status of Not Funded has been introduced; this new status indicates projects that were submitted to sponsor, but not funded. Not Funded projects are those in which all requests are in a terminal status (example: Rejected by sponsor, Closed, Withdrawn, Declined per Harvard University). Projects in Not Funded status can be selected for revised submission.
• A new feature has been added to allow super users the ability to "rollback" requests in the following statuses: Submitted to sponsor, Rejected by sponsor, Closed, Withdrawn, Declined per Harvard University. Rollback will bring the request back to the previous status and can then be modified or deleted. Note: system-to-system (S2S) requests cannot be rolled back if in Submitted to sponsor status.
• A new person approval has been added to the Person module to track responsible conduct of research (RCR) training. The new screen captures the following data for online and in person RCR training:
• Granting institution
• Completion date
• Expire date
• Comments
• Course Name
• Instructor Name

In addition to the June GMAS release, there were three exception releases installed to address system-to-system (S2S) performance issues and support the year-end Letter of Credit process. Check out the full release notes here.

The next release of GMAS is scheduled for fall 2011 and will include a major upgrade of the document repository, among some other enhancements and bug fixes. More information to come.

Harvard Institutional Review Board Electronic Reporting Tool (HIRBERT)

On June 25, 2011, a new release (1.0.15) was installed in HIRBERT and included several enhancements. Check out the full release notes here.

Upcoming Releases

FINDINI Release Schedule

A software release to the Oracle Financial Applications, known as a "FINDINI release", is done every two to four months. Each upgrade introduces needed bug fixes, enhancements, and technical upgrades into Harvard's financial systems. Generally, releases are performed on weekends to assure maximum availability during the business week. Most outages occur from 6 pm Friday evening-6 am Monday morning.

The next FINDINI release, 3.2.15, is scheduled for October 2011. Details will be available in an upcoming e-News.

The Oracle Financial Applications are:

CREW FIN Releases

The Common Reporting Environment for the Warehouse (CREW) is a reporting system that draws data from a variety of sources which are updated on a nightly basis. Users can submit report requests for immediate processing or schedule reports to automatically run on a recurring basis. Types of CREW reports include financial, budget, receivables, HR management, benefits, costing, payroll, pension, security, grants management, and sponsored reports.

The next CREW FIN release, 3.2.15, is scheduled for October, 2011. Details will be available in an upcoming e-News.

HR (PeopleSoft) and CREW HR Release 30

The next PeopleSoft Release (HR 30) is tentatively scheduled for September, 2011. Details will be available in an upcoming e-News.

The CREW HR 30.0 Release is tentatively scheduled for September 2011. Details will be available in an upcoming e-News.

CREW Reports

In addition to the CREW Financial and CREW HR releases which correspond with the FINDINI and HR releases listed above, changes and enhancements to new and existing CREW reports are also released the 3rd weekend of each month.

Release Number	Dates	Notes
7.8	8/19/11
7.9	9/16/11
7.10	10/14/11
7.11	11/18/11
7.12	12/16/11

Sponsored Systems Releases

• The GMAS release (1_29) was deployed on Saturday, June 18, 2011. For more information, see article 4. As always see the Release Notes about releases to date.
• The HIRBERT release was deployed on Saturday, June 25, 2011. As usual, please see the Release Notes for details about releases to date.

HUBS Releases

The Harvard University Budgeting Sytems (HUBS) is a set of web-based Oracle Hyperion Planning applications used for budget data entry, estimates, annotations, reporting, and submission associated with the annual budget and planning cycles.

The last major HUBS release, Release 1.0.10 occurred June 14, 2011. Information on enhancements provided in this release can be found on Eureka.

About the e-News

The Center for Workplace Development publishes this electronic newsletter for users of Harvard University's financial, HR, and reporting systems, policies, and procedures. The e-News is generally published on or around the 15th of each month.

It contains:

• updates on projects underway to build or improve University administrative systems;
• information about new University policies, procedures, and forms;
• reminders about upcoming deadlines and cut-over dates;
• tips and tricks for working more easily or productively.

We welcome questions and suggestions for improvement from readers. If your questions are of general interest, we will answer them in future issues.

Please send comments, questions, or suggestions for improvement by email to us at: admin_systems_enews@harvard.edu.

For information about subscribing or unsubscribing to the eNews notifications, visit our who gets the eNews page.