Hyperion is a Business Intelligence [BI] and Business Performance Management [BPM] tool for Operational and Strategic Planning. Hyperion ESSbase is a multidimensional database management system build analytic applications. Extended spreadsheet database support two storage options will sparsely to minimize the amount of physical memory and disk space. The database hides the implementation from front-end tools and the full hypercube can be navigated naturally and it is possible to load values into any cell interactively. Calculation engine of ESSbase can specify calculations as the aggregation of values through dimensional hierarchies and dynamically calculated dimension members.
A key strength of Oracle ESS base lies in its ability to allow users to “write back” to an application’s data repository under security. All these would be covered in Hyperion training sessions. – See more at: http://mindmajix.com/oracle-hyperion-online-training#sthash.jHHaDzmV.dpuf