Hyperion /
Planning

Planning

PLANNING Online Training

What is PLANNING

Web based Budgeting & Forecasting tool that utilizes Essbase as the data storage and calculation engine. By leveraging Essbase’s multidimensional data model as well as standard relational database management platforms, Oracle Hyperion Planning provides a powerful tool for forecasts, budgeting, reporting, and analysis. The Essbase portion of the application gives Hyperion Planning the calculation power to handle predictive planning, allocations and complicated revenue recognition planning. The relational repository allows Planning to collect textual information critical to a coordinated understanding of the budget. Hyperion Planning contains process flow management and process guidance for end users. While Hyperion Planning is a web software application, it also has an add-in with Microsoft Office (called Smartview) which allows users to forecast or budget in Microsoft Excel, an environment comfortable to

Who is Eligible:

Any Graduates/Post Graduates are eligible.
Anyone having knowledge in Data Warehousing technologies.
Any technical background consultants are eligible to learn Hyperion Planning Online Training.

  • 1

    Introduction to Hyperion Planning

    20:56
  • 2

    Hyperion Planning Architecture

    20:56
  • 3

    Hyperion Essbase Versions/li>

    20:56
  • 4

    Hyperion Essbase Clients

    20:56
  • 6

    Planning Web Client

    20:56
  • 1

    Pre-requisites for Planning App Creation

    20:56
  • 2

    Oracle Schema Creation

    20:56
  • 3

    Data Source Creation

    20:56
  • 4

    Planning Application Settings

    20:56
  • 1

    Data/Meta Data Explanation

    20:56
  • 2

    What is Essbase Outline?

    20:56
  • 1

    Default Planning Dimensions

    20:56
  • 2

    Custom Dimensions

    20:56
  • 1

    Consolidation Properties

    20:56
  • 2

    Data Storage Properties

    20:56
  • 1

    Adding Dimensions

    20:56
  • 3

    Defining Attribute Dimensions

    20:56
  • 1

    Planning Metadata Load Process

    20:56
  • 2

    Loading Metadata for Attribute Dimensions

    20:56
  • 3

    Automation Process of Planning Metadata Load

    20:56
  • 1

    Simple Planning WebForms

    20:56
  • 2

    Complex Planning WebForms

    20:56
  • 3

    FormDef Utility Usage

    20:56
  • 1

    SmartList Creation

    20:56
  • 2

    Requirement of SmartList

    20:56
  • 3

    ormDef Utility Usage

    20:56
  • 1

    Business Rules Creation

    20:56
  • 2

    Runtime Prompts

    20:56
  • 3

    Adding Business Rules to WebForms

    20:56
  • 1

    Task List Creation

    20:56
  • 2

    Requirement of SmartList

    20:56
  • 2

    Process Management

    20:56
  • 1

    Plan Values submission using WebForms

    20:56
  • 2

    Data loading using Flat Files

    20:56
  • 3

    Data loading using SQL

    20:56
  • 4

    Free Form Loading

    20:56
  • 1

    Hierarchical Calculation

    20:56
  • 3

    Business Rules/Calc Mgr Rules/Calc Scripts

    20:56
  • 4

    Free Form Loading

    20:56
  • 1

    Shared or Common Connection

    20:56
  • 2

    Independent Connection

    20:56
  • 3

    Smart View Usage

    20:56
  • 1

    Introduction to Shared Services

    20:56
  • 2

    Groups Creation

    20:56
  • 4

    Requirement of Groups

    20:56
  • 5

    Provisioning Groups

    20:56
  • 6

    Dimensional Security

    20:56
  • 7

    Business Rules Security

    20:56
  • 8

    WebForms Security

    20:56
  • 9

    TaskList Security

    20:56
  • 10

    Security Provision Reports

    20:56
  • 1

    Migration of App from DEV to QA/PROD

    20:56
  • 2

    Manual Migration Process

    20:56
  • 3

    LCM Migration Process

    20:56
  • 4

    Oracle Schema Migration Process

    20:56
  • 2

    Oracle Schema Backup

    20:56
  • 4

    Planning Artefacts Backup

    20:56
N/A