EPM - EPM Junkie

Resetting Admin Passwords

Reset a lost Oracle EPM admin password with a little SQL.

FDMEE Parallelism Gone Wild? Rein it in with custom throttling!

If you're like me, you've noticed (perhaps despairingly) that FDMEE settings can be a bit extreme. You need to tightly control the order and concurrency of your data loads? Sequential to the rescue! Oh wait now, you need to allow multiple loads to process at the same time? Parallel to

EPM

FrankenHyperion (Ubuntu, SQL Server for Linux and Nginx)

If you read my last post you know I ran into some problems at the end. Not related to SQL Server but related to how OHS (Oracle HTTP Server aka. Oracles version of Apache) plays with Ubuntu. For whatever reason I was not able to get OHS to install correctly

EPM

EPM 11.1.2.4 and SQL Server on Ubuntu

Today we try something different. I have a stock Ubuntu installation in Hyper-V. Microsoft has released SQL Server for Linux, I think SQL Server for Linux is a Release Candidate (RC), which we over at Tevpro have been using with some .NET Core applications. Lastly, I need a VM of

Beard

Kscope 17 Recap - Day 3

I have got to start getting to sleep earlier but I have been having too much fun meeting with people. So yea I missed the first round of sessions but honestly, it was a conscious decision, nothing looked very interesting to me. So the first session for me is "

Kscope

Kscope 17 Recap - Day 2

I started the day by following Cameron into the Essbase Development session, I was running a bit late, and had a few takeaways. Essbase Studio is not supported on 12c Java and REST API will continue to be supported EAS will not be available in 12c IDCS will be the

Jython

Splitting multi-period into single period load files

When loading data into Oracle EPM applications the tool of choice is Financial Data Quality Management Enterprise Edition (FDMEE). Dating back to Classic FDM it has been possible to load either by single period or multi-period. In Classic FDM there was a performance penalty associated with processing multi-period files. The

Groovy

Kscope 17 Recap - Day 1

Fun times out here in San Antonio, if you haven't been you definitely want to check out Kscope next year in Orlando. I haven't let the family know yet but something tells me the whole crew will be there. So things we learned yesterday: Big data has some really cool

DRM

Creating DRM Properties that Inherit from Descendants

Overview To inherit is defined as "to receive or be left with (a situation, object, etc.) from a predecessor or former owner." DRM allows for property inheritance which works great for things like Account Types in planning applications or currencies on entities but, what happens when you need

Python

Extracting UDAs from the Outline

First, hope everyone had a wonderful holiday weekend. Now it's back to real life... I have been doing quite a bit with DRM for a while now and am currently migrating a Planning application to DRM. One of my most recent tasks was to load the UDA's into DRM. Now

FDMEE

Dynamic Calcs from FDMEE Event Scripts

In a recent project I came across a process the client wanted to keep intact that seemed easy enough in FDMEE. They had multiple calc scripts saved in text files with custom ##VARIABLES##. These needed to be parsed, replaced and executed before or after certain data loads. In the old

Infrastructure

Oracle EPM 11.1.2.X Memory Settings (Heap)

Overview Lets not kid around, Oracle EPM is a beast. Any environment that has more than 2 users is probably going to require some performance tuning. Fortunately there are a lot suggestions on what to do should you encounter memory problems. Unfortunately though much of that information is just that

ODI

Working with temporary folders in ODI

In the past I have (like I assume most ODI developers) setup local folders or network shares to house files that ODI needs to manipulate(modify, write). These folders and files have had various purposes. Sometimes it has been a staging location for a file copied off another system using

EPM

DRM Enumeration

DRM appears to be going away from the formula engine and toward JavaScript (JS was one of the first languages I learned back in 1996.) Unfortunately I find the documentation to be a bit lacking especially in regards to some of the enumeration. Below I will attempt to make it

EPM

DRM-14090

Recently I ran into this error message when creating and saving a new version in DRM. The server returned an error processing the action: CloseJob Error message: DRM-14090: Cannot mark version <id number> as deleted. It does not exist in the repository. When we first encountered the erorr

Python

Python Tools

I've been playing around with python/jython a lot lately and have thrown together a small set of tools. These tools can be found on GitHub. Below I'll try to explain the purpose of each. This may end up being a mutlipart post as I plan to add to the

Hyperion

Recover Lost Weblogic Password

The other day I was helping a client with changing their weblogic admin password since it had been misplaced. I started by using the steps outlined here, they work great by the way and if you have this issue in a single server environment I recommend using this link to

Planning

com.essbase.api.base.EssException: Cannot sign on to domain. Error initializing the ORB. com/hyperion/dsf/api/DsfException

Today I found the error message com.essbase.api.base.EssException: Cannot sign on to domain. Error initializing the ORB. com/hyperion/dsf/api/DsfException in the Planning_WebApp.log on one of the servers in a clustered environmnet. It took quite a bit of digging but after sometime I

Hyperion

Configuring ODI Studio with FDMEE

This post is a continuation of my previous post on Installing ODI Studio with FDMEE. I know this has been covered elsewhere but I figure it can't hurt to have a step by step guide. FDMEE Settings First locate the Data Management component of Oracle EPM by Navigating to Administer

Hyperion

Installing ODI Studio with FDMEE

Prior to 11.1.2.3 FDMEE was known as ERPi and while it worked together with Oracle Data Integrator (ODI) they were seperate installs. ODI's installer is good but I woudln't call friendly or great. The agent configuration in ODI for example is not part of the install and

EPM

EPM Hyperion Service Control Utility

The EPM Service Controller utility allows for fast access to Hyperion services in a quick, user-friendly interface. The tool is compatible with many versions of Hyperion products.

Essbase

EPM Security (Passwords)

As consultants we implement and work on a lot of EPM environments. Like most EPM installers we follow some well-known conventions when it comes to database schema names and user accounts. One other thing we, and many others, commonly do is use familiar passwords so that our teams can get

Hyperion

Enable Multiple Data Columns Using ODI

When using ODI to push multiple data fields into Essbase, it's a lot easier than one might think. All the tools you need are right inside ODI RKM for Essbase. I'm not going to go into how to use ODI to reverse engineer an Essbase application that is a topic

Planning

Tasklist Reports from the Planning Database - Part 2

In the previous post I showed you how to query the planning database to get a report of the task lists. At the time I figured I was done but a co-worker had other plans and asked me if I could sort it properly. So here ya go, version two

Planning

Tasklist Reports from the Planning Database

Have you ever wanted to create a report of all the tasklists and tasks in a planning application. Fortunately there is an easy way. First open the planning application and locate the View menu and locate the Report menu item. Next select the task lists that should appear in the