OBIEE - Change Log - Dashboard

OBIEE - Change Log - Dashboard

Date

Dashboard

Change

Date

Dashboard

Change

2025/09/04

WSU Registrar | Setup Tables

Modified the Acad Prog Plan Sub-Plan (Last Enrolled) report to include academic plan cip code.

2025/09/04

WSU Advisor | Undergraduate Advisor Management | Graduation

Rename the Inactive Students Close to Graduating report to Students Close to Graduating report.  One can use the last enrollment term to select the students.  e.g. if the students' last enrollment term is a year ago, the student is inactive.  But if it is current term, the student is still active and close to graduating.  The renaming is to make it clear the report can fulfill both needs.

2025/08/26

WSU Advisor | Undergraduate Advisor Management | Graduation

Added an Inactive Students Close to Graduating report

2024/08/27

WSU Advisor | Undergraduate Advisor Management | Bookings (Sub Tab with three reports)

This collection of reports have been hidden since the data is not inclusive of all appointment data for all advisors on their students. (requested by Ruth Ryan) 

2024/07/19

WSU Census | Courses

Added Teacher Assignment and FTE, and Teacher Assignment and AAFTE reports on the dashboard, replacing the original group taught and individually taught versions.

2024/07/15

WSU Graduate and Professional Education | Student and Applicant Details

Added Active Student Details report.

2024/07/15

WSU Graduate and Professional Education | Student and Applicant Details

Added Confirmed (Matriculated) Students report.

2024/07/13

WSU Graduate and Professional Education | Student and Applicant Details

Added Admitted Students report.

2024/06/27

WSU Graduate and Professional Education | Grad Students with Instructor Roles

Modified the Grad Students with Instructor Roles report to make it more user friendly, such as using Term description instead of term code, adding college and department in prompt and in report.

2024/06/24

WSU Student Financials

Added Student Financials Balances Aging data visualization.

2024/06/03

WSU Admissions Undergrad | Summary

Added the following data visualization or reports on dashboard:

  • Chart

  • Current Year Current Week Funnel

  • Multi-Year Multi-Equivalent Week Status

  • Multi-Year Current Equivalent Week Status

2024/06/03

WSU Admissions Undergrad | Summary By Academic Plan

Added the following data visualization or reports on dashboard:

  • Chart

  • Current Year Current Week Funnel

  • Multi-Year Multi-Equivalent Week Status

  • Multi-Year Current Equivalent Week Status

2024/04/08

WSU Graduate and Professional Education | Multi Year Week to Week Comparison

Added Equivalent Day Funnel report.

2024/05/22

WSU Registrar | WSU Registrar Office

WSU Student Records | Grades

Updated both Missing Final Grades dashboard by adding a "Missing Grades" prompt, which auto-fills to greater than or equal to 1. 

2024/05/10

WSU Graduate and Professional Education | Program Admissions and Milestones

Modified Program Admission and Milestone report to use graduate assistantship data from Workday.

2024/04/08

WSU Graduate and Professional Education | Multi Year Week to Week Comparison

Added the following data visualization or reports on dashboard:

  • Chart

  • Summary report

  • Summary by Region

  • Current vs Census

  • Current vs Previous Year (PhD, EdD, Master) reports

2024/02/02

WSU Graduate and Professional Education

Rename the original WSU Graduate School dashboard to WSU Graduate and Professional Education dashboard.  Opening up the Fact Book to all active employees, and other menu to Grad Directors, Coordinators and leaderships.

2023/11/21

WSU Student Financials | Student Financials

Added 2 new tabs - SF Balances Aging Report and General Accounting SF Balances. Both new tabs use Workday accounting dimensions.
Revised titles of some tabs with the prefix 'Legacy' to reflect they are based on old Student Data Warehouse data.

2023/02/09

Legacy Financial Data Warehouse | Payroll Expense for Pay Period/Cycles 

Changed the prompt for Pay Cycle and Pay Period to be a choice selection and a range.

