We use cookies and other similar technologies (Cookies) to enhance your experience and to provide you with relevant content and ads. By using our website, you are agreeing to the use of Cookies. You can change your settings at any time. Cookie Policy.

Blog: William McKnight Subscribe to this blog's RSS feed!

William McKnight

Hello and welcome to my blog!

I will periodically be sharing my thoughts and observations on information management here in the blog. I am passionate about the effective creation, management and distribution of information for the benefit of company goals, and I'm thrilled to be a part of my clients' growth plans and connect what the industry provides to those goals. I have played many roles, but the perspective I come from is benefit to the end client. I hope the entries can be of some modest benefit to that goal. Please share your thoughts and input to the topics.

About the author >

William is the president of McKnight Consulting Group, a firm focused on delivering business value and solving business challenges utilizing proven, streamlined approaches in data warehousing, master data management and business intelligence, all with a focus on data quality and scalable architectures. William functions as strategist, information architect and program manager for complex, high-volume, full life-cycle implementations worldwide. William is a Southwest Entrepreneur of the Year finalist, a frequent best-practices judge, has authored hundreds of articles and white papers, and given hundreds of international keynotes and public seminars. His team's implementations from both IT and consultant positions have won Best Practices awards. He is a former IT Vice President of a Fortune company, a former software engineer, and holds an MBA. William is author of the book 90 Days to Success in Consulting. Contact William at wmcknight@mcknightcg.com.

Editor's Note: More articles and resources are available in William's BeyeNETWORK Expert Channel. Be sure to visit today!

March 2009 Archives

We're excited to announce that I'll be on the Exhibit floor at Enterprise Data World in Tampa April 5-9th. I will be part of the Consultant's Corridor.

Enterprise Data World (formerly known as the DAMA International Symposium & Wilshire Meta Data Conference) is the most comprehensive data & information management conference. It features 150 expert-led sessions and case studies covering the entire range of data and information management topics. Visit the conference website to learn more.

Come see me at the exhibits, or sign up for a 1-on-1 "Ask an Expert" appointment. I'll have appointment hours


Tuesday, April 7 4:30 pm to 8:00 pm


To claim an appointment, look for the sign-up sheet in the conference registration office.

Technorati tags: data warehouse, Business Intelligence, enterprise data world

Posted March 24, 2009 10:59 AM
Permalink | No Comments |

Oracle provides so many options in business intelligence (BI) today that the dilemma sometimes becomes sorting through the tools, the packages and the respective product directions. They are decidedly moving (moved?) into a 'packaged' BI direction. The theory is that nobody builds an ERP system anymore, nor should they build a BI system and that Oracle BI Applications provide faster time to value, lower TCO and assured business value. My teams have been implementing the Oracle BI Applications.

With Informatica built-in (to be switched to Oracle Data Integrator, the former Sunopsis, in the next few years), most any source can be brought in to the applications. However, principally Oracle E-Business Suite (EBS) and Peoplesoft will source the Financials, Human Resources, Supply Chain & Order Management and Procurement & Spend applications and Siebel sources the Sales, Service and Marketing applications. All work off a common enterprise model (the Business Analytics Warehouse), consisting of dozens of star schemas, premapped metadata, prebuilt ETL and a library of prebuilt metrics, dashboards, reports and alerts. Each application populates a subset of the entire warehouse and uses a subset of the other assets (i.e., the Financials Application populates 16 star schemas.) It's actually a well-done schema, with conformed dimensions, standard naming and depth to the dimensions. It makes a lot of sense if you have the Oracle sources in your operational environment.

However, very real decisions often need to made between using the Oracle BI Applications and OBIEE+. This decision is ongoing in nature, often continuing after the "OBI Apps" installation. OBIEE+ is the flagship product - actually suite of products - of Oracle BI, from a tools perspective. OBIEE+, of course, is the tool with the OBI Apps. OBIEE+ consists of OBIEE, which is the former Siebel Analytics (which originally came from nQuire). This is the Oracle's primary BI tool. When Oracle bought Siebel, it was primarily for the CRM tools, but the BI tool has turned out to be a major asset as well. OBIEE+ is OBIEE and BI Publisher, Interactive Reporting, SQR Production Reporting, Financial Reporting and Web Analysis. If you're new to Oracle BI, I realize all of these could use some elaboration.


These are all Oracle BI assets, as is OBISE1. The old Discoverer is called OBISE and OBISE1 has nothing to do with OBISE, it's a 5-50 user license of OBIEE+.


Enterprise Performance Management (EPM) is the other mantra and it refers to the former Hyperion analytic applications with cube architectures. There's 9 Hyperion applications available, outside the scope of the OBI Apps. These are mostly financial in nature and it's the framework for building the custom cubes that you get with the Hyperion applications.

Furthermore, until (and after) BI and EPM merge at Oracle, many requirements can be met with either  Essbase or OBIEE+.  Essbase is the former Hyperion product which spins up cubes for fast performance within a selective set of data. SmartView, an Excel add-in, is the main front end, but OBIEE can also be a front end to Essbase.

 Technorati tags: data warehouse, Business IntelligenceOracle, OBIEE, OBIEE+, enterprise performance management, hyperion, obise1

Posted March 16, 2009 9:41 AM
Permalink | 1 Comment |


Search this blog
Categories ›
Archives ›
Recent Entries ›