Quixtar Using New Business Intelligence Tools

 ComputerWorld

As companies expand access TO business intelligence tools to more users, IT departments are doing a lot more performance and usage monitoring.

When BI software was only used to do historical reporting for a handful of power users, the dependability of servers or the content of reports wasn’t as critical as it has become now, according to IT managers and analysts.

For example, the city of Albuquerque in New Mexico will shortly go into production with the Cognos 8 BI suite, which will let external users access reports on restaurant inspections and building permits, says Chris Framel, applications group manager in the city’s IS division. Internal users will begin using the BI tools in September, he says. Within the suite Framel plans to use Cognos Event Studio, an event-notification tool, to alert IT staffers if exceptions occur, such as users not receiving reports.

“Now we come in the next morning to check and see if programs have failed,� Framel says. “It is really all reactive rather than proactive.�

Framel would like Cognos to develop an auditing database that he could use to monitor if and how reports are being used, he says.

“We do need to do that because we have several hundred reports.

“It would be nice to know what reports they are using, and if they are not, then we could get them out.�

Investment bank Morgan Stanley uses Business Objects’ auditor tool to cancel “runaway queries� that last for more than ten minutes and to identify reports that are not being commonly accessed by its 9,000 users so they can be eliminated, says Michael Strachan, vice president of business intelligence metrics at the bank.

Morgan Stanley has begun testing a new query performance and data-usage tool from Appfluent Technology to help boost the performance and reduce the costs of its BI applications.

Because Morgan Stanley allows some users to do self-service, ad hoc analysis, it’s testing the tool as a way to allow database administrators to see queries that are running and identify bottlenecks, Strachan says. It hopes to have the tool in production within two months.

Quixtar, an online health and beauty products retailer, plans to automate the monitoring of the BI reports it sends to the 200,000 to 250,000 business owners it works with, says Dennis Albachten, the company’s senior BI analyst.