Thoughts, ideas and solutions from a few EPM consultants.

EPM Hyperion Service Control Utility

The EPMI EPM Hyperion Service Controller utility allows for fast access to Hyperion services in a quick, user-friendly interface. The tool is compatible with many versions of Hyperion products and makes use of 3 main components: The Servers pane, the Services pane, and the Log pane. These three components allow a user to quickly add servers and control the Hyperion services for each, as needed. A messages window keeps a user updated on the current status of a running operation. This guide aims to give insight to the features of the EPMI EPM Service Controller as well as to give guidance on installation and usage.

Installation

Download the installer from Git Hub. Once downloaded the installer will extract all the components and create a shortcut in the Windows Start Menu. Some previous releases used did not have an installer. To use a previous release download the zip and extract to a folder.

Download EPM Service Control

Configuration

Once launched the EPMI EPM Service Control opens and is ready for use. Out of the box it is setup to work with the local machine. If the envrionment consists of multiple servers they can be configured.

EPMI Service Control Start

Servers Pane

The Servers pane allows users to define and select a specific server. You will notice that Localhost has a check-box next to it. This means that if there are multiple servers, a user can select which services to start/stop as well as for which servers to do so. To add additional servers right click anywhere in the Services pane and select Add.

Add Servers

When Add is selected, a Server Information window appears. The window consists of 3 tabs: Host Information, Credentials, and Unix Path. The server Name and Hostname or IP Address can be defined in the Host Information tab.

Serice Control Host Information

The Credentials tab is used to enter the server’s username, password and domain (Windows) for verification and login.

Service Control Credentials

In the Unix Path tab, the path for a Unix server can be entered. A user can also choose to have the path detected using the Detect… feature. The utility assumes the server is Unix/Linux when the SSH checkbox is selected on the Host Information tab. When the required information is entered, select Submit.

Service Ccontrol Unix Path

Save Servers Profile

Changes to the servers profile are not automatically saved. To do so that changes show upon next start of the utility select File > Save.

Service Control Save

Services

After a server or servers are selected, the Services pane allows a user to select a the Oracle EPM version from a dropdown list of sample profiles.

Services Dropdown

Once selected, a list of available services is shown in the Services pane. The check-box next to each service allows users to select specific services to stop or start. To stop all services, select all check boxes in the Services pane and select Stop Services.

Services Stop/Start

To start all services, select Start Services. In order to stop or start individual services, simply deselect the services which do not need to be started or stopped and select Stop Services or Start Services.

Log

The Log pane gives feedback as to the status of an inquiry. It provides information listing whether a request has ran successfully or not.

Services Log

Final Thoughts

This utility was developed with Oracle EPM in mind but as you can see from the last screenshot it is capable of controling non-EPM services with a few changes to the XML based profiles. It really makes service restarts in clustered environments quite easy and painless. Once side effect is you might never right a start/stop script again.