Category: Oracle Hyperion 9.3.1

Create EPM Hyperion Financial Reporting Export Folders

EPM Financial Reporting – Batch Export Folder Locations Note: If you have never launched the FRConfig utility or get an error message, do the following step first. Set EPM_ORACLE_INSTANCE path Edit E:\Oracle\Middleware\EPMSystem11R1\products\financialreporting\bin\setInstance.cmd in notepad. Add your EPM_ORACLE_INSTANCE path after the equal...

EPM Hyperion Workspace Repository Items SQL

[ad#ad-post] 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...

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...

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...