Hyperion Essbase - Ravi Kurakula
Download as PPTX, PDF1 like601 views
Hyperion Essbase is a multidimensional database management system (MDBMS) that provides a multidimensional database platform for building analytic applications. It is optimized for processing human queries rather than transactions. The typical lifecycle of an Essbase database involves creating the database, building dimensions, loading data, performing calculations, and generating reports. Essbase uses a multidimensional data model with dimensions, members, and hierarchies to allow for multidimensional viewing and analysis of data.
Hyperion Essbase - Ravi Kurakula
- 1. Hyperion Essbase Created by : Ravi Kurakula
- 5. Essbase is a multidimensional database management system (MDBMS) that provides a multidimensional database platform upon which to build analytic applications. ... In contrast to "on-line transaction processing" (OLTP), OLAP defines a database technology optimized for processing human queries rather than transactions.
- 6. Life Cycle Of Essbase 1. Creating the Database 2. Dimensional Building 3. Data Loading 4. Performing the Calculations 5. Generating the Reports
- 7. Essbase Multi Dimensional Data Modeling
- 8. Multidimensional Viewing and Analysis
- 9. ? A Essbase - Block storage Essbase (BSO) - Database (cube) contains two types of values : ? the values that you enter or load (input data) ? and the values that are calculated from the input data (calculated data) ? Then a typical Essbase - Database (cube) conforms to the following process : ? Creation of the Essbase - Outline (Database Outline) (Essbase - Dimension, Essbase - Members, Essbase - Hierarchies) ? Input data is loaded to the lowest levels in Essbase - Hierarchies ? Essbase - Calculations consolidate input data in the upper levels of Essbase - Hierarchies
- 12. ? Hyperion Essbase is an Online Analytical Processing (OLAP) server that : ? extracts data from a wide range of datasources, including : ? Oracle Database 11g and other relational databases, ? files, ? and spreadsheets, ? calculates and then aggregates this ? and then provides fast access to the results, using a dimensional model through several APIs and languages, including XML/A and MDX. Users interact and intuitively explore data in real time and along familiar business dimensions, enabling them to perform speed-of-thought analytics.
- 13. ? For users with complex analytical requirements, Oracle’s Hyperion Essbase, can provide access to : ? advanced calculations, ? forecasts, ? allocations, ? cross-dimensional queries, ? and aggregated data. ? Essbase was created to provide : ? one system that satisfy the global reporting and give accuracy ? multidimensional spreadsheet-based analysis.
- 14. ?Oracle Hyperion Essbase is : ? server technology ? an environment for rapid development of custom analytic and enterppart of the Oracle Fusion Middleware family of products. ? a business analysis rise performance management applications.
- 15. ? A dimension represents the highest consolidation level in the database outline. The database outline presents dimensions and members in a tree structure to indicate a hierarchy relationship. ? For example, below, Hierarchical Structure: ? Year, Accounts, Scenario, Product are a dimension ? Qtr1 is a member of the Dimension Year (of type Time)
- 17. ? Oracle Hyperion Smart View for Office, Fusion Edition provides a common Microsoft Office interface for various EPM System products: ? Oracle Hyperion - Essbase, ? Oracle Hyperion Financial Management, Fusion Edition, ? Oracle Hyperion planning, Fusion Edition, ? Oracle Enterprise Performance Management Workspace, Fusion Edition data. and Reporting and Analysis. ? Using Smart View, you can view, import, manipulate, distribute, and share data in Microsoft Excel, Word, and PowerPoint interfaces. ? It can also import content from the Reporting and Analysis repository and can perform adhoc analysis on data from Oracle BI EE.