If your computer has been recently upgraded to Internet Explorer (IE) 11 and already have the Hyperion plugin installed, you will need to reapply your IE settings with the instructions found at
Thursday, April 3, 2014
In support of the new Click research administration software being implemented by OKED, we’ll be making column length changes to some tables in the SPONSORED database in E1 to integrate the new Click data. The changes will be in production within a couple of weeks, and the tables affected and their changes are listed below. We don’t expect any issues with reports within My Reports, but if you have customized applications or other direct access to these database tables, those applications might be affected.
Thursday, March 20, 2014
More information about the new Admissions Fact Tables (ASU_ADM_APPLICATION, ASU_ADM_APPLICANT, ASU_ADM_INTL_STUDENT and ASU_ADM_APP_FIRST_AD_SNP) can be found here.
The new Admissions dashboards provide combined and customized views of undergraduate, graduate and online admissions data. Access to these pages is through the "Admissions Services" link on the main dashboard page (http://www.asu.edu/dashboard/).
The access to the PROPOSAL_ANNUALIZED_RECOGNITN table in the legacy data warehouse (enterprise1.asu.edu) within the SPONSORED database has been removed. There is a concern that the data in the table can be misinterpreted, and its use is not supported by OKED.
Wednesday, February 26, 2014
On March 4, 2014, ASU_A_ADM (also known as PS_ASU_A_ADM) will be renamed to ASU_A_ADM_ARCH to help ensure that users of this data understand its archived state. Queries that require the frozen data in ASU_A_ADM / PS_ASU_A_ADM must be updated to reference the archive table instead. No column names will be changed.
If you want to continue to use these inactive tables, here is what you need to do to modify your query:
• for queries using ASU_A_ADM, please change the table’s Physical name from ASUDW.ASU_A_ADM to ASUDW.ASU_A_ADM_ARCH
• for queries using PS_ASU_A_ADM, please change the table’s Physical name from SYSADM.PS_ASU_A_ADM to ASUDW.ASU_A_ADM_ARCH
To see a specific list of reports using either table, please click https://docs.google.com/a/asu.edu/spreadsheet/ccc?key=0AhOZY7Jpd1s1dEtfc2R2QmRwb2YwZlc2TUc3VGpXRHc. This list contains the suggested contact(s), location and name of report. We have created a help article (http://help.asu.edu/sims/selfhelp/SelfhelpKbView.seam?parature_id=8373-8193-7884) for instructions on how to change a table name.
Queries that need current/up-to-date admissions information should be adjusted to use the new Admissions Fact tables (ASU_ADM_APPLICATION, ASU_ADM_APPLICANT, ASU_ADM_INTL_STUDENT and ASU_ADM_APP_FIRST_AD_SNP) or other tables/views as needed.
If you need assistance in modifying your existing query, please contact the BI Reporting team at email@example.com.
Tuesday, January 28, 2014
Enterprise Data Warehouse (PMPRD)
Scheduled Date: Wednesday, Jan 29 2014 6:30am - 8:00am
In the enterprise data warehouse (PMPRD), the NTNL_ID field in PS_ASU_D_PERSON_VW will begin to be populated with the last four characters of the person's primary national ID from PS_PERS_NID. Previously, the NTNL_ID field was left intentionally blank ("-") for all individuals.
Please contact firstname.lastname@example.org with questions or concerns about this change.
UTO Data Warehouse team