Oracle DRM Blog

15 Feb, 2008

The Missing Link in BI

Posted by: Daniel In: Business Intelligence|Data Governance

Business Intelligence systems are designed to help organizations understand their operations, customers, financial situation, product performance, trends and a host of key business measurements. Good BI system allows quality decisions to be made. Similar, bad decisions can be resulted from poor decision making. Over the last decade, I see alot of effort being spent on tools. We’ve seen the rise of portals, web analytics, widgets, BPM, EPM you name it. In fact, how many millions of dollars have companies spent with the promise of report automation and hundred of hours saved from replacing manual Excel reporting? When I go to different companies, what I see are more manual reporting, not less. I see multi-billion dollar companies still don’t have their dream BI system. How’s this possible? The answer is simple.

They lacked Data Governance. It’s difficult, what is Data Governance? In the next few weeks or months, I will get into more about Data Governance. At high level, how do we know the reporting we do will be blessed throughout the organization from top to bottom? Isn’t it almost a trend that many BI projects are done in silo and the reporting that they do are obsolete the moment it’s developed? When organizations don’t have Data Governance in place, employees have free-rein on developing reports based on their own version of truth. Nothing is certified or certifiable.

Here’s an example: the Media BU finance team produces a European P&L is different to the European HQ producing their Media business P&L, and this is different to Corporate Finance producing the Europe Media P&L. The three organization namely BU Finance, Region Finance and Corporate Finance are silo organizations that have the function to engage in management reporting. However, without a “Playbook” called Data Governance, they’ll likely be developing reports using business definitions, business rules, timeline that are different to one another. Think of how many years the SEC and the AICPA have been developing reporting standards to govern how transactions should be booked or reported. Yet within the realm of management reporting, there’re no rules.

This is the main reason why companies will never yield the expected benefits from their large spent on BI.

Visitors who read this post, also read:



No Responses to "The Missing Link in BI"

Comment Form


  • Daniel: Naren, depending on the system version you are using, before v11 you are likely to use HAL to integrate DRM into HFM. In v11 you use ODI.
  • Daniel: Kalyan, yes DRM can manage any hierarchy beyond Oracle because it does not have pre-build interfaces. It exports to database or text format that can w
  • Kalyan: Hi Daniel, I am looking for some info on DRM.Can you please help. 1. Can DRM manage the hierarchies of non-Oracle products. (For example, does i

About This Blog

My name is Daniel Poon. I am a multi-disciplined business intelligence professional with a strong dynamic career leading Financial Processes, People, BI Systems and Global Projects to accomplishments. Known for passion in implementing process excellence, quality BI solutions and creative innovations. Thanks for visiting my special interest blog.

 Subscribe This Blog For Free Now

Disclaimer: The words, ideas and opinions here are my own. Please don't assume they represent the opinion of my employer, any other person or organization. Do read the Terms of Use. If you would like to quote me, please ask me first or provide a link back.