Financial and Technical System Administrators, Financial Modellers and Financial Power Users
An understanding of Essbase databases (particularly aggregate storage models) is useful, as is a working knowledge of Smart View.
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.
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.
Reviewing the models, dimensions and the creation and deployment of applications.
POV creation, deployment to Essbase, Rules and Rule Sets, Rule Balancing, Data Load, Model Views.
Custom Calculations, Trace Allocations, System Reports, application creation options, Security, Lifecycle Management.
• Rules and Rule Sets
• Database Management
• Model execution
• Reviewing the data and Model Validation
Supporting Essbase Databases
• The HPCM Essbase Database (ASO)
• The Dimension Library
• The Application Library
• EPMA Background information
• EPMA Profitability properties
• Dimension Sort Order
• POV, Business and Attribute Dimensions
• The Balance Dimension
• The Rule Dimension
• Deploying the application
• Master Essbase Cubes
• Creating applications from Text Files/Templates
• 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
• Managing Queries
• System Reports
• Smart View with HPCM
• Understanding HPCM
• Financial Reports
• Security Overview
• HPCM Security Roles
• Security Provisioning
• 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.