Oracle Virtualization and Cloud Consulting
view counter

Feed items

Planning Outline Load Utility Enhancements Part 3

In the previous two parts I went through the majority of the new functionality available with the Outline Load Utility, there is one remaining piece which I will quickly go through today and that is extracting data to a flat file.

The loading of meta/data can now be achieved from a relational source but unfortunately the new functionality of extracting data can only be to a target flat file, I am sure in future releases a relational target option will be added.

ODI – Extracting Essbase attribute members bug + fix

Just another really quick update from me today, I have seen a few posts on the issue in the past and noticed there is an actual fix available now so I thought I would go through the problem and the fix.

The issue definitely exists on and I believe it exists in unpatched and 10g.

Say you want to extract the hierarchy from an attribute dimension from an essbase outline it certainly should be possible using the “LKM Hyperion Essbase METADATA to SQL”

Planning Outline Load Utility Enhancements Part 2

In the last blog I went through some of the new functionality with the Outline Load Utility and today I am going to continue and go through loading data from a relational source.

I am not going to cover any of the properties again so if you have not done so it is probably worth having a read of the last blog.

Planning Outline Load Utility Enhancements

I noticed that the recent patch release of planning includes some additional functionality for the outline load utility that is worth going through.

With each release the outline load utility seems to gain extra functionality and it has just grown from strength to strength since its first appearance in

It is a utility that I know has made consultants lives much easier, it is simple to use and is now packed with functionality.

The enhancements in this patch release are

ODI – Planning KM bug + fix

Just another really quick update from me today, I have seen a few posts on the following issue and it actually hit me first time I used with planning so I thought I would quickly go through the problem in case anybody else hits it.

The issue seems to be only related to

When you create an Interface to load from any source to a planning application and go to select the IKM you will probably see the following. Compact deployment performance degradation

A quick post from me, if you running a compact deployment and in particular planning then you may experience performance degradation due to the default ODL logging level setting.

In most circumstances a compact deployment will be used in a Dev, POC, cloud, personal laptop type scenario and the last thing you need is any type of performance issues so updating the logging level is worth implementing.

ODI Series – Standalone Agent High Availability using OPMN

There are a few options around to offer high availability with ODI agents and the usual route is to deploy and cluster two or more J2EE agents,  these would then be fronted by a HTTP server.  Using this method allows for load balancing of the active/active agents and the failover of the scheduler as only one agent should be the scheduler.

EPM Deployment Report

In a new feature was added to the Shared Services registry command line utility which allows the generation of a deployment report, I briefly highlighted the new addition in my installation blog.

EPM – Compact deployment

I thought I would put together a write up on compact deployment in as judging by some of the posts on the OTN forums lately there is a bit of confusion around this area.

EPM Shared Services Registry cleaner

No doubt you aware of the EPM Shared Services registry but if you are a little unsure on what it is all about then here is the official Oracle description.

The Shared Services Registry is part of the database that you configure for Foundation Services. Created the first time that you configure EPM System products, the Shared Services Registry simplifies configuration by storing and reusing the following information for most EPM System products that you install:

view counter