2022/11/01

WSU Mainframe Finance

WSU Mainframe HEPPS

New Dashboard rollout

2022/09/14

WSU Legacy Financial Data Warehouse 

New Dashboard rollout

2022/05/02

WSU Schedule Builder | Schedule Builder Data

Hid the column Delivery Type Description and added two columns at end of report,   Combined Section Nbr and Course Offering Nbr

2022/04/01

WSU Advisor | Undergraduate Advisor Enrollment Planning
WSU Enrollment Planning

Changed Alive! Registrations to Coug Orientation Registrations

2022/02/14

WSU Schedule Builder | Simplified SBD

Changed the column alignment of the report when it is exported from OBIEE

2022/02/01

WSU Schedule Builder | Simplified SBD

Added a new column at the end of the report Sections Combined ID

2021/10/20

WSU Census | Grades

Corrected the C- and Below Dis-aggregated Charts to include Grades P into C and Above, PP into C- and Below, NRC into Withdrawn, and added Incomplete categories.

2021/09/27

WSU College of Medicine

Changed out the Enrollment Report with a new report that includes Credit Hr data

2021/09/10

WSU ITS | Low Income Students

Hotspot is loaned to low income students.  Created this dashboard for ITS to check against hotspot requests.

2021/08/31

WSU Advisor | Undergraduate Advisor Management | Bookings Report

Added an additional column at the end of both reports titled  'Appointment Type Name' on this dashboard submenu.

2021/8/11

WSU Advisor | Undergraduate Advising | Apply to Graduate

The Legend for the Processing Status Codes had been removed when we created the page in March of 2021 from the report it was requested to be put back by Blaine Golden.

2021/7/21

WSU Registrar | Veterans

Added the New Multi Veteran Report to this Dashboard from Leonard Cassidy of WSU Vancouver with a text box with information on how to get results for the dashboard.

2021/06/14

WSU Registrar | Veterans

Added a new column at the end of the Veteran Benefit Enrollment - by term, campus, and student group (SDW) report titled 'Tuition Exception' and also added the Term Code to the Prompts.

Added two new columns to the report Veteran Class Enrollment report to reflect the Dynamic Dates 'Class Start Date' and 'Class End Date', moved the columns to be just to the left of the End Date column and was asked to also add the Term Code to the Prompts for the report.

2021/04/29

WSU Scheduler Builder | COVID - Add Supplemental Data

Changed the title on the third column of the report from the left side of the report to read 'Requested Room Capacity' from its original title when report was created which was 'Flipped/Rotated Column'.

2021/04/26

WSU College of Medicine | Enrolled | Grading

Added a new Dashboard folder and a couple of reports for College of Medicine Student Support Services Staff to use term by term.

2021/03/12

WSU Advisor | Undergraduate Advisor Management | Applied to Graduate

Added a version of the Graduation Processing Dashboard report as a Sub-Page of this dashboard page so that Advisors will be able to use either of the reports from this one page.  Blaine Golden requested this report be placed here without the Grad Note and Grad Note Long columns included.  He did request that we add the Grad Status Description to the report for them.  A DBA had to add that column to the view so I could add to the report which they did last night so I updated report this morning and added it to the Dashboard.

2021/03/11

WSU Advisor | Undergraduate Advisor Management | RO_PERC_DROP_SUCCESS QUERY RO_PERC_DROP_SUCCESS

Added the notation of (SDW) at the end of RO_PERC_DROP_SUCCESS (SDW)

QUERY RO_PERC_DROP_SUCCESS (SDW)

2021/03/11

WSU Advisor | Undergraduate Advisor Management | Academic Standing(SDW)

Added the notation of (SDW) at the end of 'Academic Standing Report 1'

2021/03/11

WSU Advisor | Undergraduate Advisor Management | Summer UGRD Session Class Search

Added the notation of (SDW) at the end of the title of the report.

2020/12/14

