Hyperion
is a Business Intelligence [BI] and Business Performance Management [BPM] tool
for Operational and Strategic Planning. Hyperion ESS base 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 ESS
base 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.
Oracle
Hyperion Essbase Online Training designed
course explaining step-by-step instructions on how to perform a variety of tasks,
narrated presentations accompanied by task-oriented demonstration of specific
concept features. In this course students learn the understanding of block
storage capabilities such as Hybrid Aggregation Mode in Block Storage Database,
how to maintain and optimize ESS base database, administration services and
also Learn the techniques required to create reports and perform ad hoc
analysis using the Essbase Spreadsheet for budgeting, forecasting and reporting
with course materials by IT professional trainer of 10+years experience.
Course
Curriculum
Unit 1:
Data Warehousing Concepts
Topics- Introduction
of Data-Warehousing Concepts, Schema Models, OLAP Models and brief explanation
on ROLAP and MOLAP, Identification of Dimensions and Facts and create the Model
to build cubes based on Real-Scenarios, Introduction to Hyperion Tools and Advantages,
Essbase Architecture and Flow of Development Life Cycle of Essbase Cubes,
Essbase Installation and Configuration Procedure
Unit
2: Essbase Storage Properties
Topics- Essbase
Terminology and Family Tree Relationships, Introduction of Database Design, Data
Storage Properties, Time Balance and Expense Reporting Properties, UDAS,
Attribute and Alternate Hierarchies, Introduction to ASO and BSO Options,
Creating Essbase Applications and Databases, Understanding the Time, Scenario
and Measures Dimension Concepts, Creating and building the dimensions rule
files using Essbase Administration Services Console, Loading the data in
Different Methods, Consolidation Operators, Duplicate Member Name Support
Unit
3: Essbase Cube Implementation from Scratch
Topics- Creating
Standard and Attribute Hierarchies, Creating Accounts Hierarchies, ETL
Operations while Rule File Building, Dimensional and Data Loading using
Interface tables and Flat Files
Unit
4: BSO Cube Implementation
Topics- Dense
and Sparse Concept, Block Structure, Data Storage Properties, Calculation
Scripts Hour-Glass Method Importance, Design and Optimization Technique,
Partitions and there types
Unit
5: ASO Cube Implementation
Topics- Aggregations,
ASO Physical Structure, Table space and Restructuring, MDX Scripts, Design and
Optimization
Unit
6: Scripts Topics- Automation of Cube Loading using MaxL
Scripts, Report Scripts
Unit
7: Security and Administration
Topics- Introduction
to Shared Services Console, Creating Users and Groups, Assign Cube and Filter
Access to Groups, Essbase Config, Server and Application Log Files, Locks and
Sessions, Backup and Recovery Methods, Introduction to Life Cycle Management
and Usage
Unit
8: Introduction to Excel-Addin and Smart View
Topics- Accessing
Cubes using Essbase Excel-Addin and generate Reports, Performing Adhoc Analysis
using Smart View Tool, Various Options that is available in Essbase Excel-Addin
and Smart-View Tools
To Learn
More Click On Below Link:
No comments:
Post a Comment