Data Warehouse Enhancements and Changes - July 3, 2014

The following staging tables have been added/changed in the Enterprise Data Warehouse (PMPRD):

Changed Tables:
PS_ASU_AD0107_PYMT - Jira DW-404: add columns and change primary key to match source system (CSPRD)
PS_ASU_ADM_SA_TBL - Jira DW-345: add ASU_CLASSROOM_LCTN
PS_ASU_AA_POS - Jira DW-345: add fields ASU_ADS_SPECIALZ & ASU_CLASSROOM_LCTN

For information about how to update your existing reports to reflect these table changes, please see article https://asu.service-now.com/kb_view.do?sysparm_article=KB0011284.

New Tables:
PS_CMNT_CATG_TBL - Jira DW-331
PS_ASU_GRAD_CHG - Jira DW-350
PS_ASU_AD0138_TRK - Jira DW-470

Please contact datawarehouse@asu.edu with questions or concerns about these changes.

Thank you,
UTO Data Warehouse team

ServiceNow for Staff Service Requests

In all of UTO, we are now using a product called ServiceNow to track our work and requests for services. 

To request our services, simply go to:https://asu.service-now.com/ess/catalog_content.do?sysparm_content_url=com.glideapp.servicecatalog_cat_item_view.do?sysparm_id=671c4aea3d7b110047cd2eb67a2c3041 (you may be prompted to login).

Or to enter in a request for service, or to report an incident, simply go to My ASU and click on the “Service” Tab, and click on “Submit a Request”.  If you type in My Reports in the Search Catalog field, you’ll find us right away.  This page can be used for all of your UTO needs as well. 

Sending an email to myreports@asu.edu will no longer generate a service request, however we will continue to monitor this email address during this intermediate transition time.  

Thank you so much!

My Reports Open Office Hours

Due to fluctuating attendance and the implementation or our new toolsets, our offering on “My Reports Open Office Hours” will no longer be available in person.  We will now be offering this service through remote sessions using Adobe Connect.

To attend remotely, visit https://connect.asu.edu/openofficehours/.  Click the radial button next to “Enter as a Student or Guest”, type your first and last name in the “Name” box and click ENTER ROOM.   Once you have logged into the room, we will provide you with a call in number.

This change will be effective immediately starting this Thursday, 6/26/2014.  At this time, this is still offered on Thursday afternoons between 1-4 pm but be sure to check our training page at http://asu.edu/it/eds/training for availability updates.

Please contact us if you have any questions regarding this upcoming change.

Thanks,

UTO BI Analytics Team

Internet Explorer Vulnerability -- UPDATE

A patch has been issued for the Internet Explorer vulnerability that caused the ban of its use, impacting My Reports / Hyperion users.
Depending on your computer’s configuration and update policy, this patch may have been installed on your computer.
If this patch has been installed, you may return to using Internet Explorer.

Below is a way to identify if the security update (KB29464358) has been applied to your computer:

Through the Control Panel
1.    Go to Control Panel> System and Security> Windows Update
2.    If you don’t see “Windows is up to date”,  click on ‘Check for updates’
3.    You may get a message that ‘no updates are available’ or ‘updates are available’.
4.    If important updates are available, apply them.
5.    To confirm which updates have been installed, click on the “View update history’ link.
a.    If it indicates that Windows is up to date, you can verify by clicking “Check for updates”
b.    The update will have KB2964358 in the name.  “Security Update for Internet Explorer nn for Windows 7 for xnn-based systems (KB2964358)”
c.    This indicates the patch has been applied.


What if I do not see KB2964358 installed?
Primary option:  Contact your desktop support team
Secondary option: Go to http://www.microsoft.com/en-us/search/DownloadResults.aspx?q=KB2964358 and download the correct update for your browser/operating system combination.

Internet Explorer Vulnerability

My Reports users can access Hyperion through My Apps.  You can get into My Apps with Chrome, Firefox and Safari. Within My Apps, the IE8 browser is safe because it can only get to the Hyperion address and cannot access any other site.

There is also a downloadable application that is an unofficial workaround that can also be used to access My Reports.  This application uses a locked down version of Firefox 2 within it.  Please keep in mind that this FF based application was not created by UTO so it has little or no support and may not successfully install on all machines.

Individuals should also change their default browser setting when accessing links.  Below are the instructions on how to change your default browser:

Type "default programs" in the Start menu (bottom left of your screen) search box. This should bring up a screen that will let you select program defaults as well as default file types. You'll want to set your favorite web browser as the default, which should force it to open your email links. If that still doesn't work, select "Associate a file type or protocol with a program" and associate ""URL:HyperText Transfer Protocol" with your web browser of choice. Repeat for file types "HyperText Transfer Protocol with Privacy" and FTP.

If you need assistance in configuring My Apps, please send an email to myreports@asu.edu.

Thanks for your patience until the Internet Explorer is resolved.

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 https://asu.service-now.com/ess/kb_view.do?sysparm_article=KB0010086.

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.

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