UK Home Academics Athletics UK's Chandler Medical Center Research Site Index Search UK

News To Use

Notification concerning Transfer University 02/02/2012

Recently, members of the BI Team and SLCM Team have had quite a few discussions concerning the transfer university column. This field can be found on both the Detail Enrollment report, and the Students and Courses Detail report. Our consensus has been that what this field represents on the reports is not clear and the field should be removed from the reports.

The transfer university can mean either the transfer university for first time transfers or the university where the student has transferred credits over the summer. In addition, a user may want just one or all transfer universities for a student. For now, it is best for the BI Team to fulfill requests which include transfer university until we can provide a better self service option.

If you have any concerns, please let us know as soon as possible at BI-Requests@email.uky.edu. Otherwise, transfer university will be removed from the reports by February 10, 2012.

Description Changes to Performance Indices 06/08/2010

Performance Indices (such as GPA, Attempted Credits, Earned Credits, and Graded Credits) have been reconfigured and rewritten. To review name description changes, Read more...

April 2010 Upgrade of SAP BW System 04/06/2010

The University is installing Enhancement Package 1 for SAP NetWeaver. This is a technical upgrade of the SAP BW system which is the Business Warehouse or reporting portion of the SAP system. The ECC 6.0 (online) and portal functions are not being upgraded at this time. The underlying architecture of the Business Warehouse will change, but the user will see minimal differences in “look and feel” or functionality. For more details, read...

