Oracle Hyperion Planning 11.1.2: Create & Manage Applications Ed 5

Duration : 5 Days (40 Hours)

Oracle Hyperion Planning 11.1.2: Create & Manage Applications Ed 5 Course Overview:

Oracle Hyperion Planning is a robust cloud-based planning, budgeting, and forecasting software that empowers businesses to make data-driven decisions effectively. By streamlining financial planning and analysis, automating manual tasks, and facilitating predictive analysis, it helps organizations reduce costs, manage risks, and drive controlled growth. The Oracle Hyperion Planning 11.1.2: Create & Manage Applications Ed 5 course is specifically designed to equip business analysts, planners, and finance personnel with comprehensive knowledge and skills to leverage the latest features and capabilities of Oracle Planning 11.1.2. Covering a wide range of topics, including planning application creation and administration, user and group management, data form design and maintenance, and dimension and data security, the course also delves into using Calculation Manager to model business rules and optimize performance, working with Smart View for Office, and utilizing the Administration Services Console to manage user access. By the course’s conclusion, learners will be adept at building, managing, and deploying planning applications, enabling them to extract valuable insights from their collected data.

Intended Audience:

  1. Finance Professionals: Individuals in finance roles who want to learn how to create and manage applications using Oracle Hyperion Planning for financial planning and analysis.
  2. Experienced Hyperion Planning Users: Participants already familiar with the Hyperion Planning platform and seeking to upgrade their skills to the latest version.
  3. New Users to Hyperion Planning: Individuals new to the platform and looking to learn how to utilize it to its fullest potential for financial planning and analysis.

Learning Objectives of Oracle Hyperion Planning 11.1.2: Create & Manage Applications Ed 5:

  1. Creating and Managing Applications: Students will learn how to use Oracle Hyperion Planning 11.1.2 to create and manage applications, setting up plan types and defining plans.
  2. Data Loading: Students will be able to load data into their applications, allowing for data input and analysis.
  3. Managing Dimensions and Hierarchies: Participants will learn how to create and manage dimensions, hierarchies, members, and attributes associated with their planning applications.
  4. Calculation and Business Rules: Students will be able to define and maintain calculation scripts and business rules, which are essential for data processing and analysis in their applications.
  5. Data Forms: Learners will understand how to create and manage data forms, which allow for data input and manipulation.
  6. Gathering Insights: Participants will learn how to use Oracle Hyperion Planning 11.1.2 to gather insights and make informed decisions based on the data in their applications.
  7. Freeze Accounting Processes: Students will be knowledgeable about the process of freeze accounting, which is crucial for financial reporting and analysis.
  8. Application Security: Learners will understand how to assign security to their planning applications to control access and maintain data integrity.
  9. Testing and Deployment: At the end of the training, students will be able to test and deploy their applications to ensure they are functional and ready for use.
  • Oracle Hyperion Planning
  • Planning Architecture
  • Planning Business Process
  • Planning Business Scenario
  • Interface: Overview
  • Launching the Simplified Interface
  • Planning Application: Overview
  • Application Framework
  • Planning Dimensions
  • Aggregate Storage Databases
  • Data Block Creation Process
  • Aggregation, Storage, and Calculation Options
  • Application Creation Process
  • Managing Data Sources
  • Creating Simple Applications
  • Creating Advanced Applications
  • Refreshing Essbase Databases
  • Adding Plan Types
  • Building Dimension Hierarchies
  • Performance Settings and Data Type Evaluation Order
  • Accessing Dimensions Information
  • Managing Dimensions in the Simplified Interface
  • Managing Dimensions in EPM Workspace
  • Managing Dimensions in Smart View
  • Creating Aliases
  • Adding Currencies
  • Customizing Time Periods
  • Scenarios and Versions
  • Creating Scenarios
  • Creating Versions
  • Metadata Load Options
  • Creating Metadata Load Files
  • Exporting Metadata
  • Importing Metadata
  • DRM Metadata Load Process
  • Application Management
  • Creating Member Formulas
  • User-Defined Dimensions
  • Attribute Dimensions
  • Adding User-Defined Attributes
  • Smart Lists: Overview
  • Enabling the Simplified Interface
  • Customizing Interface Appearance
  • Currencies and Exchange Rates
  • Creating Exchange Rate Tables
  • Currency Conversion Calculation Scripts
  • Data Load Options
  • Managing Planning Data
  • Exporting Data
  • Importing Data
  • FDMEE Data Load Process
  • Data Calculations
  • Planning Security: Overview
  • User and Group Provisioning in Shared Services
  • Specifying Advanced Settings
  • Assigning Access Permissions
  • Forms: Overview
  • Form Components
  • Creating Simple Forms
  • Creating Composite Forms
  • Exporting and Importing Forms
  • Creating Complex Forms
  • Specifying Application Settings
  • Specifying User Variables
  • Setting Individual Display Options
  • Creating Menus
  • Creating Formula Rows and Columns
  • Building Validation Rules
  • Navigating Forms
  • Submitting Data in Forms
  • Filtering Data
  • Sorting Data
  • Spreading Data
  • Adjusting Plan Data
  • Adding Annotations to Plan Data
  • Clearing Cell Details
  • Working with Ad Hoc Grids
  • Business Rules: Overview
  • Determining Calculation Requirements
  • Launching Calculation Manager and Rule Components
  • Managing Views
  • Validating and Deploying Rules
  • Creating Business Rules and Rule Sets
  • Assigning Business Rule Security
  • Launching Business Rules
  • Approvals Dashboard
  • Planning Unit Approval States
  • Reviewer Actions
  • Impact of Entity Hierarchy on the Review Process
  • Managing the Review Cycle
  • Viewing and Resolving Validation Errors
  • Copying Data Between Versions
  • Copying Data
  • Task Lists: Overview
  • Navigating Task Lists
  • Task List Creation Process

Oracle Hyperion Planning 11.1.2: Create & Manage Applications Ed 5 Course Prerequisites:

While there are no formal prerequisites listed for the course, participants in the Oracle Hyperion Planning 11.1.2: Create & Manage Applications Ed 4 training are expected to have certain foundational knowledge and experience to make the most of the training. These include:

  1. Basic Understanding of Financial Analysis and Accounting Principles: Having a basic understanding of financial analysis and accounting principles will help participants grasp the financial planning concepts covered in the course.
  2. Business Knowledge: Participants are expected to have some business knowledge, as financial planning involves making informed decisions to achieve organizational goals.
  3. Clear Understanding of Financial Planning Processes: Familiarity with financial planning processes will be beneficial for participants as they learn how to create and manage applications using Oracle Hyperion Planning 11.1.2.
  4. Basic Knowledge of Hyperion Planning Essbase: Having basic knowledge of Hyperion Planning Essbase, a multidimensional database technology, will aid participants in comprehending the key features and functionalities of Oracle Hyperion Planning 11.1.2.

Discover the perfect fit for your learning journey

Choose Learning Modality

Live Online

  • Convenience
  • Cost-effective
  • Self-paced learning
  • Scalability


  • Interaction and collaboration
  • Networking opportunities
  • Real-time feedback
  • Personal attention


  • Familiar environment
  • Confidentiality
  • Team building
  • Immediate application

Training Exclusives

This course comes with following benefits:

  • Practice Labs.
  • Get Trained by Certified Trainers.
  • Access to the recordings of your class sessions for 90 days.
  • Digital courseware
  • Experience 24*7 learner support.

Got more questions? We’re all ears and ready to assist!

Request More Details

Please enable JavaScript in your browser to complete this form.

Subscribe to our Newsletter

Please enable JavaScript in your browser to complete this form.