Free Newsletters
Technology & Business Daily

InfoWorld
Log-in | Register
Page 2 of 3  «  Previous Page    Next Page » 

CPM software: an elegant way to measure business indicators

 

"Organizations have done a great job and siloed information. CPM takes advantage of all of these," BPM Partners' Colbert adds.

Free IT resource

Open Source Business Conference (OSBC) May 22-23, 2007

Sponsored by OSBC

Free IT resource

Virtualization Insights from Top Experts - Learn how virtualization gets real!

Sponsored by Dell

DOWNLOAD PDF

Click here to download InfoWorld's special report Corporate performance management


Return to: Pervasive BI

DOWNLOAD PDF

Click here to download InfoWorld's special report Pervasive Business Intelligence


To consider a CPM deployment, organizations that haven't completed at least basic integration of key financial and operations data need to build those systems first, identifying the key data, what it means, where it resides, and how to access it. "The majority of companies have the data somewhere," Colbert says. "But the ones with financial systems and transactional systems in place are the ones that can take advantage of it."

For most others, performance data tends to exist in individuals' Excel spreadsheets, notes Mike Rost, director of product marketing at ERP provider Lawson Software.

To deploy CPM, organizations need some sort of central data repository -- one or more data warehouses, data marts, cubes, or databases with a common data architecture -- that can be used as a trusted, audited source of truth, Rost says. That's not to say that all the data must reside in one data store. Regardless, companies must know where key, validated data is and that the relevant, agreed-on metadata, business rules, and metrics are accessible to the CPM system. (Companies also have to have already integrated all or much of that data; otherwise, they won't know whether what they have is relevant, let alone accessible, Colbert notes.)

For example, product lifecycle management provider UGS uses Hyperion Essbase data cubes; utility Baltimore Gas & Electric (BG&E) pulls its data from an Oracle Financial database; credit-union services provider Southeast Corporate Federal Credit Union uses a set of Applix TM1 data cubes; and hospital group Centra Health accesses a set of SAS applications that have a common data architecture. Except for Centra, these organizations pull their data from various transaction and departmental systems, "scrubbing" the data for accuracy and consistency and placing it in validated data stores. Centra has the advantage of already having had to meet regulations that require integrated, consistent data systems, says Kim Price, decision support manager at Centra.

In some cases, organizations can tap into real-time transaction systems rather than use intermediate data stores, as long as they know the data is valid and under what circumstances it's OK for managers to see KPIs based on incomplete or unverified data, IBM's McAuliffe says. He also concedes that managers need to be wary of spending too much time tracking minor variations in unaudited, real-time data.

Sorting the Essential From the Tangential

After an enterprise has a sufficiently robust data infrastructure in place, the big challenge becomes figuring out what data is meaningful, trustworthy, and relevant. Ditto on the metrics used to contextualize that data.

For example, in its CPM deployment, UGS found that, although it could get lots of data from its SAP order-entry and service-billing systems and its homegrown CRM system, some vital data just didn't exist in the SAP data structures, such as revenue from new customers, recalls Eric Kline, director of IT applications at UGS. So, the company had to develop logic rules to create this information from other data. "Additional fields may need to be created or captured" in existing systems, he notes.


Click for larger view.
"We really had to work through what the targets and benchmarks are," Centra's Price notes. That process led to questions such as "If you are at 99 percent [of a target], is that a negative? Is it 100 percent all the time?" she recalls of the hospital group's SAS Strategic Performance Manager-based CPM effort. "It's also hard to choose the things where we don't look so good," despite the fact that targeting those areas usually leads to performance improvements, Price says.

A CPM effort can also expose -- or be torpedoed by -- internal politics. Because a truly effective CPM system allows no one to hide their performance or to maintain silos of proprietary information, accessing the right data and metrics can require navigating difficult political issues. Board members, senior managers, and other authorized users suddenly have access to the same information at the same time. Because of this, report massaging goes away -- as it must for true transparency. Meta Group's Poe suggests that IT staff are well-suited to navigate these waters because they "know how to dissect the unknown -- they're used to change and [to] being transparent from having to share with others on a team." But strong executive support is ultimately required to ensure real sharing, Lawson's Rost says. Otherwise, "you'll find some people trying to protect their turf," UGS' Kline adds.

More Analysis, Less IT

After management has bought into a CPM effort, enterprises often discover that proper data discovery and analysis requires a strong partnership between IT and business staff -- and that effort can easily take 60 percent to 80 percent of the deployment time, Meta Group's Poe notes. "Don't rush to code," he advises.


Continued
»  Previous Page | 1 | 2 | 3 | Next Page » 



 


 
Galen Gruman is a San Francisco-based freelance writer.
 

