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.

Narrative Reporting Snapshot Downloads

Unfortunately, Narrative Reporting (NR) does not use EPM Automate like other products within Oracle EPM Cloud.  I find this very disappointing and frustrating, but it is what it is and we’ll adapt. One of the basic tasks that I set up whenever working with a client on an implementation is to download and retain daily … Continue reading Narrative Reporting Snapshot Downloads →

Smart View Error: Invalid axis type for dimension Entity

Encountered the error "Invalid axis type for dimension Entity" in Smart View at a client. I had never seen this error before and couldn't find anything when I googled it.  I was able to sit with a user experiencing the issue and quickly saw what the problem was.  The EPBCS application was using the Financials … Continue reading Smart View Error: Invalid axis type for dimension Entity →

Agg w/ EMPTYMEMBERSETS

Aggregation script to be used on forms, aggs the scenario selected on the form. SET AGGMISSG ON; SET CACHE HIGH; SET UPDATECALC OFF; SET LOCKBLOCK HIGH; SET EMPTYMEMBERSETS ON; /*Forecast Agg*/ Fix (@Remove({Scenario}, "OEP_Plan")) Fix ({Scenario} AND "OEP_Forecast")) /* cleaner way to use the Fix */ Fix ("OEP_Working", &OEP_FcstStartYr:&OEP_FcstEndYr) Agg ("DataSource", "Detail", "Entity", "Function", "Intercompany"); … Continue reading Agg w/ EMPTYMEMBERSETS →