Data maps are great on their own, but even better with Groovy.
Category: EPM
Working with EPM Direct URL’s
Direct URLs seem kind of cool
EPM Cloud Planning Clone Environment
EPM Clone Environment has really improved since I last wrote about it.
Using the View Dimension for Calculations
Cool use of the View dimension for calculations.
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.







