No More EPMA? Simplify your Hyperion Planning Integrations with Outline Load Utility
In this session, we’ll show you how to fully deploy a Hyperion Planning integration solution just by using the out of the box Outline Loader Planning utility. We’ll describe how a shell scripting wrapper was built to integrate the Outline Loader statements, MaxL statement, Calc Scripts, SQLs statements into a single scripting language to fully integrate Hyperion Planning applications with ERP systems and reporting systems. This is an easy approach that simplifies the integration platform avoiding the need for additional tools or stages, manage Import and Export dimensions and data from relational tables or text files into Hyperion Planning applications and Essbase cubes, and share data and metadata between Planning applicants and Essbase cubes.
Presenter: Mauro Lemus, Hyperion EPM Architect, University of Missouri System
Mauro Lemus is a Computer Systems Engineer with more than 20 years of professional experience in the IT field. He worked as an administrator, developer, and architect for Essbase and Hyperion Planning. In 2012, he accepted a permanent position at the University of Missouri in the IT division as Hyperion Architect. He has combined his IT career working as a college professor teaching networking, programming languages, and database courses. Mauro has had the opportunity to work in different countries including Colombia, Peru, Ecuador, Venezuela, Panama, Japan and the U.S. He received a Technologist degree in Electronics and Telecommunications, a Bachelor’s degree in Computer Sciences, and a Master’s degree in Mathematics with Concentration in Computer Sciences.