Thursday, November 14, 2013

Data Warehouse: Enhancements and changes - November 12, 2013

Several Data Warehouse changes are planned in the coming week. Details are below. Please contact datawarehouse@asu.edu with questions or concerns about these changes. 

Enterprise Data Warehouse (PMPRD)

Wednesday Nov 13 2013 8:00pm – 9:00pm
Per user request, CS view PS_ASU_AD113_MC_VW needs to be created and loaded in the Enterprise Data Warehouse.  The source view contains about 1M rows. 
A new table called ASU_AD113_MC_VW_P will be created in the ASUDW schema.
A new view called PS_ASU_AD113_MC_VW that selects from ASUDW. ASU_AD113_MC_VW_P will be created in the SYSADM schema. 
View SYSADM. PS_ASU_AD113_MC_VW will be exposed to the My Reports user community in the CS mart.


Thursday Nov 14 2013 8:00pm - 9:00pm
The following four tables from Student Athlete Academic Profile will be added to the Enterprise Data Warehouse:

  • ASU_STD_ATH_PRF
  • ASU_ATH_ELG_TRM
  • ASU_ATH_LEARN
  • ASU_ATH_NOTES


Monday Nov 18 2013 8:00pm - 9:30pm
There are several logic changes to the 'new' Admissions Fact application table in the Enterprise Data Warehouse:
1. Military Changes (Jira case AD-505):
• MILITARY_CONNECTION_CODE (formerly VETERAN_OR_DEPENDENT_FLG): set to A for Active, V for Veteran, D for Spouse/Dependent, U for Unknown
• MILITARY_STATUS: logic change, to form consistent values over time, as available application responses change
• MILITARY_BRANCH (formerly VETERAN_BRANCH): set to military branch of the military personnel, whether active military, veteran, spouse/dependent
The changes above include database schema changes to both ASU_ADM_APPLICATION and ASU_ADM_APPLICATION_SNP.
2. ADM_EVAL_COMPLETE_DT logic change: for reconsidered Grad apps, set ADM_EVAL_COMPLETE_DT to LAST_AP_ACTION_DT (Jira case AD-596).
3. Add Cross Reference table ASU_XREF to store crosswalks from value(s) to a value. Change CI Band and TRN GPA Band logic, to use ASU_XREF rather than hard coding the logic in procedural code. This allows translation changes without code migrations. (Jira cases AD-347, AD-348)
Expected User Impact: Queries that use ASU_ADM_APPLICATION and/or ASU_ADM_APPLICATION_SNP should be adjusted to use the new and changed Military and Veteran columns, listed in #1 above. Also, there will be brief (4-8 minute) unavailability of data in the tables ASU_ADM_APPLICANT, ASU_ADM_APPLICATION, ASU_ADM_INTL_STUDENT.


Coming Soon (Repeat Announcement):

Enterprise Data Warehouse (PMPRD)
The obsolete Admissions Fact table (ASU_A_ADM, a.k.a. PS_ASU_A_ADM) is being deprecated using a phased approach:

In the near future, we will stop refreshing this table. The table will still be available for queries for a period of time, but the data will no longer be updated. There is no firm date for this step, but the timeframe is before the end of November 2013. The data warehouse team invites feedback at datawarehouse@asu.edu.

After approximately two months (January 2014), the table will be renamed, and general queries will no longer have access to it. By that time, queries that need up-to-date admissions information should have been 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. 
Jira case(s): AD-589

Data Warehouse: Enhancements and changes - November 1, 2013

On Monday, November 4, 2013 between 8pm and 10pm:

Legacy Data Warehouse (enterprise1 FINANCIAL):
The COST_SHARE_FLAG field in the ACCOUNT table on enterprise1 FINANCIAL is being changed and renamed. This field was added to the data warehouse earlier this year. Currently, the field contains only Y or N. With this change, the flag will become a code. Possible values include Y, N, C and S. As such, the field is being renamed, from COST_SHARE_FLAG to COST_SHARE_CODE. Jira case(s): DW-322.

