GMAS | Sponsored Reports in CREW

CREW is the Common Reporting Environment for the Data Warehouse - a user-friendly, flexible web-based tool.

GMAS will be the second system to bring its reporting into this common interface - HR Reporting was succesfully rolled out in June 2004. Sponsored reports will not be available in HUDINI or AWS2.

CREW info in ABLE (including online CREW tutorial)
CREW Tips and Tricks

Reports being delivered in Wave 1

The most critical sponsored research reports have been identified by the user community to be rolled out with GMAS on October 13, 2004. All remaining reports have been prioritized, and will be delivered in a phased schedule.

GMAS reports (pdf)

Support

If you have questions about running a CREW report or ad hoc report, please contact the Help Desk at 496-0800. They will route your request or question to the group best able to respond.

Report Security

Each individual user is assigned a role to manage what data is accessible in GMAS and CREW reports. Security will be assigned at the Tub, Org, and Segment (Award) level. Non-GMAS users must have reporting specific roles created in GMAS to access GMAS reports in CREW.

Memo from Ann Berman (9/24/04)
Report Security Presentation

To request access to sponsored reports in CREW, please contact your school's authorized requestor.

Ad Hoc Reporting

For those individuals who will modify existing reports or create new reports to respond to their group's unique business questions, we are hoping that reports and expertise can be shared amongst the Ad Hoc community.

To participate:

How to Gain Access to the Data Warehouse through Brio

GMAS Data Warehouse Tables Structures (4mb pdf file)