Friday, April 9 at 5:00 pm: 16 day transport freeze begins

  • All transports need to be sent to production by 5:00 pm
  • No development work can be done until the upgrade has completed. This includes creating or changing Q reports.
  • No emergency transports can be created
  • Users will still be able to run reports

  • April 9 at 5PM – April 26 at 7AM: Development Business Warehouse (BWD) system will be upgraded and unavailable

    April 9 at 5PM – April 26 at 7AM: QA Business Warehouse (BWQ) system will be upgraded and unavailable

    April 23 at 5PM – April 26 7AM: Production Business Warehouse (BWP) system will be upgraded and unavailable

    April 26 at 7AM: Upgraded BW system will be available to end users

    If you have any questions or run in to problems after the upgrade, please send e-mail to BI-Requests@email.uky.edu. We’ll be happy to try and help.

    BW Performance Index Schedule - Summer/Fall 2010 Priority Registration 03/26/2010

    Due to increased activity on the system during Priority Registration, the BI Team will be running the Performance Index process chains on a reduced schedule. This means the Performance Indices (such as GPA, Attempted Credits, Earned Credits and Graded Credits) reflected in Enrollment, and Students and Courses data in BW will not be updated as often as normal, nor will the corresponding data in V_ZPRFMINDX_ATTR in BWDATA on WHPROD in Oracle.

    The schedule for Performance Index (PI) updates during Summer/Fall 2010 Priority Registration (3/29/10 – 4/20/10) will be as follows:

    2009 / 2010 PIs, normally updated on a daily basis, will be updated:

  • Saturday, March 27th (last daily update)
  • Friday, April 22nd
  • Friday, April 9th
  • Friday, April 15th
  • Wednesday, April 21st (daily updates begin again)

    2007 / 2008 PIs, normally updated every Sunday, will be updated:

  • Sunday, March 28th
  • Sunday April 18th (weekly update begins again)

    BW Student Resident County on Reports 03/17/2010

    Several reports of incorrect resident county data for students have been received by the BI Team. All reports shown above have been corrected. For more details, read...

    BW Performance Index schedule during Merit Weekends 03/11/2010

    Due to increased registration activity on the system during Merit Weekends, the BI Team will not be running the 2009 / 2010 Performance Index process chains the next two Saturdays (3/13 and 3/20). This means the Performance Indices (such as GPA, Attempted Credits, Earned Credits and Graded Credits) will not be updated between Friday at 7:00 AM and Tuesday at 7:00 AM.

    Monday, March 8th – Friday, March 12th
    Sunday, March 14th
    Monday, March 15th – Friday, March 19th
    Sunday, March 21st
    Monday, March 22nd – Saturday, March 27th
    Sunday, March 28th
    2009 / 2010 Performance Index process chain runs daily
    2007 / 2008 Performance Index process chain runs
    2009 / 2010 Performance Index process chain runs daily
    2007 / 2008 Performance Index process chain runs
    2009 / 2010 Performance Index process chain runs daily
    2007 / 2008 Performance Index process chain runs

    For questions, please contact BI-Requests@uky.edu.

    SLCM Options, Specialties, SubSpecialties 03/10/2010

    Changes have recently been made to the BW Detail Enrollment Report with fields added to the Free Characteristics option.

    For details of the changes please review the Changes to the BW Detail Enrollment Report document.

    Users of Student Accounting Data 02/17/2010

    Changes have recently been made to the data provider on which these two BW Web reports are built.

    An improvement has been made in the BW FICA design which will deliver the data in a more timely manner. These reports should now be available for your use by 8:00 or 8:30 AM each morning.

    The source for the FICA Documents report has been changed and you will no longer be able to access saved Z views or Y queries written against the old report. If you are unable to access any Z view or Y query please send the Technical Name of the view or query to BI-Requests@uky.edu.

    The Key Date variable in the Open Item 30-60-90 query has been set to automatically bring back yesterday’s date.


    This variable has been removed from the query and will no longer display on the Variables for Ad Hoc Report screen.

    In addition, this report will only include Open Items. Closed Items will no longer be available through this report.

    Power Users should review the following documents:
    FICA Notification for Powerusers

    How to Look Up Old FICA Views

    If you have any questions, please contact BI-Requests@uky.edu.

    Students and Courses Issue with GPA 01/25/2010

    An issue with GPA calculations on the Students and Courses report was recently identified.

    The way the key figures, such as GPA – Cumulative and GPA – Overall thru Term, were being loaded and aggregated in BW was incorrect on the Students and Courses cube. This occurred when a student booked/canceled the same course n times. The system would multiply the GPA figure by the number of bookings for that term, thus inflating the GPA figures. Read more...

    First Generation Student flag 11/10/2009

    A flag to identify first generation students has been added as a free characteristic on the Detail Enrollment report.
    image of SAP screen

    image of SAP screen

    A first generation student is identified with “Y”.
    image of SAP screen
    If there are any questions or problems, please contact BI-Requests@uky.edu. Thank you.

     

    SLCM Load Schedules 10/20/2009

    SLCM BW report users will be glad to hear that the frequency of the data loads has been increased.

    Data loads which populate these reports are loaded on the following schedules:

    Performance Indices, which include Attempted, Earned and Graded Credits; and GPA performance data are updated as follows:

  • Performance Indices data for academic years 2009 and 2010 is updated Monday – Saturday
  • Performance Indices data for academic years 2007 and 2008 is updated Sundays

    The Detail Enrollment Report (QZCMENRLMT_5000), and other reports written from this cube, are updated as follows:

  • Enrollment data for academic years 2009 and 2010 is updated every night and includes the Enrollment ODS and Cube: ZENRSTAT and ZCMENRLMT.
  • Enrollment data for academic years 2007 and 2008 is no longer updated on a regular schedule

    The Students and Courses Detail Report (QZCHE_09_5000) is updated as follows:

  • Students and Courses data for academic years 2009 and 2010 is updated daily
  • Students and Courses data for academic years 2007 and 2008 is updated Sundays.

    If you have any questions about the BW data, please contact BI-Requests@email.uky.edu.

     

    BI7 Upgrade 05/06/2009

    Due to the enhanced security delivered with the BW upgrade, some modifications have been made to the Payroll Results Q queries. The attached documents detail these changes. Please review any Y queries that were modeled after these Q queries to verify they are set up according to the suggestions in the document. Saved Views are not affected.

    Documents include:
    Modifications to Organization Unit in BW Web
    and
    Modifications to Organizational Unit in BEx Analyzer

    In addition to the above modifications, new security requires a variable or restriction be placed on Company Code. The following document details the changes Powerusers may need to make to Y queries.

    Restriction or Variable on Company Code

    If you need assistance making these changes, please send an e-mail to BI-Requests@email.uky.edu. We’ll be happy to try and help.

     

    line graphic