Scrutinizing the numbers

RISING TO AID C-level executives under accountability pressure, BI (business intelligence) and enterprise application vendors are stepping up to the plate with offerings designed to improve financial visibility.

New federal regulations require that CEOs and CFOs at approximately 1,000 of the country's largest public companies must certify the accuracy of their financial statements, beginning with quarterly reports due on Aug. 14.

Cognos and Sagent are among many BI vendors that have responded by bolstering the analytics capabilities of their offerings in an effort to give executives greater visibility into financial reports by allowing them to drill down into specific transactions.

BI platforms narrowly define data and thereby help companies avoid honest mistakes as well as fraudulent attempts to "cook the books," said Delbert Krause, senior product manager at Burlington, Mass.-based Cognos.

Cognos in June rolled out a financial management application designed to boost a company's insight into financial performance. In November the company will add capabilities that support integration with Microsoft Excel.

"[Executives] would like to know every step that took place, from the gathering of the data to the analysis, to the adjustments that are made ... so that they can always look at a number and understand where it came from," Krause said. "When you define the data to come in a certain way, the system will process it as it is defined. Gray areas of definitions would be very easily exposed."

Sagent this week is scheduled to unveil a new information integration offering designed to allow users to combine data ad hoc from multiple sources. The new technology, which comes in the form of the company's DataFlow server repackaged as an extraction, translation, and loading tool, provides real-time integration by combining external information on the fly with data from a data warehouse, according to officials at the Mountain View, Calif.-based company.

Executives often struggle to integrate multiple data sources that can then be analyzed and culled for financial reporting, said Dave Henry, vice president of product marketing at Sagent. For example, inventory data may be stored in the data warehouse whereas sales information is housed elsewhere. Or, an executive may want to link financial reports from multiple divisions and compare them with industry benchmarks as part of financial reporting.

"It can connect to any source of structured data regardless of the origin and blend all the information into a real-time virtual view," Henry said. "We can either use the information where it resides, or it can be put in a data warehouse."

The view can be called from within reporting tools and spreadsheets or via Web services, he added.

BI financial solutions are designed to boost accuracy compared to using only shared spreadsheets, which lend themselves to mistakes, said Cognos' Krause.

"When you're dealing with an application like Cognos Finance, it is one database with all the security and mechanisms to ensure that the data isn't changed or altered inadvertently," Krause said.