Important My Reports Update

The upgrade to the new hosted Hyperion environment will take place on December 28, 2015. Any content created or changed after December 22, 2015 in the current environment will not be migrated to the new environment. In addition, any content in the University Wide>Transfer folder will not migrated.  Please see the Upgrade FAQ article for additional information: KB0013698.

Upcoming Hyperion Upgrade

The upgrade to the new hosted Hyperion environment is coming soon. We are currently working on moving our Hyperion software into a hosted environment provided by Sierra Cedar.  We still have a lot of testing to do, but hope to go live sometime in December.  An ‘Upgrade FAQ’ article has been created which should address a variety of questions that you might have at this point: KB0013698.

Revised HR Expenditures Report

The newly revised “HR Expenditures” prebuilt report is now available to HR users.   This revised report provides filters for pay end date, account, position number or emplid and no longer contains those high maintenance union queries.

This report replaces both the ‘HR Expenditures by Emplid’ and the ‘HR Expenditures by Account’ reports.  If anyone still wants to use those older versions, they have been moved into the ‘Deprecated Queries’ folder and renamed with a ‘Historic’ prefix.

Admin Apps replaces MyApps

Effective, Monday, August 11, 2015, the instant of My Reports available through My Apps was disabled.  Its replacement is Admin Apps.  Information about how to use Admin Apps to access My Reports can be found at: https://asu.service-now.com/ess/kb_view_customer.do?sysparm_article=KB0013403.

PS9.2 Upgrade

Some of the reports in My Reports may be affected by the PS9.2 upgrade due to changes in some of the data warehouse tables.  We have documented these tables and the list can be found here (see link below if link does not work) 

If you encounter any problems with any My Reports reports after the change has been implemented (scheduled for 2/10), the following help article will help in resolving some of the potential issues:   https://asu.service-now.com/kb_view.do?sysparm_article=KB0011007

If you still need assistance modifying an existing report in My Reports, please submit a ticket to the My Reports team.  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” and search for 'My Reports' in the Search Catalog field. 

Also, please note that information that comes from PeopleSoft  will not be refreshed between Thursday, 2/5 through Monday, 2/10 due to the HR Upgrade.

Google URL:

https://docs.google.com/a/asu.edu/spreadsheets/d/1YfdiCBTledgi95wFRQpwgEiRWOkKQMYl_Djg03BfHGY/edit?usp=sharing

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