Using Groovy to execute rules as administrator, an update to an old post.
Category: Uncategorized
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.
Archive EPM Snapshot with PowerShell
Basic PowerShell script using EPM Automate to archive snapshots.
Hyperion Solutions Conference 2020
The Hyperion Solutions Virtual Conference 2020. The conference is a free, 4-day event taking place Monday, October 19th to Thursday, October 22nd. The conference has over 75 sessions from the old Hyperion Solutions Conference days along with today’s top speakers on Oracle EPM and Analytics. The agenda features various sessions on all things “Hyperion” but … Continue reading Hyperion Solutions Conference 2020
DM, MR, and a Function
In keeping with the name of this site, this post will be a few random EPM items. I believe each to be useful information, but not necessarily needing a dedicated post by themselves. PeriodsToDate Function The function PeriodsToDate can be a very useful function. It is commonly used in a View dimension to get QTD … Continue reading DM, MR, and a Function
EPM Automate: Using copysnapshotfrominstance to migrate
Using Calc Manager Scripts
Changing Target Plan Types in Data Management
Remove Zeros from Planning
This script will replace all the zeros in the scenario Actual with #Missing, thus reducing the size of the database. After running script, must do a dense restructure. SET UpdateCalc Off; Actual = Actual / (Actual != 0);