WSU BUSN

Corrected an error in the Prompt for reports to reference a date yyyy/mm/dd from the Calendar Date folder not from Person Birthdate.

2020/08/12

WSU Enrollment Planning | Course Enrollment

Modified "Subject Catalog Number" prompt in Year-to-Year Comparison Weekly Chart report to an required field.  Added "Individual" to title and text to indicate this report is designed for comparing individual course enrollment only.

2020/08/12

WSU Advisor | Undergraduate Advisor Enrollment Planning

Modified "Subject Catalog Number" prompt in Course Enrollment Year-to-Year Comparison Weekly Chart report to an required field.  Added "Individual" to title and text to indicate this report is designed for comparing individual course enrollment only.

2020/08/11

WSU SFS Office

Added the dashboard.  It is for Student Financial Services Office.

2020/07/24

WSU Enrollment Planning | Course Enrollment

Added Year-to-Year Comparison Weekly Chart, and Year-to-Year Comparison (Equiv Day).

2020/07/24

WSU Advisor | Undergraduate Advisor Enrollment Planning

Added Course Enrollment Year-to-Year Comparison Weekly Chart, and Course Enrollments Year-to-Year Comparison (Equiv Day).

2020/05/28

WSU Covid-19 Survey Responses

Added the dashboard.  It is opened to leaderships, such as Associate Deans.

2020/05/26

WSU Admissions Undergrad

Corrected permissions on WSU Admissions Undergrad dashboard so now OBIEE Answers users can see it.

2020/05/11

WSU Census

UCORE End Term Grade % Failed report is separated into two data visualization reports, and renamed as C- and Below Disaggregated (Individual Chart) and (Charts).

2020/05/11

WSU Student Records | Grades

Added an additional report to the page from a ticket ESSD-23526 stating that not all students with an incomplete grade in a term were being reported in the current report.  It was a true statement because sometime ago the report was altered to include instructors of courses where the student is being taught by a single instructor.  I cloned the report and removed the instructor column and changed the titles of the report to read 'UG/PR Incomplete Indv Taught Courses' and the new report is 'UG/PR Incomplete All Courses'.  

2020/04/20

WSU Census

Under Grades menu, added charts to UCORE End Term Grade % Failed report.

2020/04/15

WSU Admissions Undergrad | Undergraduate Admissions

Added Plan Owner Group Description, and Plan Owner Organization Desc as filter onto the Overview (ADW) dashboard.

2020/04/10

WSU Advisor | Undergraduate Advisor Enrollment Planning

Added Drop Reason report to monitor the drop reasons students reported when using myWSU Self-Service to drop a class.

2020/04/08

WSU Census

Under Grades menu, added UCORE End Term Grade % Failed report.

2020/04/06

WSU International Programs

Added five modified admissions reports from WSU Census with an additional column and prompt for 'Admit Term Type' to allow for the tracking of students who show up in the fall reports but were admitted in summer terms. Typically, these students are rolled together with the fall admits, but the Office of International Programs wanted to be able to parse these groups apart.

2020/03/05

WSU Scdedule Builder

Added four columns to the 'Exam Exam' report on the dashboard requested by Jill Frueden on two separate ESSD tickets, ESSD-20630 and ESSD-21731.  Exam Type Indicator, Component, Units, and Total Enrolled.  Also added new prompt for Instruction Mode and Final Exam Type Indicator.

2020/03/04

WSU Advisor | Undergraduate Advisor Management

Added a new tab Academic Standing (SDW) requested by Ruth Ryan ESSD-18902.

2019/12/17

WSU Schedule Builder

As requested in ESSD-20110 I created a new page on the 'Schedule Builder' sub-menu titled 'Exam Notes' and placed it between 'Schedule Builder Comments' and 'Combined Courses'.  This is a clone of 'Final Exam' with an added prompt for 'Class Exam Type' and removed the filter of 'FIN' on Class Exam Type for this report.  They are needing to see notes placed on the "EXAM" page in CS to better serve Campus Schedulers.  Jill Freuden and Melissa Wing tested the report before it was added to the dashboard.

