Hyperion EPM 11.1.2.3 Issues and solutions

1)

Error while creating planning application through work space :

Hi,

I am getting the following error when i am trying to create the classic planning application through work space.

Invalid or could not find module configuration.

Required application module Hyperion Planning. App Wizard is not configured. Please contact your administrator.

Communication Error.
http://localhost:28080/Hyperion Planning/conf/HspJSConfig.xml?LOCALE_LANGUAGE=en

Please suggest me how to resolve this error. Also please share the order in which services to start.

What I did : Because it said no application module configured at that time two things came into my mind

1) Restarting all the services may help us.

2) do some manual planning application configuration and copy to that planning apps location restart all services.

Solution for this :

If you are going through work space and using Apache plugin (HTTP realted), you should access work space on port 19000.
http://<workspace machine>:19000/workspace/index.jsp

Ref : https://forums.oracle.com/thread/841482

2) After adding a machine name to the EAS console. we got an issue when we try to add Essbase server.

It is giving network configuration failed. could not connect to localhost:1423

What I did:  As shown in some blogs i thought restarting of OPMN will give the solution.

Then I did it. It works for me.

3) Work space – Dimension library issue:

Today when we are trying to open Dimension library and Application library through workspace

We came across below issue:

Right Hostname could not be parsed.

Epm.web.dimensionlibrary exception.

Solution: When I am looking into the services  status running or stopped, everything is running except EPMA process manager.

I restarted it and logout ,login workspace.

Now we are able to open dimension library. J

Oracle Hyperion Enterprise Performance Management (EPM) System Component overview

This post is brief overview of Oracle Hyperion Enterprise Performance Management (EPM) System Products which consists of

1) Hyperion Foundation Services

1.1) EPM Shared Services - provides EPM System Products identity management, user provisioning, and task flow management.
1.2) EPM workspace – thin client interface to work with EPM content.
1.3) Performance Management Architect – enables creation and deployment of financial applications from central location.
1.4) Calculate Manager – module used by Planning, Essbase, and Financial Management users can use to design, validate and administer business rules.
1.5) Smart view for Office – microsoft office add-in for Hyperion System Products.

2) Essbase

2.1) Essbase – is business analysis software to develop custom analytics and enterprise performance management applications.
2.2) Essbase Administration Service – administration tool to manage Essbase deployed on application server.
2.3) Business Rules – installed and configured as part of Administration Services, is used to create, execute and manage business rules.
2.4) Integration Services – tool to create OLAP models, outlines and Essbase Database.
2.5 ) Provider Services – is middle tier data source provider for essbase, planning, and so on
2.6) Essbase Studio – consolidates cube-construction activities in one interface.

3) Hyperion Reporting and Analysis

3.1) Hyperion Interactive Reporting – intuitive user-directed query and analysis capabilities.
3.2) Hyperion Financial Reporting – book-quality financial and management reports that comply with regulations and external requirements.
3.3) Hyperion SQR production Reporting – high-volume, formatted reports coming form different sources
3.4) Hyperion Web Analysis – provides online analytical processing (OLAP) analysis.

4) Hyperion Financial Performance Management Application

4.1) Planning – is a centralized planning, budgeting, and forecasting solution that integrates financial and operational planning processes.
4.2) Financial Management – is financial systems software application that provides global collection reporting and analysis in single solution.
4.3) Financial Close Management – to define, execute, and report on interdependent activities of financial close period.
4.4) Performance Scorecard – is a balanced scorecard collaborative certified application to articulate strategy and goals, communicate them across enterprise and monitor KPI.
4.5) Hyperion Strategic Finance – is financial modelling application to identify and understand full financial impact of alternative corporate strategies.
4.6) Profitability and Cost Management – is an analytic application for managing cost and revenue allocation to compute profitability for business segment.
4.7) Disclosure Management – used to assemble a reporting package for submission to a regulatory agency.

5) Data Management

5.1) Hyperion Financial Data Quality Management (FDM) – helps finance users develop standardised financial data management processes.
5.2) ERP Integrator – Module of FDM, to integrate metadata and data from ERP source system to Hyperion EPM target application.
5.3) Hyperion Data Relationship Manager (DRM) - enables to build consistency within master data assets despite changes within the underlying transactional and analytical systems.

Oracle Hyperion Database Administrator

Oracle Hyperion EPM Installation and Administration : Part1


Oracle Hyperion Enterprise Performance Management (EPM) as name suggests is enterprise performance management software that provides planning, budgeting and forecasting solution.

Hyperion was acquired by Oracle in 2007 and consists of following components

• Hyperion Foundation Services
• Hyperion Essbase
• Hyperion Reporting and Analysis
• Oracle Hyperion Data Management
• Hyperion Financial Performance Management Application that consists of

• Hyperion Financial Close Management
• Hyperion Financial Disclosure Management
• Hyperion Financial Management – Fusion Edition
• Hyperion Strategic Management – Fusion Edition
• Hyperion Performance Scorecard – Fusion Edition
• Hyperion Profitability and Cost Management – Fusion Edition

This post covers high level steps to install Oracle Hyperion EPM 11.1.1.2.1

1. Download Oracle Hyperion EPM Software from eDelivery (select product Oracle Enterprise Performance Management System)
2. Install Database for Hyperion (Database character set must be with UTF-8 encoding (AL32UTF8, UTF8, UTFE)
3. Install Java Development Kit (JDK or JRockit) 1.6 or higher
4. Install Hyperion EPM System Components using installTool.sh/bat (This will install WebLogic Server, Oracle HTTP Server, and EPM System)
5. Configure Hyperion EPM System Components using configTool.sh/bat ( This will create Weblogic Domain, configure OHS Server, System Component for EPM i.e. EPM ORACLE_INSTANCE and configure EPM applications)
6. Start Hyperion EPM System Components using EPM_ORACLE_INSTANCE /bin/start.sh
7. Validate/Access Hyperion EPM System Components