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
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.