Sunday, May 20, 2012

ORACLE EPM 11.1.2.2 – First Look

In the first look we can see the below new features in ORACLE EPM 11.1.2.2

1) IBM WebSphere 7.0.0.19+ (AS, ND) is now supported as an application server.

2) FireFox 10.x+ and Internet Explorer 9 are now supported Web browsers.
3)  Microsoft Office 2010 64 bit is now supported.
4)  After completing an EPM System deployment, you can generate a deployment report that provides information about configured  Web applications, Web servers, databases, and data directories used by EPM System. This report can help you troubleshoot issues that might arise in your deployment.

To generate a deployment report:
a)  Open a command line window and navigate to EPM_ORACLE_INSTANCE.
b)  Run the command epmsys_registry report deployment.
By default, the report is saved as EPM_ORACLE_INSTANCE/diagnostics/reports/deployment_report.html.

image

See the link to get the detailed sample deployment report. EPM 11.1.2.2 Deployment Topology Report

5) Oracle Enterprise Manager Fusion Middleware Control can be used to manage the WebLogic domain. You can use this embedded Enterprise Manager to manage all the Java Web applications in EPM System out of the box. The full version of Oracle Enterprise Manager with Grid Control adds functionality on top of the Fusion Middleware Control, including historical information of the metrics.
a) Status of the servers and Web applications running
b) Servers the Web applications are running on and the ports they are listening on
c) Health and performance of Java Web applications and managed servers

To launch Enterprise Manager - http://WebLogicAdminServerHost:port/em.

image

6) The EPM System Media pack on Oracle Software Delivery Cloud has been simplified.Software downloads have been merged together.

image

7) Installation of Oracle HTTP Server is now optional. If you choose not to install Oracle HTTP Server, for example in a development environment, Oracle Hyperion Enterprise Performance Management System Installer installs an embedded WebLogic HTTP Server as part of Oracle Hyperion Foundation Services that acts as a proxy server. In a production environment, Oracle recommends that you install Oracle HTTP Server for use with Oracle WebLogic Server or IBM HTTP Server for use with WebSphere. You can also install and manually configure Apache HTTP Server with WebLogic Server.

8) Microsoft Windows Installer (MSI) Client Installers are now provided for Oracle Essbase Client, Oracle Essbase Administration Services Console, Oracle Essbase Studio Console, and Oracle Hyperion Financial Management Client.

image

9) The Oracle Hyperion Financial Reporting Print Server is now part of the Financial Reporting Web application. You no longer have to install the Print Server as part of the Financial Reporting Studio installation, and you no longer need Microsoft Office on the Print Server.

10) You can now deploy EPM System Web applications to a single managed server (compactserver) in Development, Test, and Production environments. This reduces the overall memory requirement of EPM System and reduces startup time.

This is really helpful in setting epm system in Virtual Mechines for POC or feasibility study. Any how we will do standard deployment as what we do in 11.1.2.1 for the standard Dev/QA/Prod environments.

See the below snapshot showing all application deployed to the single JVM running on 9000 port. Non Java applications like Essbase server, Essbase studio server, OHS and Reporting and Analysis Core services are exception.

image

See the shared services and Planning running on the same port 9000.

image

image

 

11) Online Help content for EPM System products is served from a central Oracle download location, which reduces the download and installation time for EPM System. You can also install and configure online Help to run locally.

Will discuss about the new things on application basis in the next articles. Thanks.

Regards,

Srinivas Bobbala.

EPM Deployment Topology Report (Release 11.1.2.2)

 

Logical Web Addresses

A Logical Web Address (LWA) is the address for the load balancer/web server that is used for server to server HTTP communication. Under standard deployment there is only one LWA address for a deployment.
      http://hypadmin-4f9a19:9000
                Calculation Manager Web Application
                Essbase Administration Services Web Application
                Essbase Provider Services Web Application
                Financial Reporting Web Application
                Planning Web Application
                Reporting & Analysis Web Application
                Shared Services Web Application
                Web Analysis Web Application
                Workspace Web Application

Application Tier Components

