Jason Kaniss

Hyperion Planning Runtime Prompt Security Situation As many of you know, one of the benefits of using a business rule over a calculation script is their ability to utilize run time prompts.  Run time prompts allow the business rule to be dynamically customized to the point of view (POV) the user is currently working with.  […]

Like many of us, I have run into several essbase errors while creating/testing/implementing new applications and scripts.   Some of the errors have useful information in the log files or the error code’s description clearly reveals where the error lies, but there are those codes which provide little to no information or the accompanying error message […]

The Situation: Planning 11.1.2.1 Client has two Plan types (Finance & FTE) Detail employee data is held in the FTE cube and summary employee data is held in the Finance cube Requirement: Move data from FTE cube to Finance cube at the summary level as efficiently as possible. Solution: The @XWRITE function does just what […]

Creating Essbase Data Backups with Filename Date & Time Stamps The Situation: Planning 11.1.2.1 Client has 1 application with 3 databases Requirement: Automate a daily backups of the Essbase data for all three cubes at 7am and 7pm. Solution: Used MAXL script to export the data from essbase Batch file to execute MAXL script and […]

Or…How do I assure my users pick the correct Entity / Cost Center combination? The Situation: Planning 11.1.2.1 Client has an Entity and a Cost Center dimension End users primarily use Data Forms for data entry The Cost Centers are setup such that they begin with the Entity and then have a 6 digit code. […]

The Situation: A client has purchased the Workforce for Planning module and would like to feed their HR related data directly into the system with as little amount of user intervention as possible.   This information is primarily made up of text related items, such as Employee Name, Title, Job Code and other text and value […]