One reason is that “OLAP” is an acronym for four words that are remarkably devoid of meaning: On-Line Analytical Processing. OLAP databases are more easily understood when they’re compared with relational databases. But before I explain why this is so, I should explain what OLAP is, and how it can be Excel-friendly. Although OLAP technology has been available for years, it’s still quite obscure. Particularly when Excel can be enhanced by an Excel-friendly OLAP database.That technology eliminates the classic objections to using Excel for business performance management.Įxcel-friendly OLAP products cure many of the problems that both users and IT managers have with Excel. But before your company takes that leap of faith, perhaps you should take another look at Excel. For these reasons, and many more, a growing number of companies of all sizes have concluded that it’s time to replace Excel. Excel consolidation occupies a large corner of Spreadsheet Hell. They can’t be used by many different users. Managers need information more quickly now they can’t wait for another Excel report. Excel spreadsheets don’t scale well.
Companies are larger and more complex now than in the past they are too complex for Excel. Name IT’s top ten requirements for a successful BPM system, and they’ll quickly explain how Excel violates dozens of them. Should Excel be a key component of your company’s Business Performance Management (BPM) system? There’s no doubt how most IT managers would answer this question.
0 kommentar(er)
