div class='cap-left'/>
Showing posts with label GeekStuff. Show all posts
Showing posts with label GeekStuff. Show all posts

GeekStuff (EPM): Oracle EPM HFM 11.1.2.4 and Oracle DB 12c

Tuesday, March 28, 2017

Introduction

At the time of writing the latest available PSU .204 for HFM does not support Oracle Database 12c yet. Although it works well, it doesn't work out-of-the-box.

Can't wait for Oracle to officially support Oracle DB 12c? Read on!

Geek Stuff (EPM) - Undocumented Parameters EPM Diagnostics Utility

Wednesday, November 30, 2016

Introduction

Since Oracle EPM 11.1.2.0 Oracle has introduced EPM Diagnostic Utility (validate.bat). For the newbies, the EPM diagnostic utility is a java based tool with the purpose to technically validate an EPM instance. Executing this utility results in two things: A full HTML diagnostics report, and a ZIP file containing all log files from the instance it was executed from. The Oracle EPM documentation related to this utility can be found here.

Since Oracle EPM 11.1.2.3, the EPM diagnostic utility is a good start when validating a installation or troubleshooting issues. However there are some minor downsides: It always performs all tests, always creates a ZIP file after completion and there is not option to selectively test... at least so I thought.

For an automation project, this default behavior was a problem. As such, I examined the java code related to the EPM diagnostic Execution and discovered that it excepts various command line parameters borrowed from the EPM installation utility wizard.

Planning Tutorial: How to deploy Planning Utilities Standalone!

Monday, July 4, 2016

Introduction

If you ever had to publish Planning utilities for administrators in e.g. Terminal Server or Citrix, you experienced the difficulties of doing that. Planning utilities can only be executed on the server where Planning is installed. Solutions to provide access to these utilities range from full administrative (RDP) access on the Planning server to PowerShell scripts using remote execution. In my experience non of these solutions are ideal and at best cumbersome to maintain.

Already for a few years I though: "There must be another way".

... and now there is!

Geekstuff (EPMA) - ZAP! that orphaned EPMA application!

Monday, May 9, 2016

Introduction

Probably most of you who worked with EPM Architect before faced the situation where an application in EPMA is in a corrupted deployment state and cannot be deleted properly from EPMA the usual way, or EPMA complains that the application already exists while attempting to recreate the EPMA application you deleted.

In most cases running diagnostic against the application would get you back on-track. If not, as a last resort you can drop all tables from the EPMA database by re-configuring the EPMA data source. However in most cases this is not an option.

If you have manually removed all references of the application in all EPM components (how is out-of-scope of this post) and still you cannot re-create the application in EPMA, consider using my SQL script below to ZAP! that orphaned application from the EPMA database.

Geek Stuff (FR) - Let's not press a zillion times on "Yes" during FR import through Workspace, right?

Tuesday, May 3, 2016

Introduction


For those who migrated Financial Report objects using Workspace, will recognize the frustration of having to click "Yes" a zillion times during import.

For those who got spared so far: When LCM is not an option to migrate Financial Reporting objects, you have to use Workspace to export from the source and import in to the target environment. Sadly Oracle still didn't builtin a "Yes to all" option for some of the import activities, resulting in many manual clicks on "Yes" for sometimes over an hour.

Below you will find a solution to automatically click "Yes" when needed.

Geek Stuff (Linux) - Show Chmod Numerical Permissions

Thursday, December 3, 2015

During Linux installations of EPM, setting and validating the correct security on folders and files can be a challenge. The chmod command is used to set security access, while chown sets the ownership's. As you might now chmod has two modes of reading and applying security access: Symbolic and Octal mode.