At the 2018 Connecting Communities of Education Stakeholders Conference, I was very pleased to be in a session where Mark Housner from NCDPI demonstrated the use of Oracle Application Express (APEX) for PS Enterprise Reporting. All of the reports the user can create are interactive style reports and allow for some manipulation of the data. SQL queries can be created using the query builder, combining data from tables in the ER categories and turned into reports.
There are two applications within the APEX site when you log in, and the system will allow you to create other applications, however, when the site is refreshed, the other added applications are removed. Therefore, it is best to create new pages and reports within the existing two applications using data within the tables accessible in Enterprise Reporting. If you are interested in using this functionality in ER, I suggest learning basic SQL by taking a course on Udemy titled Oracle SQL – Step by Step SQL. Also, a course in Application Express from Udemy is quite helpful. These two courses are the next best thing to spending thousands of dollars attending online courses on SQL and APEX. .
A limitation of the ER APEX is the restriction of adding other data into the queries which are not included in the Power School ER categories, such as mClass data and EVAAS exports such as projected scores. For this reason, a complete data reporting solution really needs to be external from the Enterprise Reporting environment. For that reason, Data Smart LLC builds its data mart sites using Application Express in a secure hosted environment, using a custom security system for allowing access to the data, AND an unlimited number of data tables.
Have fun with APEX in Enterprise Reporting, and if you want to know more about how APEX can eliminate the spreadsheet reporting for testing data contact firstname.lastname@example.org.
select FNAME.Table 1, LNAME.Table2,
FNAME ||’, ‘|| LNAME
inner join Table2 on Table1.SID = Table2.SID;
where FNAME = ‘Lew’
Dr. Lew Johnson
Application Express Developer