TOP NEWS:


»  Four quick tips for choosing an IM security product
71 percent of businesses will invest in real-time messaging this year. If you're one of them, be sure to protect your enterprise

»  Forrester analysts ID hot IT jobs
Research group finds 16 IT roles with a promising future

»  Nvidia claims 10 hours of HD video on Tegra chip
The Tegra 600 and 650 can be used with hard disk drives and are designed partly for mobile Internet devices

»  Database vendors add Google's MapReduce
Greenplum and Aster Data Systems will support Google's programming technique, developed for parallel processing of large data sets across commodity hardware

»  Network management: Tips for managing costs
New technologies, changing requirements, and ongoing equipment maintenance and upgrades cost money, but there are ways to manage expenses

»  EMC targets SMBs, branch offices with new low-end storage
Celerra NX4 highlights include thin provisioning, snapshot technology for data recovery and backups, and Web-based console for management of storage volumes




Solutions to the Toughest IT Challenges in Remote Offices
Though small in size, remote offices face many of the same IT challenges as larger central offices. This Webcast zeroes in on the top line challenges to deliver information that can provide immediate benefits to your business. Sponsor: AMD and Dell

»  Click here to view this Webcast
  Virtualization Solutions Guide
This comprehensive IT Strategy Guide covers Virtualization and puts you at the forefront of the discussion. You'll learn all you need to know from the cost of virtualization, how to implement it for your business, how to back it up safely and which products are best. Sponsored by Riverbed

»  Click here to download now

- Special Advertising Partners -
WHITE PAPERS
 

» Technology White Papers Library

Technology White Papers by Topic

Technology White Papers E-mail Alert

Find out when the latest white paper is available:
 
 
INFOWORLD MARKETPLACE
 
» BUY A LINK NOW
 

FIND PRODUCTS AND COMPANIES
» COMPLETE PRODUCT GUIDE



TECHNOLOGY INDEX
• Applications
• Application Development
• Security
• Networking
• Wireless
• Platforms
• Hardware
• Data Management
• Storage
• Web Services
• Business
• Telecom
• Professional Services
• Standards

TECH WATCH 


What's the 411 on GOOG-411?
Just as Google has become synonymous with "performing a Web search," 411 is understood to mean "information" -- as in "what's the 411?" I was thus surprised to discover, from a billboard, no less, that the king of search is taking on the ...

Apple HTML source reveals 'iPhone Extreme'
"This one's a stretch..." reports AppleInsider. Um, yeah. Reporting on HTML code sightings of product names could be called a stretch, but iPhone Extreme has a ring to it. Now, that sounds like the product Apple should have released first, rather ...

COLUMNISTS

Unified under law
Ephraim Schwartz's Column and Blog (InfoWorld) - In the litigious world we live in, deploying a unified communications platform in your enterprise could...
» MORE COLUMNISTS

MORE INFOWORLD BLOGS


Open Sources 
Product Management
When I joined MySQL four years ago, there was quite a lot of debate about product management. We didn't actually have ...

Zero Day 
Botnet herders tending smaller flocks
New research backs up the theory that botnet operators are keeping their networks smaller in a continued effort to keep ...



• Advice Line
• Database Underground
• The Deep End
• Enterprise Mac
• Geeks in Paradise
• Grid Meter
• The Gripe Line
• InfoWorld Daily
• Inside IT
• IT Troubleshooter
• ITXtreme
• Open Sources
• ProdBlog
• Real World SOA
• Reality Check
• Security Adviser
• SMB IT
• The Storage Network
• Tech Watch
• Virtualization Report
• Zero Day

ADVERTISEMENT


RESOURCE CENTERadvertisement 

GOVERNMENT IT & POLICY
'If you don't go after the network, you're never going to stop these guys. Never.'
From the State Department, All the News for Inquiring Minds
TechPresident, the Internet Citizenry's New Consensus Taker



Sponsored Technology Links

 
 
 HOME  NEWS  BLOGS  PODCASTS  VIDEOS  TECHNOLOGIES  TEST CENTER  EVENTS  CAREERS   About | Advertise | Awards | RSS | Contact Us 

Copyright © 2008, Reprints, Permissions, Licensing, IDG Network, Privacy Policy, Terms of Service.
All Rights reserved. InfoWorld is a leading publisher of technology information and product reviews on topics including viruses,
phishing, worms, firewalls, security, servers, storage, networking, wireless, databases, and web services.

CIO :: ComputerWorld :: CSO :: Demo :: GamePro :: Games.net :: IDG Connect :: IDG World Expo
Industry Standard :: IT World :: JavaWorld :: LinuxWorld :: MacUser :: Macworld :: Network World :: PC World :: Playlist