Hyperion - EPM Junkie

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

FDMEE

Rounding in FDM vs FDMEE (Visual Basic to Jython)

FDM to FDMEE conversions have been very popular in the past year or so for obvious reasons. While users can choose to keep using visual basic for their logic some have chosen to use Jython. As a person who started his career writing database driven websites with ASP (VBScript) and

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

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

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

Outline Extract

List Dynamic Calc Members

What is this? This morning my functional users were having issues with some older calculations due to DynamicCalc members being in the fix statement. Apparently some members in the outline were changed recently, within the last couple months, and no one updated the calculations, tracked the outline changes or did