End User Access Requests to Run Reports or Perform Ad hoc Queries
There are many pre-built reports that provide access to data in the Enterprise Data
Warehouse (EDW). For a list and description of the reports available please refer
to the Decision Support Services web
Users needing to perform ad hoc queries against central data in the Enterprise Data Warehouse must be knowledgeable about the potential impact their queries may have on other users and applications that access the same data. Users doing ad hoc queries should be experienced in SQL programming and use appropriate query tools and techniques, as documented on the Query Data page of the Decision Support Services Web site. This includes querying data through the secured views provided in the EDW.
To request end user access to run these reports or query data please review the instructions below and fill out the request form.
In order to request a role that will permit you to
access the Enterprise Data Warehouse (EDW), review the Security Access and Roles Matrix to determine your appropriate role.
For any of the following roles, you can contact the ASTRA authorizer in your
department or unit to request access. If you don't know your ASTRA Authorizer, contact
the ASTRA team at firstname.lastname@example.org for assistance.
- Administrator/Manager/Fiscal Tech
- Administrative Analyst
- Payroll Coordinator
- Advisors/Academic Staff
- Faculty/Principal Investigator
For any of the following centrally authorized roles, please fill in the form provided below:
- Chancellor/Dean/Dean's Analyst
- Academic Analyst
- Institutional Analyst
- Student Aid Analyst
- Student Fiscal Analyst
- Payroll Analyst
- Academic Personnel/HR Analyst
- EDW Administrator
If you need help determining which role is appropriate for your data needs, please email email@example.com.