2019/12/11

WSU Data Validation | Teacher Assignment

Modified Individually Taught Classes Duplicate Instructor report to use prompt for term.

2019/12/05

WSU Schedule Builder

Corrected prompts to remove hardcoding of selected list of Subjects

2019/11/27

WSU Data Validation | Academic Structure

Added PCHEES Program Concentration ID dashboard to check for possible duplication of PCHEES Program Concentration ID due to conversion from Academic Sub-Plan.

2019/11/18

WSU Admissions Undergrad | Recruiter Undergrad Admissions & Undergraduate Admissions

Modified the Overview, Transfer School, Transfer School Year to Year, Trends, State reports to include Postbac Flag in the prompt.

2019/10/22

WSU Schedule Builder

Modified Schedule Builder Comments report to strip out special HTML characters (such as non-breaking space, quotes, etc) in Comments field.

2019/10/20

WSU Data Validation

Added Classes Not Active or Approved but with Enrollment report under Courses menu.

2019/08/27

WSU Schedule Builder

With Ticket ESSD-17580 submitted by Jill Nielson Freuden, we edited the column format of SCC_CAF_ATTR_LVAL labelled in the report presentation layer as 'Comments' by  pasting in 'EVALUATE('REGEXP_REPLACE(%1, ''<.*?>'','''')' AS CHAR(1080),"PS_W_SCHEDULER_VW"."SCC_CAF_ATTR_LVAL")' in the Edit Formula window that then removed the HTML tags that were seen prior to the change.

2019/08/08

WSU Schedule Builder

Video Conferencing sub menu the AMS report was requested to be removed at the Schedule Builders Meeting held 8-7-2019 because it was no longer being used and will more than likely changed with the upcoming change of business processes being worked through currently via Provost Office.  Until processes and procedures have been confirm the report will not be replaced.  Posted a message on the dashboard page to alert users and told them if they had a need for data to send in a Crimson Service Desk request.

2019/07/24

WSU Student Records

Modified two dashboard/reports to add Start Term Academic Level to the prompt:

Grade Distribution - by term, campus, subject and Academic Organization (SDW)
Grade Distribution - by Term, Campus, Subject and Catalog Number (SDW)

2019/07/19

WSU Data Validation

Modified dashboard report Teacher Assignment | Individually Taught Classes to change the Instructor Load Factor prompt from = to <=

2019/07/19

WSU Schedule Builder

Modified dashboard report Teacher Assignment | Teacher Assignment in Individually Taught Classes to change the Instructor Load Factor prompt from = to <=

2019/07/12

OBIEE User Roles

Added a new User Roles Change dashboard report.

2019/07/11

WSU Schedule Builder Data

As a request from Melissa Wing in ESSD-15993 we added three additional columns to the report(Location, Academic Organization, Consent) and reorganized the columns in the report to match list below.  

(Approval Ind; Term; Session Code; Session Start Dt; Session End Dt; Campus; Enrl Status; Class Status; Academic Organization; Acad Group; Course ID; Class Nbr; Subject; Catalog Nbr; Class Sect; Component; Associated Class; Location; Location Descr; Instr Mode; Cls Attr; Cls Attr Val; Room Cap; Enrl Cap; Wait; Facility; Mtg Pat; Meetings Days; Mtg Start Tm; Mtg End Tm; Meeting Start Dt; Meeting End Dt; Topics Title; Print Title; Emplid; Name; Instr Role; Instr Load; Class Notes; Class Note Seq; Internal Notes; Notes/Requests; Consent) 

2019/05/29

WSU DWG-Test

Added the 'Inactive Degree Application' test dashboard to the 'WSU Advisor Dashboard | Undergraduate Advisor Management' so I have hidden this test dashboard on in this folder.

2019/05/29

WSU Advisor | Undergraduate Advisor Management

Added a new tab 'INACTIVE Grad APP' for this new report on the dashboard between 'Apply for Graduation by Term' and 'Census - UGRD Advisor Advisee' per the ticket ESSD-10128 from the Assistant Registrar in conjunction with Ruth Ryan the owner of the dashboard.   This report is to report back all students that had applied to Graduate but did not complete requirements to receive the degree they applied for during that term.  I added text to the prompt area to let users know that the 'Program Expected Graduation Term Code' prompt works for only the current application processing term or future terms because the Final Applied to Graduation process that runs the night of the published calendar date for someone to clear for a degree will remove the term when changing the code to Inactive.

 2019/05/13

 WSU Schedule Builder | Schedule Builder

Added Internal Notes Column to four of the report on this dashboard.  APPROVED, UNAPPROVED, Schedule Builder Data, and New Condensed Sched. Bldr Data.

 2019/05/09

 WSU Advisor | Undergraduate Advisor Management

Added a new report requested with ESSD-14501 from Matt Zimmerman and Ruth Ryan.  The title is on the tab that is titled 'PERC' and the report name is 'RO_PERC_DROP_SUCCESS'.  Ruth Ryan is going to put an announcement on the Advising list serve letting them know that the no longer need to run a Query in CS.

2019/04/18

WSU Schedule Builder | Schedule Builder |Combined Courses and Uncombined Courses

Added Class Status and Enrollment Status columns from PS_W_SCHEDULER_VW to the reports per request in ESSD-13266 also the filter box on the bottom of the page.  Requester also asked that the filter on the CRSE_ATTR equal to/is in CONJ;XLST be removed.

 2019/03/28

WSU Data Validation | Teacher Assignment | Individually Taught Classes

Modified the query to include all instructors regardless of whether there is a student assigned to the instructor.  Added Instructor Role, Instructor Load Factor in report and filter.

2019/03/27

WSU Schedule Builder | Teacher Assignment | Teacher Assignment in Individually Taught Classes

Modified the query to include all instructors regardless of whether there is a student assigned to the instructor.  Added Instructor Role, Instructor Load Factor in report and filter.

2019/03/07

WSU Advisor | Undergraduate Advisor Management

Added Summer UGRD Session Class Search report to allow advisors to easily search for all available class sections based on class starts after or ends before a certain date depending on students preference/ constraint.

2019/02/25

WSU Advisor | Undergraduate Advisor Management

Added Grade Input as prompt on the Mid-term Grade (SDW) report to allow advisors to easily search of Z grades.

2019/02/11

WSU International Programs | International Programs

Added Admissions Overview , Acad Plan by Acad Group (SDW), Acad Plan By Acad Group (ADW) reports.

2019/01/15

WSU Student Records | Unofficial FTE

Added Summary by Campus and Course Level view.

2019/01/15

WSU Data Validation | Intercampus Enrollment

Added ALL_FTE column, based on ALL_SCH (All credit hours) divided by 15.

2019/01/14

WSU Data Validation

Change all CS queries to 2193 for Spring 2019 pre-census checking.

2019/01/07

WSU Admissions GRAD | Admissions - Graduate

In Equivalent Day Comparison and Free Day Comparison reports, remove Program Action Reason Desc from the report. It is not needed, and its existence causes the counts to be slightly lower due to inner join.
In Admission Cycle Trending Graphics, added Fall 2019 term in the prompt so the graphs would show Fall 2017, 2018, 2019 three terms comparison.

2018/12/11

WSU Data Validation | Teacher Assignment

Added 2193 report for Individually Taught Classes Duplicated Instructor page.

2018/12/11

WSU Admissions Office

In Overview report, added "Confirmed To Campus" column and correct the report to use enrollment campus for newly enrolled students.
Moved "Change of Campus" table from Overview report to its own "Change of Campus" report.
Added Full Details Admissions, and Full Details New Enrolled reports.