Lets get some basic idea about Hyperion first....
What is Hyperion.?
Hyperion is a Business Intelligence (BI) and Business Performance Management (BPM ) Tool.. It has applications for Planning, consolidation, scorecarding, reporting, dashboards, Analysis, Workspace, Master Data Management and Foundation
Business intelligence (BI) mainly refers to computer-based techniques used in identifying, extracting and analysing business data, such as sales revenue by products and/or departments, or by associated costs and incomes
Business process management (BPM) is a management approach focused on aligning all aspects of an organization with the wants and needs of clients. It promotes business effectiveness and efficiency while striving for innovation, flexibility, and integration with technology
It makes a use of ESSBASE as its back end. We will see in depth about what is ESSBase and how does it differ from traditional Database.
What is ESSBASE and how does it work.?
ESSBase i.e. (Extended Spread Sheet DataBASE) is a multidimensional database management system (MDBMS) that provides a multidimensional database platform upon which to build analytic applications i.e. in ESSBase we make use of OLAP (Online Analytical Processing) .
As the name suggests it Enhances the features of the Excel Spread Sheet .
MDBMS (Multi Data Base Management System ) is a feature by which we can view the data in different dimensions i.e. we can view the data in 3D or 4D depending on the customer/client needs.
ESSBASE makes the most use of OLAP i.e. OnLine Analytical Processing.
OLAP (online analytical processing) is computer processing that enables a user to easily and selectively extract and view data from different points of view. For example, a user can request that data be analyzed to display a spreadsheet showing all of a company's beach ball products sold in Florida in the month of July, compare revenue figures with those for the same products in September, and then see a comparison of other product sales in Florida in the same time period. To facilitate this kind of analysis, OLAP data is stored in a multidimensional database.
For more Details on OLAP refer: http://en.wikipedia.org/wiki/Online_analytical_processing
Data Warehouse a collection of data designed to support management decision making. Data warehouses contain a wide variety of data that present a coherent picture of business conditions at a single point in time.
Development of a data warehouse includes development of systems to extract data from operating systems plus installation of a warehousedatabase system that provides managers flexible access to the data.
