Hampton City Schools
Most of Hampton City Schools use Macs running OS X, making the district one of Apple’s largest K-12 school district customers. Hampton City Schools purchased Oracle E-Business Suite in 2001, running Oracle HRMS as well as financials—Oracle Payables and Oracle General Ledger.
Hampton’s IS department relied on Oracle Discoverer as their main reporting tool, using Discoverer Desktop with custom built End User Layers (EUL) and business areas. The department liked the Discoverer tool itself as well as the Web-based interface of Discoverer Viewer so they didn’t need to install Discoverer on every desktop. However, they continued to struggle with the complexity of Oracle tables and columns within Oracle E-Business Suite.
In addition to deciphering Oracle E-Business Suite’s tables and obscure column names, the IS department also had to deal with managing Oracle security issues for the different roles and responsibilities between Discoverer, the different business areas, and the application database.
With business users of various functional disciplines—human resources, payroll, finance, and benefits—as well as teachers, the number of Oracle Discoverer reports required to support their decision making was immense.
Since the IS department consisted of just 12 people, three of which were dedicated to supporting the reporting needs of more than 4,000 users, they searched for a complementary solution they could use with Discoverer to provide users with ad hoc reporting capabilities.
Hampton City Schools selected NoetixViews for Oracle E-Business Suite along with Noetix Generator for Oracle Discoverer for its ability to drastically reduce the time to build workbooks for their Finance, Payroll, and HR departments. In addition, the solution provided a simplified end user reporting environment that allows nontechnical business users to build reports on their own using NoetixViews with Discoverer.
“Ninety-five percent of the work required to set-up and deliver a report is done automatically for you with NoetixViews,” said David Jones, Technical Analyst for Hampton City Schools. “The remaining five percent is gathering internal information to create more customized reports for each individual user’s specific needs.”
Noetix also offered the bonus of built-in security that seamlessly integrated with the district’s data access rules for their pre-determined Oracle user responsibilities.
“Normally there is an enormous amount of work involved with setting up and managing proper Oracle application security roles, tying those into responsibilities, and then having to track all of it,” said Jones. “Noetix saves a lot of time by giving us the ability to maintain the EUL very easily through upgrades and patches as well as providing built-in security that seamlessly integrates with the data access rules for our various business areas.”
Hampton City Schools also leverages Noetix Search, an intuitive browser-based application that enables users to explore Noetix content and quickly find the specific Noetix views they need to build their own reports.
With NoetixViews, Hampton City Schools has achieved a new level of efficiency by giving technical analysts and users the ability to more easily locate the data required to generate out-of-the-box reports in a fraction of the time it used to take with Oracle Discoverer alone.
Tables are now labeled in familiar business terms, and by eliminating the manual process of finding and joining those tables to run reports, Hampton City Schools has shaved a significant amount of their IS department’s time to deliver reports to the district.
In addition to the time savings, the school district has been able to easily generate views for state and federal reporting, which has replaced what once was an extremely tedious process.
Hampton City Schools
As part of the Magnitude Software family of products, Noetix world-class business intelligence solutions are used by hundreds of industry leading customers worldwide. Armed with immediate access to Oracle E-Business Suite data, users finally have the answers they need to make better business decisions.
Magnitude Software leads the way in delivering corporate performance management (CPM), master data management (MDM) and connectivity in heterogeneous environments.
© Magnitude Software, Inc.