The PeriodOffset function in Cloud EPM Reports is a cool feature to create dynamic reports with trailing (or forward looking) periods across years.
Period Offset
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.
Continuing Adventures in Drill-Through
Apparently, drill through is case sensitive.
Update Period Mapping in Data Management
Easy LCM "hack" to update data management period mapping.
Data Push for Non-Administrator Users
Here's a way for non-administrators to execute data maps, it's pretty Groovy.
Drill-Through Revised
Revised guidance to set up drill-through in Oracle EPM Data Integration.
EPM Automate sendMail
Finally, a command to send emails with EPM Automate.
Incorrect Data from File Loads in Data Management
I encountered an issue with a data load and in hindsight I should have known right away where to look. Actuals are loaded during close through an automated process utilizing EPM Automate and Data Management. The process has been working without issues since it was implemented. But recently we needed to manually reload some prior periods due to … Continue reading Incorrect Data from File Loads in Data Management
Smart View on Mac
Are you curious how to use Smart View on a Mac? Check out my latest post to see how easy it is to set up.
Archive EPM Snapshot with PowerShell
Basic PowerShell script using EPM Automate to archive snapshots.
Rules or Rules? The Answer is Artifact Labels
Rules or Rules? The Answer is Artifact Labels
Random EPM Notes 