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!

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.

obiee.jpg

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+.

obise1.JPG

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 |

1 Comment

Hi, thanks for the interesting post !
Just though that as an alternative to the Oracle BI Excel addin. People can use the SQL Drill Excel addin. It is a freeware addin for excel. You can read more about it here http://www.sqldrill.com

Leave a comment

    
   VISIT MY EXPERT CHANNEL

Search this blog
Categories ›
Archives ›
Recent Entries ›