Deseret Power & Transmission
With help from an outside consulting firm, Deseret Power’s four-person IT team implemented Oracle E-Business Suite version 11i within a five-month period which ended in May 2005. Shortly after moving to Oracle, the team discovered that their end users were having a challenging time obtaining the basic and custom reports they wanted from the Oracle database. Inevitably, the IT team ended up spending valuable time simply writing reports requested by the users within the company. The majority of the team became dedicated to creating these reports on a full-time basis.
“We were struggling to get reports written for people and it was consuming too much of our time,” said Tami Nolte, senior programming specialist at Deseret Power. “Most challenging was preparing the data: finding the data and preparing it for the report. Oftentimes, we did not know where to go to within Oracle to even obtain the data our users had requested. So we were truly feeling the pain of constantly trying to obtain what the end users needed.”
After six months of working to create reports on their own, the Deseret IT team decided they needed a reporting tool that could provide a solution beyond what Oracle Discoverer and SQL offered them. They happened to see a Noetix demonstration at a regional Oracle Applications Users Group conference and invited Noetix to give a demonstration on-site. Shortly thereafter, they purchased the full suite of products including NoetixViews and the Noetix Platform.
“The reason Noetix looked like a great fit was that they had already done the legwork of creating the views,” said Nolte.
With Noetix, the IT team had immediate access to hundreds of business views which greatly simplified their ability to create reports and also saved them the manual mapping effort normally required. In addition, the team is teaching the end users to create their own reports using Noetix and estimates that a quarter of the end users now rarely need IT support.
Deseret’s end users now access information to build their own reports in order to better run the business. For example, many reports are developed to create a picture of the company’s inventory: numbers of items available, where items are located within the warehouse, the amount of time each item has been there, etc. Within the human resources department, reports are developed to provide intelligence on payroll and how employees are using benefits. In the finance department, employees are able to go from a general ledger summary report and drill down into details of each line item.
“Now that the users can go out and develop their own reports, they’re freeing us up to do other things,” said Nolte. “And even when I do encounter a user that’s not well-versed on Noetix, I can use the solution to more quickly build a report for them than I ever could before. I can also easily find a view that Noetix has already developed that I can customize and modify just enough to satisfy them.”
Deseret Power’s IT team estimates that Noetix saves them a total of 10 hours per day on report writing. They expect to save even more time as user base adoption of Noetix continues.
Senior Programming Specialist
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.