As a former financial analyst and current Microsoft Certified trainer, I’ve watched Microsoft Excel undergo a myriad of changes since its introduction in the mid-1980s. When I’m approached about how to solve a particular problem in Excel, I’m happy to tell people that the Microsoft development team has a renewed emphasis on creating new calculation functions that can help them simplify formulas and be more efficient.
Project managers and executives in asset-intensive industries like utilities, oil and gas, or chemicals need up-to-the-minute data on projects, as they usually manage a myriad of capital expenditures for infrastructure upgrades, capital works or capacity expansions. But what happens when an ERP software reimplementation pressures project management processes, reporting and strategy? In this blog, Donna Christie, finance applications and reporting specialist for ActewAGL, shares how a reimplementation of Oracle E-Business Suite (EBS) version R12 from a highly customized R11i version impacted access to Oracle projects data.
Even when organizations have business intelligence (BI) solutions and ERP reporting tools like those from SAP or Oracle E-Business Suite (EBS), they often turn to Microsoft Excel for reporting and analysis because it’s easy and flexible.
Like many companies that rely on the SAP enterprise resource planning (ERP) solution, Aigle ― and the company’s Hong Kong office in particular ― was concerned that reporting from SAP is time consuming and difficult.
Last week, we made our tenth consecutive trip to San Francisco for Oracle OpenWorld, the world’s largest conference for Oracle customers and technologists. The event, which has ballooned in attendance from 50 in 1982 to 50,000 in recent years, was once again a great opportunity to learn about forthcoming Oracle technologies, as well as the challenges and needs of Oracle users.
As of June 2017, Oracle will no longer offer even extended support for Discoverer, which is reflected in our survey findings where 64 percent of respondents said they were planning to migrate away from the reporting tool within the next year.
Business Intelligence (BI) projects can be lengthy, complex, costly and even risky. One of the top reasons such initiatives fail, according to a recent Business Intelligence Solutions Review, is user acceptance, because even the best analytics solutions still require skills some users don’t have.
As the national library of the United Kingdom, The British Library is the world’s largest by number of items catalogued. Boasting more than 1.6 million visitors yearly, the Library places great emphasis on technological changes, according to Stewart Starr, Management Accounts Assistant for the Library,
It’s no secret that many finance users find standard ERP reporting tools difficult to use. Because of the complexity of data structures in systems like SAP and Oracle, these users often find themselves dependent on IT or consulting resources to create reports ― or waiting on lengthy downloads of static information from a warehouse to where it’s formatted and analyzed, which is usually in Microsoft Excel.
Accurate and timely Cost Center reporting is essential for tracking expenses, understanding which parts of the business are contributing to revenue growth, and improving operational efficiencies to ultimately maximize profits.