Cool use of the View dimension for calculations.
Author: Paul Lewis
I started working with Hyperion Planning back in 2008, first as an end user, then moving into an administrator role, and now for the last several years as a consultant. In February 2021, I became an Oracle ACE Associate, then in August 2021 I was promoted to ACE. This blog started as a way to keep track of my own thoughts, the issues I encounter and the solutions found. It has evolved into a way for me to share those thoughts and solutions with the EPM community.
Initial Setup of User Variables
Using Groovy to setup User Variables in EPM.
Using Auto Predict with Inconsistent History
EPM Planning has a great tool called Auto Predict. But what happens if your historical data is less than ideal? Perhaps there was a major event (like a pandemic) that warped a chunk of your historical data. Here's one way to approach it with Auto Predict.
Copy Data from Dynamic Member to Store Member with Groovy
Easy Groovy script to copy data from dynamic to store member.
Using Out-of-Box Trending on No Currency
Quick fix to use OOB trending on No Currency.
Using Custom Substitution Variables in Forms
Simple workaround to use custom substitution variables in forms.
Conditional Suppression Using a Smart List Value
Conditional Suppression in EPM reports is very useful, you can even use it to suppress Smart List values.
Bursting with Targeted Distribution File
Not all CSV files are the same, selecting the wrong format just will not work.
Alternate Period Hierarchy
Ran into interesting error when adding an alternate hierarchy in the period dimension.
Using Groovy to Copy Data Between Cubes
Using Groovy in EPM to copy data...
Random EPM Notes 