This section lists the components configured for each EPM Instance in this deployment. It lists the following attributes for different kind of components.

    Weblogic Deployed Components: Weblogic - <Domain> - <Managed Server>:<port> - <Java Web Application>
    Websphere Deployed Components: Websphere - <Profile> - <Server>:<Port> - <Java Web Application>
    IIS Deployed Components: IIS - <Port> - <IIS Web Application>
    Financial Management Servers: Financial Management Server - DCOM Ports - (<List of clusters this server is part of>)
    Essbase Servers: Essbase - <Cluster Name> - <Server Name>:<port>
    Native Components: <Component Name> - <Port> - <Component Information>

      hypadmin-4f9a19 (epmsystem1 - Windows 2003 - 4GB)
                Essbase - EssbaseCluster-1 - Essbase1:1423
                Essbase Studio Server - 9080
                OHS - 19000
                Reporting & Analysis Service - 6800 - GSM
                Weblogic - EPMSystem - AdminServer:7001 - Console
                Weblogic - EPMSystem - EPMServer0:9000 - Calculation Manager Web Application
                Weblogic - EPMSystem - EPMServer0:9000 - Essbase Administration Services Web Application
                Weblogic - EPMSystem - EPMServer0:9000 - Essbase Provider Services Web Application
                Weblogic - EPMSystem - EPMServer0:9000 - Financial Reporting Web Application
                Weblogic - EPMSystem - EPMServer0:9000 - Planning Web Application
                Weblogic - EPMSystem - EPMServer0:9000 - Reporting & Analysis Web Application
                Weblogic - EPMSystem - EPMServer0:9000 - Shared Services Web Application
                Weblogic - EPMSystem - EPMServer0:9000 - Web Analysis Web Application
                Weblogic - EPMSystem - EPMServer0:9000 - Workspace Web Application

Database Connections

This section lists all the products and the database connection for their relational repository.
      HSS@hypadmin-4f9a19:1521/EPMS (Oracle)
                Calculation Manager
                Essbase
                Financial Reporting
                Planning
                Reporting & Analysis
                Shared Services
                Web Analysis

User Directories - SSO Not Enabled

This section lists all the user directories in the correct search order defined in Shared Services. The SSO mode and SSO Header value are shown in the title.
      Native - Native Directory

Data Directories

On a clustered deployment, the following directories need to be on a shared file system.
      Essbase ARBORPATH (EssbaseCluster-1)
                C:\Oracle\Middleware\user_projects\epmsystem1\EssbaseServer\essbaseserver1
      Reporting & Analysis Framework Repository
                C:\Oracle\Middleware\user_projects\epmsystem1\ReportingAnalysis\data\RM1
      Shared Services LCM Export-Import Location
                C:\Oracle\Middleware\user_projects\epmsystem1/import_export

EPM Deployment History Report (11.1.2.2)

hypadmin-4f9a19 - 05/17/2012
This table lists configuration history of activities on the specified date and server combination.
Start Time     Duration     Action     Component     Comment
13:20     00:00     Start     EPM Configurator    
13:25     00:00     Configure     Hyperion Foundation    
13:25     00:00     Configure Common Settings     Hyperion Foundation    
13:25     01:01     Configure Oracle Configuration Manager     Hyperion Foundation    
13:26     00:08     Configure Database     Hyperion Foundation    
13:26     00:00     Configure     Provider Services    
13:26     00:28     Configure     Essbase Studio    
13:27     00:00     Register with Shared Services     Essbase Studio    
13:27     00:04     Configure Database     Essbase Studio    
13:27     00:00     Configure     Calculation Manager    
13:27     00:00     Register with Shared Services     Calculation Manager    
13:27     00:03     Configure Database     Calculation Manager    
13:27     00:00     Register with Shared Services     Essbase Administration Services    
13:27     00:00     Configure Database     Essbase Administration Services    
13:27     00:17     Configure     Essbase Integration Services    
13:28     00:17     Configure Essbase Integration Services     Essbase Integration Services    
13:28     00:20     Configure     Essbase    
13:28     00:00     Register with Shared Services     Essbase    
13:28     00:02     Configure     Planning    
13:28     00:00     Register with Shared Services     Planning    
13:28     00:02     Configure Database     Planning    
13:29     00:47     Configure     Reporting and Analysis    
13:29     00:00     Register with Shared Services     Reporting and Analysis    
13:29     00:28     Configure Database     Reporting and Analysis    
13:30     00:30     Configure Framework Services     Reporting and Analysis    
13:30     00:00     Configure Database     Financial Reporting    
13:30     00:00     Configure Financial Reporting RMI Ports     Financial Reporting    
13:30     00:00     Configure     Financial Reporting    
13:30     10:38     Deploy to Application Server     Shared Services Web Application    
13:41     00:00     Deploy to Application Server     Essbase Provider Services Web Application    
13:41     00:00     Deploy to Application Server     Calculation Manager Web Application    
13:41     00:00     Deploy to Application Server     Planning Web Application    
13:41     00:00     Deploy to Application Server     Web Analysis Web Application    
13:41     00:00     Deploy to Application Server     Essbase Administration Services Web Application    
13:41     00:00     Deploy to Application Server     Reporting & Analysis Web Application    
13:41     00:00     Deploy to Application Server     Financial Reporting Web Application    
13:41     00:00     Deploy to Application Server     Workspace Web Application    
13:41     00:20     Configure Essbase Server     Essbase    
13:41     00:02     Processing Re-registration Script     Reporting and Analysis    
13:42     08:06     Configure Web Server     Hyperion Foundation    

05/20/2012 16:17:54