REVIEWER: David Jones, technical analyst for Hampton City Schools.

BACKGROUND: Hampton City Schools in Hampton, Virginia, is a district consisting of 23 elementary schools, six middle schools, four high schools, one elementary gifted magnet school, and one early childhood center. The mission of the school district is to create school experiences to ensure that all students learn and demonstrate skills needed for lifelong achievement.

PLATFORMS: Mac OS X with Parallels, Microsoft Windows, Oracle E-Business Suite.

PROBLEM SOLVED: 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 district decision-making was immense. Because 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 required a complementary solution they could use with Discoverer to provide users with their own ad hoc reporting capabilities.

PRODUCT FUNCTIONALITY: 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 our 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.

STRENGTHS: Ninety-five percent of the work required to set-up and deliver a report is done automatically for you with NoetixViews. The remaining five percent is gathering internal information to create more customized reports for each individual user’s specific needs.

WEAKNESSES: NoetixViews is unable to pick up every descriptive flex field in Oracle E-Business Suite due to our customizations of the application, and, therefore, we’ve had to pay for Noetix to customize some of the views to meet our business needs.

SELECTION CRITERIA: 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. The district decided to solve this issue with Noetix technology instead of employing outside consultants. Noetix saves time by giving IS 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.

DELIVERABLES: 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, the district has reduced a significant amount of the IS department’s time to deliver reports to the district as well as state and federal agencies.

VENDOR SUPPORT: This easy-to-use solution does not require much support, and end users were comfortable with it almost immediately. Noetix has always been very responsive when we have needed to contact their support team for technical issues.

DOCUMENTATION: The documentation was complete and easy to understand.

NoetixViews

Noetix Corp.

5010 148th Ave. NE

Suite 100

Redmond, WA 98052

(425) 372-2699

www.noetix.com

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access