123OLAP

  • About Us
    • What Our Clients Say
    • Our Team
  • Our Services
    • On Demand Self Paced Training for Admins
    • On Demand Self-Paced Training for End Users
    • Instructor Led Private Training
    • Instructor Led Public Training
  • Rates
  • Courses
    • Cloud Analytics
      • Amazon Web Services (AWS)
      • Google Cloud Platform (GCP)
    • Data Management FDMEE for Cloud
    • DRM
    • Essbase
    • EPBCS
    • FCCS
    • FDMEE Courses
      • FDMEE
      • FDMEE for Cloud
      • Jython Scripting for FDMEE
    • Financial Reporting Web Studio
    • HFM
    • HPCM
    • Hyperion Planning
    • PBCS
    • Smart View
    • Tableau
  • Contact
  • Payment
You are here: Home / HPCM Management Ledger (3 days)

HPCM Management Ledger (3 days)

Audience

Financial and Technical System Administrators, Financial Modellers and Financial Power Users

Pre-requisites

An understanding of Essbase databases (particularly aggregate storage models) is useful, as is a working knowledge of Smart View.

Learning objectives

Learn the concepts required to design and create HPCM Management Ledger applications to identify and exploit profitability through the development of complex what-if scenarios and reporting.

Find out how to model structures, design calculation rule sets, deploy applications to the HPCM and Essbase Servers and use Management Ledger tools and Smart View to analyse and report on data.

Course description

The course focuses on the design, build, system administration and deployment of HPCM Managment Ledger applications. You’ll discover the tasks involved in preparing the structure and dimensionality of the allocation model, together with the strategies for the creation and deployment of applications using EPMA, master Essbase cubes, flat files and templates.

Learn about the calculation rules and the rule sets required to effectively and efficiently model data within HPCM. Discover how to execute the model and explore the use of manifold tools to view and analyse allocated data.This hands-on course provides everything you’ll need to design, build and maintain HPCM Management Ledger models and applications.

Day summary

Day 1:

Reviewing the models, dimensions and the creation and deployment of applications.

Day 2:

POV creation, deployment to Essbase, Rules and Rule Sets, Rule Balancing, Data Load, Model Views.

Day 3:

Custom Calculations, Trace Allocations, System Reports, application creation options, Security, Lifecycle Management.

Detailed Agenda:

HPCM Overview
• Architecture
• POV
• Rules and Rule Sets
• Database Management
• Model execution
• Reviewing the data and Model Validation

Supporting Essbase Databases
• The HPCM Essbase Database (ASO)

EPMA Overview
• The Dimension Library
• The Application Library
• EPMA Background information
• EPMA Profitability properties
• Dimension Sort Order

Application Creation
• POV, Business and Attribute Dimensions
• The Balance Dimension
• The Rule Dimension
• Deploying the application
• Master Essbase Cubes
• Creating applications from Text Files/Templates

Model Build
• The Model Summary
• Defining the Point of View
• Creating Rules and Rule Sets
• Rule Set Calculation Options
• Deploying to Essbase
• Managing Queries
• Entering Data
• Data Load Facility

Model Execution and Validation
• Calculating Rule Sets
• Rule Balancing
• Trace Allocations
• Model Views
• Model Validation

Reporting
• Managing Queries
• System Reports
• Smart View with HPCM
• Understanding HPCM
• Financial Reports

Security
• Security Overview
• HPCM Security Roles
• Security Provisioning

Application Portability
• Lifecycle Management
• Extracting the EPMA components
• Extracting the Application components
• Importing applications from LCM extracts
• Deploying the imported application

olap-logoLogo

 

This course is offered through our strategic partnership with Keyteach, using state-of-the-art technology and a live environment for hands-on labs. Contact us for information, or click here to register.

Instructor-Led Courses

  • Cloud Analytics
  • Data Management for Cloud
  • DRM
  • Essbase
  • EPBCS
  • FCCS

Instructor-Led Courses

  • FDMEE
  • Financial Reporting Web Studio
  • HFM
  • HPCM
  • Hyperion Planning
  • PBCS
  • Smart View

Self-Paced On Demand Courses

  • On Demand Training for Admins
  • On Demand Self-Paced Training for End Users

© 2019 · 123 OLAP ·