Hyperion Planning: Administrator (5 days)
Learn how to create and manage Hyperion Planning applications, develop planning and budgeting models, load and manipulate data, create reports and ad hoc queries within a spreadsheet environment.
This course is designed to meet the needs of system administrators from existing implementations as well as new rollouts. It is the essential starting point for creating or managing Planning applications. Key design considerations are explored and best practice is discussed for the build, maintenance and support of Planning applications. This course investigates system design, development and administration and explores how data is submitted, adjusted, reviewed and signed off.
The activities throughout the week help to build an understanding of how the system responds, and the attributes of the dimensions that underpin the applications.
In addition to using EPMA to build metadata hierarchies and assign properties, you will see how to deploy and administer applications, build data forms, establish security, load data, create calculations and gain an understanding of the planning cycle. You will also get an introduction to Financial Reporting Studio and discover a variety of methods for using Smart View to report on Planning data. Topics related to Essbase are also covered where appropriate, with discussions regarding structure and how to optimise databases.
Navigation, EPM Architect, dimensions, app creation and deployment
Exchange rates, dense and sparse, calculating, Essbase optimisation, member formulas, loading data, FDMEE, task automation
Security, substitution variables, data forms, rolling forecasts, menus, smart lists, text and date members, composite forms, application defaults, data entry techniques
Grid diagnostics, cell history, calculation scripts, calculation order, controlling calculation scope, allocations, design considerations, functions, ranges, approval management, creating task lists
Life cycle management extracts and imports, Smart View connections, viewing forms in Excel, ad-hoc analysis, smart slices, working offline, financial reporting studio, creating Planning reports, creating Essbase reports
Detailed course agenda / Justification for your manager
Course title: Hyperion Planning: Administrator
Duration: 5 days
Audience: System Administrators
Delivery method: Classroom (group - live)
Advanced preparation: None
Recommended CPE credits: 35 credits - specialised knowledge and applications
Programme level: Intermediate
Keyteach is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. Registration ID No 115820. State boards of accountancy have the final authority on the acceptance of individual courses for CPE credit. Any complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.learningmarket.org