Yes, there is free lunch! Oracle throws in a bunch of utilities along with Hyperion – e.g. Log Viewer, Audit Extract, Copy Application, Extended Analytics Template Copy, Application Year Update, HFM Tool Box, Rules Managers and many others. Learn all about these free utilities. Or why not write your own? For example, with a little knowledge of VBA, and a little database, you can write a utility to go through entire EPM application, the rule files and scripts to search for a string.
- Explain and demonstrate EPM utilities
- How to write a utility using VBA
- Common VBA functions
- Database tables for EPM repository
- Tips and tricks for writing powerful utilities