Category: Oracle Hyperion EPM 11.1.1.3

Notepad++ Silent Install Script

Similarly to the 7-zip silent install script, I also use the following script on my servers during their original build and patching: pushd "\\epmfileserver\share\utilities" npp.6.6.9.Installer.exe /S popd I’m not sure if any of you have ever used pushd and popd, but...

7-zip Silent Install Script

I’m just sharing a little script I use to install 7zip in silent mode. pushd "\\epmfileserver.mydomain.com\share\utilities" 7z920-x64.msi /q INSTALLDIR="C:\Program Files\7-Zip" popd I’m not sure if any of you have ever used pushd and popd, but they are pretty handy. The pushd...

Migrating Essbase to New Location

How to migrate Essbase index files and page files for one location to another using Essbase, not symlinks. Log into EAS, and expand the application that you are wanting to move the data for. Right click on the Database and choose...

EPM Hyperion Workspace Repository Items SQL

I had the need to look up all Financial Reporting documents in workspace. I compiled the following list of SQL commands to run against the Oracle database repository. The last command is the winner. http://hyperion-consulting.blogspot.com/2011/09/in-which-tables-reporting-objects-are.html http://hyperion-consulting.blogspot.com/2011/09/in-which-tables-reporting-objects-are.html (posted by Thigulla Krishna) Financial Reporting...

Copying all files with a certain extension from all subfolders in a directory

I had to copy all of the files (calc scripts) from my Essbase servers’ application directories, and wanted to preserve the folder layout in the destination. I ran the following against all of my servers to achieve this: cp --parents `find...

Cron script to check Planning web app status

I was searching around for a way to monitor my Planning web servers, and I found the following post by Mike (https://grepular.com/Monitor_Your_Website_Automatically_From_Cron). I followed his advise, but customized his commands into the following script (which I croned) to both email and...

Essbase: Validate a database against any errors with Maxl (part 2)

You have two options for attempting to validate an Essbase database: Esscmd and Maxl. This post is for using Maxl. admin@epmdbserver:/home/admin>startMaxl.sh Essbase MaxL Shell 64-bit - Release 11.1.2 (ESB11.1.2.2.102B025) Copyright (c) 2000, 2012, Oracle and/or its affiliates. All rights reserved. MAXL>...

Essbase: Validate a database against any errors with Esscmd (Part 1)

You have two options for attempting to validate an Essbase database: Esscmd and Maxl. This post is for using Esscmd. Esscmd: admin@epmdbserver:/home/admin>startEsscmd.sh Essbase Command Mode Interface 64-bit - Release 11.1.2 (ESB11.1.2.2.102B025) Copyright (c) 1991, 2012, Oracle and/or its affiliates. All rights...