Enterprise Data Warehouse (PMPRD)
There are several logic changes to the 'new' Admissions Fact business rules for loading.
1. Last Stack: select min(stdnt_car_nbr), then apply Effective Dating logic, when crossing over to Student Records to get Last Program and related fields. Jira case(s): AD-594.
2. Measles Hold Flg logic: populate this flag only for admitted students. Students who are not [yet] admitted will have a value of NULL. Jira case(s): AD-582.
3. Fix typo in TRN_GPA_BAND (2.49 should say 3.49). Jira case(s): AD-595.
4. Technical Enhancements to improve load performance. Jira case(s): AD-575, AD-573.
There are no table changes, i.e. there are no dropped, new or changed columns.
Expected User Impact: brief (1-8 minute) unavailability of data in the tables ASU_ADM_APPLICANT, ASU_ADM_APPLICATION, ASU_ADM_INTL_STUDENT


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

Coming Soon:

Enterprise Data Warehouse (PMPRD)
The obsolete Admissions Fact table (ASU_A_ADM, a.k.a. PS_ASU_A_ADM) is being deprecated using a phased approach:

In the near future, we will stop refreshing this table. The table will still be available for queries for a period of time, but the data will no longer be updated. There is no firm date for this step, but the timeframe is before the end of November 2013. The data warehouse team invites feedback at datawarehouse@asu.edu.

After approximately two months (January 2014), the table will be retired (e.g. dropped) and queries will no longer have access to it. By that time, all queries that use the old Admissions Fact table should have been 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. 

Tuesday, October 22, 2013

Changed Table: Vendor

Financial Warehouse
 
VENDOR table has been replaced by VENDOR_TBL in the Financial Data Warehouse.


Here is what you need to do to modify your query:

  1. Change VENDOR table to VENDOR_TBL table in your existing query.
  2. If you also join VENDOR table in your existing query, you will need to change the link to Left join instead full join in your query.
We have created another help article (http://help.asu.edu/sims/selfhelp/SelfhelpKbView.seam?parature_id=8373-8193-7884) for instructions on how to change a table name.

If you have any further questions regarding the new Vendor table, please contact the Advantage Helpline at advantage-q@asu.edu.  If you need assistance in modifying your existing query, please contact the BI Reporting team at myreports@asu.edu.

Thursday, July 11, 2013

Making Internet Explorer (IE) 10 Compatible

The interactive reporting format within our current Hyperion software version (11.1.1.3) is only officially compatible with Internet Explorer 8. However, certain modifications can possibly resolve this issue for Internet Explorer 10. If you are using Internet Explorer 10 (IE10) and already have the Hyperion plugin installed, the instructions on making IE10 compatible can be found at: https://asu.service-now.com/ess/kb_view.do?sysparm_article=KB0010086.

Tuesday, June 25, 2013

New or Changed Tables and Views

Student Records/Census
  •  CS__DESCR_CENSUS_DATES - is now available for reporting in My Reports.  This table can be used by  to find out special term specific dates such as the 21st day and the 21st day of session B. This table is refreshed nightly from CENSUS on Enterprise1 (E1) on which Institutional Analysis maintains this information.

Friday, June 7, 2013

PS_ASU_D_PERSON_VW Enhancements

Changed Multi-Dimensional Warehouse (MDW) Tables/Views

Long-awaited enhancements to PS_ASU_D_PERSON_VW are now in production (PMPRD), as of 05/31/13. Thanks again to Marco for his development work on this!

Changes and improvements are:
  • Query performance; it is faster 
  •  New fields
    • DECEASED_FLG
    •  ASU_SIS_DIR_RL_FLG
    •  RES_HALL_STATUS
    •  RES_HALL_COMMUNITY
    •  ETHNIC_GROUP_SD_LIST
    •  ASU_CITZN_COUNTRY_LD
    •  HOME_CNTRY_LD
 For more details see PS_ASU_D_PERSON_VW enhancements - May 2013)