Category: Oracle Hyperion EPM 11.1.2.2

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

Exporting Security Out of Hyperion Planning Application via Oracle Database Repository

I found the below article after hours of searching for a solution for us. I hope this helps others.   EPM 11.1.2 – Exporting Security out of Hyperion Planning application By Ruben Verghese on Sep 03, 2011 copied from https://blogs.oracle.com/pa/entry/exporting_security_out_of_hyperion You...

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

HFM 11.1.2.2 Driver and ODI 11.1.1.7 on Windows 2008R2

Installing the HFM 11.1.2.2 Driver for ODI 11.1.1.7 on Windows 2008R2 (64bit) Download the Oracle Data Integrator Companion from http://www.oracle.com/technetwork/middleware/data-integrator/downloads/index.html. Extract the files and browse to the \sdk\oracledi-sdk.zip\oracledi.sdk\lib directory in the downloaded zip file. Rename the files listed in the “Rename”...

EAS trying http instead of https when behind load balancer configured with SSL

I ran into an issue when trying to use the https://myepmsuite/easconsole/easclient.jar URL for the first time since configuring SSL on our load balancer. Java opened and tried to load the EAS client, but it stopped with “Unable to launch the application.”...

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...
(adsbygoogle = window.adsbygoogle || []).push({});