Visit the Github repository for this project

EPM InstallAutomation

Summary:

The goal of this utility was to make the installation and configuration of Hyperion EPM easier and quicker for Hyperion Administrators. While the project is young and in early development this very early version has a lot to offer for very specific situations. Scroll down to the bottom of this page to find the instructions for your particular environemt layout

Limitations:

1. Oracle DB is not currently supported
2. SOA is not currently supported
3. Individual database usernames are not currently supported
4. 11.1.2.4 Only version currently supported

Requirements:

1. Logged in as a local Administrator

Steps:

1. Clone this repository to a folder on your server(s)
2. Unblock the three scripts in the powershell folder
3. Open Powershell as Administrator
4. Set ExecutionPolicy to Unrestricted

Set-ExecutionPolicy Unrestricted

1. Browse to utility powershell path

cd c:\InstallAutomation\Powershell

1. Run start.ps1

.\start.ps1

1. Follow the prompts (if silent parameters where not used)

Command Line Options:

Use only one of the following main options: -superSilentInstall, -superSilentConfig, -superSilentAll. To do a silent config, and install use the -superSilentAll option and all of its required and optional options. If you want to do just a silent install use the -superSilentInstall and all of its required options and optional options. Do the same thing for a silent configuration. If you specify a database for any of the modules the utility will configure that module. If a database name is not specified for a module that module will not be configured.

-superSilentInstall

  * Required Sub Options:
      * -install7zip ($true | $false)
      * -installNotepadPlus ($true | $false)
      * -installFirefox ($true | $false)
      * -installEPM ($true | $false)
      * -epmPath (String | Example: C:\Oracle\Middleware)
      * -installFoundation ($true | $false)
      * -installEssbase ($true | $false)
      * -installRAF ($true | $false)
      * -installPlanning ($true | $false)
      * -installDisclosure ($true | $false)
      * -installHFM ($true | $false)
      * -installFDM ($true | $false)
      * -installProfit ($true | $false)
      * -installFCM ($true | $false)
      * -installTax ($true | $false)
      * -installStrategic ($true | $false)

-superSilentConfig

  * Required Sub Options:
      * -dbServer (String | Example: server.domain.local)
      * -dbPort (String | Example: 1433)
      * -dbUser (String | Example: Hypadmin)
      * -dbpassword (String | Example: password!)
      * -wkspcAdmin (String | Example: Admin)
      * -wkspcAdminPassword (String | Example: password!)
      * -wkspcPort (String | Example: 19000)
      * -weblogicAdmin (String | Example: epm_admin)
      * -weblogicPort (String | Example: 7001)
      * -weblogicHostname (String | Example: server.domain.local)
      * -epmDomain (String | Example: EPMSystem)
      * -strategic ($true | $false)
  * Optional Sub Options:
      * -foundationDB (String | Example: EPMS_FND)
      * -epmaDB (String | Example: EPMS_BPM)
      * -calcDB (String | Example: EPMS_CAL)
      * -essbaseDB (String | Example: EPMS_ESB)
      * -rafDB (String | Example: EPMS_RAF)
      * -planningDB (String | Example: EPMS_PLN)
      * -disclosureDB (String | Example: EPMS_DMA)
      * -hfmDB (String | Example: EPMS_HFM)
      * -fdmDB (String | Example: EPMS_FDM)
      * -profitDB (String | Example: EPMS_PCM)
      * -startEPM ($true | $false)
      * -validate ($true | $false)
      * -distributedEssbase ($true | $false)
      * -remoteDeployment ($true | $false)

-superSilentAll

   * Required Sub Options:
      * -install7zip ($true | $false)
      * -installNotepadPlus ($true | $false)
      * -installFirefox ($true | $false)
      * -installEPM ($true | $false)
      * -epmPath (String | Example: C:\Oracle\Middleware)
      * -installFoundation ($true | $false)
      * -installEssbase ($true | $false)
      * -installRAF ($true | $false)
      * -installPlanning ($true | $false)
      * -installDisclosure ($true | $false)
      * -installHFM ($true | $false)
      * -installFDM ($true | $false)
      * -installProfit ($true | $false)
      * -installFCM ($true | $false)
      * -installTax ($true | $false)
      * -installStrategic ($true | $false)
      * -dbServer (String | Example: server.domain.local)
      * -dbPort (String | Example: 1433)
      * -dbUser (String | Example: Hypadmin)
      * -dbpassword (String | Example: password!)
      * -wkspcAdmin (String | Example: Admin)
      * -wkspcAdminPassword (String | Example: password!)
      * -wkspcPort (String | Example: 19000)
      * -weblogicAdmin (String | Example: epm_admin)
      * -weblogicPort (String | Example: 7001)
      * -weblogicHostname (String | Example: server.domain.local)
      * -epmDomain (String | Example: EPMSystem)
      * -foundationDB (String | Example: EPMS_FND)
      * -strategic ($true | $false)
   * Optional Sub Options:
      * -epmaDB (String | Example: EPMS_BPM)
      * -calcDB (String | Example: EPMS_CAL)
      * -essbaseDB (String | Example: EPMS_ESB)
      * -rafDB (String | Example: EPMS_RAF)
      * -planningDB (String | Example: EPMS_PLN)
      * -disclosureDB (String | Example: EPMS_DMA)
      * -hfmDB (String | Example: EPMS_HFM)
      * -fdmDB (String | Example: EPMS_FDM)
      * -profitDB (String | Example: EPMS_PCM)
      * -startEPM ($true | $false)
      * -validate ($true | $false)
      * -distributedEssbase ($true | $false)
      * -remoteDeployment ($true | $false)

Environment Instructions:

1. Standalone EPM (Single Server Environment)
2. Distributed Essbase (Two Server Environment)

Features:

1. Super Silent Install
2. Super Silent Config
3. Super Silent All
   • Examples:

.\start.ps1 -superSilentAll -install7zip $true -installnotepadplus  $true -installfirefox $true -installepm $true -epmPath <path> -installFoundation $true -installEssbase $true -installRAF $true -installPlanning $true -installDisclosure $true -installHFM $true -installfdm $true -installProfit $true -installFCM $false -installTax $false -installStrategic $true -dbServer <hostname> -dbPort <port> -dbUser <user> -dbPassword <password> -wkspcAdmin <user> -wkspcAdminPassword <password> -weblogicAdmin <user> -weblogicPort <port> -weblogicHostname <hostname> -wkspcPort <port> -epmDomain <domain> -foundationDB <db> -epmaDB <db>  -calcDB <db>  -essbaseDB <db>  -rafDB <db> -planningDB <db> -disclosureDB <db> -hfmDB <db> -fdmDB <db> -profitDB <db> -strategic $true -remoteDeployment $false

.\start.ps1 -superSilentAll -install7zip $true -installnotepadplus  $true -installfirefox $true -installepm $true -epmPath c:\Oracle\Middleware -installFoundation $true -installEssbase $true -installRAF $true -installPlanning $tru

See it in Action

Single Server Interactive:

Two Server Silent (Essbase Distributed)