Oracle Hyperion Planning is a centralized, Microsoft Office and Web-based planning, budgeting and forecasting solution. Browse through the contents of the program.
| Oracle Hyperion Course Contents |
| 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 |
| 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 |
| Creating Standard and Attribute Hierarchies |
| Creating Accounts Hierarchies |
| ETL Operations while Rule File Building |
| Dimensional and Data Loading using Interface tables and Flat Files |
| Dense and Sparse Concept, Block Structure |
| Data Storage Properties |
| Calculation Scripts |
| Hour-Glass Method Importance |
| Design and Optimization Technique |
| Partitions and there types |
| Aggregations |
| ASO Physical Structure |
| Table space and Restructuring |
| MDX Scripts |
| Design and Optimization |
| Automation of Cube Loading using MaxL Scripts |
| Report Scripts |
| 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 |
| 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 |
Techflames is an online training hub where we provide experienced tutors on any technology. We serve all the major time zones be it USA, UK, Canada, Australia, New Zealand, India, Saudi, Dubai..
