Monday, April 21, 2014

Making Internet Explorer (IE) 11 Compatible

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
http://help.asu.edu/sims/selfhelp/SelfhelpKbView.seam?parature_id=8373-8193-4508

Thursday, April 3, 2014

Upcoming SPONSORED proposal table changes


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.

Please contact datawarehouse@asu.edu with questions or concerns about this change.

Thursday, March 20, 2014

New Admissions Fact Tables and Dashboard


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/).

 

Access to PROPOSAL_ANNUALIZED_RECOGNITN table


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

Archive Admissions Tables


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 myreports@asu.edu.

Tuesday, January 28, 2014

Data Warehouse: enhancements and changes - NTNL_ID in PS_ASU_D_PERSON_VW


 
Enterprise Data Warehouse (PMPRD)

Scheduled Date: Wednesday, Jan 29 2014 6:30am - 8:00am

Summary:

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 datawarehouse@asu.edu with questions or concerns about this change.

Thank you,
UTO Data Warehouse team