Cool use of the View dimension for calculations.
Author: Paul Lewis
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...