Oracle/Hyperion Essbase Library

Essbase Interview Questions

Essbase version 11 guide
Essbase Errors
Essbase data loading

SQl-EAS: http://oraclebizint.wordpress.com/2008/06/02/hyperion-essbase-931-loading-valued-based-hierarchies-parent-child-using-admin-services-and-rules-files/

EIS-EAS: http://oraclebizint.wordpress.com/2007/07/21/creating-a-hyperion-essbaseanalytic-server-cube/

Scripts: http://essbaseinfo.com/Examples.aspx

Rule files Information: http://gerardnico.com/wiki/epm/essbase/dimension_build_rules_files

Data load Optimization: http://www.datawarehousingsupport.com/2008/11/optimization-in-hyperion-essbase.html

How to LEARN???

• From where do I download the software?

http://www.oracle.com/technetwork/middleware/essbase/downloads/index.html

• How much does it cost?

$ZERO, Yes, it’s a free download. Thanks to Oracle!

• Where can I get installation guidance?

http://download.oracle.com/docs/cd/E12032_01/doc/nav/portal_1.htm

• Where can I find stuff to read and implement?

Essbase Library: http://download.oracle.com/docs/cd/E12032_01/doc/nav/portal_3.htm

Oracle /Hyperion = Essbase, OBIEE, Brio ??????

For many non- IT people “Hyperion” is a novel written by American writer Dan Simmons. It’s a science fiction novel, if you get chance read it. But, many non-hyperion people with IT background have a misconception that Hyperion is a tool and it is developed by oracle. People who have read my first blog would know the history of Hyperion. And in my blog I just want to write ONLY about Essbase (a product of Hyperion, now it is of Oracle). But, in this blog post I’m going to write about Hyperion products after Oracle acquisition.
In 2007, soon after the acquisition Oracle Corporation had bundled Hyperion BI tools into Oracle Business Intelligence Enterprise Edition Plus. This integrated suite included all of the Oracle and Hyperion reporting and analysis tools. Later in 2008, all Hyperion products came under one umbrella “Oracle Enterprise Performance Management and Business Intelligence”. ESSBASE is one of the Oracle Business Intelligence tool, like OBIEE etc. Hyperion Financial Management (HFM), Hyperion Planning are Oracle performance management tools.

You can check Oracle website for more in detail information about these tools listed below.


I. ORACLE BUSINESS INTELLIGENCE
• Oracle Business Intelligence Tools & Technology
• Oracle Business Intelligence Applications
• Oracle Essbase
• Oracle Real-Time Decisions

II. ORACLE PERFORMANCE MANAGEMENT APPLICATIONS
• Strategy Management
• Financial Close and Reporting
• Planning, Budgeting and Forecasting
• Profitability and Cost Management

ORACLE BUSINESS INTELLIGENCE:

A.Oracle Business Intelligence Tools & Technology:
1. Oracle Business Intelligence, Enterprise Edition (OBIEE)
2. Oracle Business Intelligence Standard Edition One
3. Oracle Business Intelligence Publisher
4. Oracle Essbase
5. Oracle Real-Time Decisions

B.Oracle Business Intelligence Applications:

1. CRM Analytics
2. ERP Analytics

ORACLE PERFORMANCE MANAGEMENT APPLICATIONS:

A.STRATEGY MANAGEMENT
1. Oracle Hyperion Performance Scorecard
2. Oracle Hyperion Strategic Finance

B. FINANCIAL CLOSE & REPORTING:
1. Oracle Hyperion Financial Management
2. Oracle Hyperion Financial Close Management
3. Oracle Hyperion Disclosure Management
4. Oracle Essbase Analytics Link for Hyperion Financial Management
5. Oracle Hyperion Financial Data Quality Management

C.PLANNING, BUDGETING & FORECASTING:
1. Oracle Hyperion Planning
2. Oracle Hyperion Workforce Planning
3. Oracle Hyperion Capital Asset Planning
4. Oracle Integrated Operational Planning
5. Oracle Integrated Margin Planning
6. Oracle Hyperion Public Sector Planning and Budgeting

D.PROFITABILITY MANAGEMENT:
1. Oracle Hyperion Profitability and Cost Management


The previous offerings from Hyperion acquired new names as given below:
Hyperion's previous offerings - Hyperion System 9 BI+ offerings
Hyperion Essbase ASO - Enterprise Analytics
Hyperion Essbase BSO - Essbase Analytics
Hyperion Analyzer - Web Analysis
Hyperion Reports - Financial Reporting
Hyperion Intelligence - Interactive Reporting
Hyperion SQR - Production Reporting
Hyperion Metrics Builder - Enterprise Metrics

Web Analysis, Financial Reporting, Interactive Reporting, Production Reporting all are Hyperion Reporting tools which are used by many companies for their reporting/data validation needs.
I hope this clears all confusion about Hyperion and Oracle products. If you have more information to add or something to correct, Please post it in the comment box.

About Hyperion

First things first. Before knowing about the Hyperion Essbase lets know its history. "Hyperion" is a company founded by Robert Thomson in 1981. Thomson, a native of Scotland, had worked for Citicorp in London before coming to the U.S. Thomson realized that if he could develop a software product that would make it possible for a number of users to access financial data via their personal computers rather than a mainframe, companies would pay to access this type of technology. 
Over the years, Hyperion has built a number of product and service lines, among which are Hyperion Enterprise, Hyperion Pillar, and Hyperion OLAP. Hyperion Enterprise is an application for consolidating business information and reports, bringing together numerous ledgers into a single unified whole. Development began in mid-1988, and the product debuted in July 1991. In the three years leading up to 1997, when Hyperion released its fifth edition of Hyperion Enterprise, the product accounted for some 60 percent of the company's worldwide revenues.
In 1998, Hyperion Software merged with Arbor Software Corporation, which developed and marketed Essbase OLAP server. Essbase, whose name derives from "Extended Spread Sheet dataBASE. The merge was called the "combination of the leading OLAP technology company with the leading OLAP applications company." The combined company adopted the name Hyperion Solutions Corporation.

Later in 2002 - Hyperion launched the Business Performance Management softwares.  Today in the market there are many  Business Intellegence Applications that delivers a full range of analytic and reporting capabilities. Hyperion renamed many of its products in 2005, giving Essbase an official name of Hyperion System 9 BI+ Analytic Services. Oracle Corporation acquired Hyperion Solutions Corporation in 2007, as of 2009 it markets Essbase as "Oracle Essbase."

Recent Hyperion Essbase release history is as follows:

Version 9.0 - Sep 2005 (Hypeiron System 9 BI+)

Version 9.0.1 - Dec 2005

Version 9.2 - Jun 2006

Version 9.3 - Jan 2007

Version 9.3.1 - Nov 2007

Version 11.1.1.1 - Sep 2008

Version 11.1.1.2 - Mar 2009

Version 11.1.1.3 - Aug 2009 (Essbase Crystal Ball integration, Smartview Metadata, HVE Maps)

With the release of System 9, Hyperion provided a new user interface add-in for Essbase called "SmartView for Microsoft Office". SmartView provides access to Essbase and other System 9 content for Microsoft Powerpoint, Microsoft Word, Microsoft Outlook as well as supplanting the previous add-in for Microsoft Excel.


So, guys that was a brief history about ESSBASE......keeping checking my blogs for more information.

“Knowledge is of no value unless you put it into practice.”