Oracle EPM 11.1.2.2 Architecture

streakgrowlInternet και Εφαρμογές Web

12 Νοε 2013 (πριν από 3 χρόνια και 8 μήνες)

364 εμφανίσεις

Rolta Proprietary & Confidential!
October 22, 2012!
NOTICE:  Proprietary  and  Confiden5al.  This  material  is  proprietary  to  Rolta  and  contains  trade  secret  and  confiden5al  informa5on  which  is  solely  the  property  of  Rolta.  This  material  is  solely  for  
Client's  internal  use.  This  material  shall  not  be  used,  reproduced,  copied,  disclosed,  and  transmiCed,  in  whole  or  in  part,  without  the  express  consent  of  Rolta.  
Oracle EPM 11.1.2.2 Architecture!
Monday, October 12, 2012!
Prepared for:
NEOAUG
!
Rob Donahue
Rolta
rob.donahue@roltasolutions.com

@EPMTechTips
614.937.5428
Rolta Proprietary & Confidential!
October 22, 2012!
2!
Logical Architecture: 9.3.x!
Rolta Proprietary & Confidential!
October 22, 2012!
3!
Logical Architecture: 11.1.1.x!
Rolta Proprietary & Confidential!
October 22, 2012!
4!
Logical Architecture: 11.1.2.1!
Rolta Proprietary & Confidential!
October 22, 2012!
5!
Logical Architecture: 11.1.2.2!
Rolta Proprietary & Confidential!
October 22, 2012!
6!
Application Changes:
New Applications


FCM – Account Reconciliation
Management


HPCM Web Services


HSF (admin/smartview webapp)
Rolta Proprietary & Confidential!
October 22, 2012!
7!
Application Changes



No more Business Rules!


Calc Manager is the only option


A Migration path is available


EPMA is NOT required


No separate FR Print Server


Embedded into FR Web Application


No Windows Requirement


No Ghostscript Requirement


New Planning Interface


Web 2.0 interface using Oracle ADF


Interactive Charts in Webforms


New HFM Interface
l

Web 2.0 interface using Oracle ADF
l

Still requires Windows
Rolta Proprietary & Confidential!
October 22, 2012!
8!
Application Changes: Oracle ADF

l

Oracle Application Development Framework
l

Oracle ADF is based on Model-View-Controller
(MVC) design pattern
l

A typical MVC
application is separated
into
l

Model Layer
l

Handles interaction
with data-sources and
runs the business logic
l

View Layer
l

Handles the
application user
interface
l

Controller
l

Manages the
application flow and
acts as the interface
between the Model
and the View Layers
Rolta Proprietary & Confidential!
October 22, 2012!
9!
Application Changes: Oracle ADF!


Richer,  easier  to  use  UI  allows  easy  adop5on  by  
business  users  


Very  fast  rendering  of  Very  large  Web  Forms  


20K  web  form  
à
 
(55-­‐65)seconds  to  under  10  
second  


Highly  op5mized  network  throughput  for  very  
large  Web  Forms  


2-­‐3  MB  reduced  to  .5  MB  


Need  IE9  or  FF10  to  get  most  op5mal  
performance.  FF  is  preferred.  
Rolta Proprietary & Confidential!
October 22, 2012!
10!
Application Changes: HFM UI!


ADF  Based  UI  –  Web  2.0  style  


New  Web  Form/Grid  Authoring  


POV  management  


Journal  Enhancements  


Process  Control/Ownership  Mgmt  


Administra5on  improvements  


Load/Extract  Behavior  Change  


Open  Mul5ple  applica5ons,  mul5ple  
modules  and  mul5ple  documents  within  a  
module  


Improve  Menu  naviga5on  and  Screen  
layout  


Member  Selector  UI  improvements  


Hierarchical  document  manager  


Legends  
Rolta Proprietary & Confidential!
October 22, 2012!
11!
Application Changes: HFM UI!
11.1.2.1  
Rolta Proprietary & Confidential!
October 22, 2012!
12!
Application Changes: HFM UI!
11.1.2.2  
Rolta Proprietary & Confidential!
October 22, 2012!
13!
Application Changes: Client Installers
!


New  Windows  Client  Installers:  


Essbase  client  (APIs)  


Essbase  studio  console  


Essbase  administra5on  services  console  


HFM  32  bit  and  64  bit    


Smartview  32  bit  and  64  bit  


Other  Exis5ng  Client  Installers  


Excel  Addin  


Offline  Planning    


HSF  client  


FR  Studio  


Ability  to  install  client  tools  from  the  master  installer  
have  been  removed  
Rolta Proprietary & Confidential!
October 22, 2012!
14!
Application Changes:
Certification Changes


New Certifications


WebSphere Support
7.0.0.19+


MS Office 2010 64bit


FireFox 10.x+ and IE9


Upgrade Path from 9.3.3 and 11.1.1.3 and
11.1.1.4


Maintenance Path from 11.1.2.0 and 11.1.2.1


Web Analysis Supports Essbase Failover


Removed Requirement for Setting Database

s
NLS Length Semantics to be Char


FMW Components Require NLS Length
Semantics to be Set to Byte
Rolta Proprietary & Confidential!
October 22, 2012!
15!
Application Changes: Other!


Reduced  eDelivery  Download  Size  from  PS1  


From  11.4  GB  to  7.8  GB  


Reducing  Config  Time  by  the  average  44%  


Reducing  Service  Startup  Time  by  average  of  47%  


Made  Online  Help  Installa5on  Op5onal  


By  default  help  is  served  from  hosted  servers  


Removed  Tier  Panel  Op5on  


Display  Canonical  Hostname  U5lity  


Shows  how  the  Java  resolved  the  host  names  


Part  of  Standard  deployment  process.  
Rolta Proprietary & Confidential!
October 22, 2012!
16!
Installation Changes
!


Ability  to  ‘install  by  5er’  removed  


OHS  is  op5onal  


WebLogic  proxy  servlet  as  alterna5ve  


OHS  is  no  longer  installed  with  Essbase  


HFM  web  applica5ons  are  offered  as  single  
choice  only  and  for  windows  only  


IIS  webapp  


Web  service  


New  ADF  java  web  app  
Rolta Proprietary & Confidential!
October 22, 2012!
17!
Installation Changes: Install by Tier
User is taken through the
current path of

Choose
components individually

.
Rolta Proprietary & Confidential!
October 22, 2012!
18!
Installation Changes: HFM Web App
Note:  HFM  IIS  and  java  
apps  forced  together  
(windows  only  use)  
Rolta Proprietary & Confidential!
October 22, 2012!
19!
Installation Changes: Maintenance
!


Feature  panel  gives  you  NO  selec5vity;  you  
have  to  maintain  all  products  at  once  


Then  configure  them  BEFORE  adding  new  
products/components  
Rolta Proprietary & Confidential!
October 22, 2012!
20!
Configuration Changes:
DB config tasks


Once once for a product


On second and subsequent boxes, the task
should be Green and marked done and no
need to re-run.
Rolta Proprietary & Confidential!
October 22, 2012!
21!
Configuration Changes: Instance Selection
Current
Updated To
No  longer  required  to  have  a  different  
‘epmsystem
N
’  directory  per  server  
Rolta Proprietary & Confidential!
October 22, 2012!
22!
Configuration Changes:
FR RMI Port
!
Rolta Proprietary & Confidential!
October 22, 2012!
23!
Configuration Changes: LCM Working
Directory Configurable


Allows  for  an  alterna5ve  loca5on  
for  LCM  Files  


Such  as  in  a  load  balanced  
environment  
Rolta Proprietary & Confidential!
October 22, 2012!
24!
Configuration Changes: ‘Admin’ User


Can customize the
default ‘admin’
user name and
password


One-time, 1
st
-time
through
configuration


Afterwards,
configure in
Shared Services
UI, even disable
the admin user
Rolta Proprietary & Confidential!
October 22, 2012!
25!
Configuration Changes: HFM


Separate app pools created for main HFM,
SmartView, LCM, and WebServices


Cluster info now stored in HSS registry




Some fields moved around etc


Configure DCOM – no change


Configure Database – no change


Configure Application Server – improved


Configure Application Cluster – improved


Register Application Server / Clusters –
dropped


Configure Web Server – improved


Deploy to Application Server – no change
Rolta Proprietary & Confidential!
October 22, 2012!
26!
Configuration Changes:
R&A Services Clustering


This was supported but ‘broken’ in 11.1.2.1


On the first box execute:


DB config and services config


Configure repository right from start with UNC
path


On the second & subsequent boxes only
execute the services config


DB config should be marked Green and done
already and is not needed to be run a second
time


Go to CMC and configure services.
Rolta Proprietary & Confidential!
October 22, 2012!
27!
Configuration Changes: resetConfigTask Script


<EPM_ORACLE_HOME>/bin


Run to reset a config task in registry, e.g.


resetConfigTask –product <product> -task
<task>


Added to support resetting hidden tasks
like


hubRegistration


preConfiguration


Rolta Proprietary & Confidential!
October 22, 2012!
28!
Deployment Changes: Compact
Deployment!


All Web Applications are deployed to the same Manage Server (JVM)


Compact Deployment is now supported for test and production deployments


It reduces Memory Requirement of the System by up to 5
GB


It also reduces the start up time by over 30 minutes!


Default for new install
HyS9aifWeb.exe
632,140
HyS9aps.exe
550,460
HyS9CALC.exe
500,140
HyS9Disclosure.exe
729,228
HyS9eas.exe
513,220
HyS9EPMADataSynchronizer.exe
543,036
HyS9EPMAWebTier.exe
545,956
HyS9FinancialManagementWebSvcs.exe
596,264
HyS9FoundationServices.exe
604,796
HyS9FRReports.exe
580,356
HyS9HyS9PftWeb.exe
614,344
HyS9Planning.exe
569,240
HyS9RaFramework.exe
632,552
HyS9RaFrameworkAgent.exe
276,144
HyS9WebAnalysis.exe
569,572
java.exe
1,307,048
Rolta Proprietary & Confidential!
October 22, 2012!
29!


Get a top down view of the customer deployment without asking too many questions


Logical Web Address


Application Tier Components


Database Connections


User Directories and SSO Agents


Data Directories


The deployment report is a html report generated by
the epmsys_registry command


Go to <EOI>\bin directory


Run the command epmsys_registry report deployment


The deployment report is placed under the <EOI>
\diagnostics\reports folder
Deployment Changes: Deployment
Report!
Rolta Proprietary & Confidential!
October 22, 2012!
30!
Deployment Changes: Deployment
Report!
Rolta Proprietary & Confidential!
October 22, 2012!
31!
Security Changes!


Overall  security  opera5ons  are  said  to  be  
improved  by  45%  
Rolta Proprietary & Confidential!
October 22, 2012!
32!
Security Changes: Admin User!


Ability  to  change  the  name  of  the  shared  services  
“admin”  at  configura5on  and  administra5on  phases  


To  avoid  collision  with  other  “admin”  in  corporate  directory  


Ability  to  Deac5vate  the  na5ve  “admin”  all  together  


To  use  a  corporate  directory  user  as  an  Admin.  
Rolta Proprietary & Confidential!
October 22, 2012!
33!
Security Changes!


Using  EBS  to  Manage  EPM  Func5onal  Security  


Ability  to  Refresh  the  Cache  Manually  


Suppor5ng  WebLogic  Asserters  


Expands  SSO  Support  


Op5mize  memory  for  Compact  Deployment  


Single  Instance  of  CSS  cache  reduces  memory  
requirement  


Removed  SAP  provider.  


Support  SSO  between  OBIE  into  Essbase  and  
HFM  
Rolta Proprietary & Confidential!
October 22, 2012!
34!
LCM Changes: New Features!


Simplified User Interface


Simplified Migration Definition File


Improved Migration Status Report


ERPI support for LCM


New FR artifacts – Annotations, User POV and batch jobs


New planning artifact – Report Scripts


New R&A LCM option to replace all artifacts or just the newer ones


Application Shell Creation for Classic Applications


LCM Designer Role


List Structure Command


Shared Disk Location
Rolta Proprietary & Confidential!
October 22, 2012!
35!
LCM Changes: Simplified Interface!


1 click export and import once artifacts are chosen


Removed the migration wizard for export and import


Moved all migration options to migration options UI


One click import


Enable LCM administrators to view all exports and not just my exports


Enable repeat exports


Enable full application migrations


For example a planning full application migration involves LCM import of the
following artifacts


Shared Services


Planning


Essbase


Calculation Manager


R&A


Essbase data of planning application
Rolta Proprietary & Confidential!
October 22, 2012!
36!
LCM Changes: Migration options UI


A new UI to set the export and the import
options for all LCM operations.


In Shared Services go to Administration
menu and choose Migration Options
Rolta Proprietary & Confidential!
October 22, 2012!
37!
LCM Changes: Migration options UI


These were shown as Destination
Options in the LCM wizard in older
releases


Organized by Import and Export
operations


Global for all LCM runs within HSS


Options changes take effect as soon
as they are saved. No reboot
required


Advanced – Manual edit of exported
MDF file needed if need to change
options for a particular LCM run
Rolta Proprietary & Confidential!
October 22, 2012!
38!
LCM Changes: New FR artifacts


Annotations, User POV and batch jobs
Rolta Proprietary & Confidential!
October 22, 2012!
39!
LCM Changes: New planning artifact


Report Scripts
Rolta Proprietary & Confidential!
October 22, 2012!
40!
LCM Changes: New R&A LCM option


Found in the Migration Options UI


Replace all artifacts or just the
newer ones


Default is No which is to import all
artifacts contained in the exported
content


Certain system artifacts should not
be migrated in R&A if the target
environment was modified after the
initial LCM import was done


In such cases it is recommended to
switch this flag to Yes to avoid
corruption of system data in R&A

Rolta Proprietary & Confidential!
October 22, 2012!
41!
LCM Changes: Improved Migration Status
Report


Easier to read UI when failures occur
during migration.


More details on what happened and what
action needs to be taken.


More work on improving error logs in PS3.
Rolta Proprietary & Confidential!
October 22, 2012!
42!
LCM Changes: Application Shell Creation
for Classic Applications


During import LCM get the application group and the application names from
the MDF file and check if it exists in the target environment.


If application exists the LCM import will be performed on that app


If application does not exist a new application and application group will
be created and the content imported into the newly created app.


In the case of planning a datasource with the same name as in the
source should be created via the Planning UI.


This applies to Planning, HFM and Essbase. EPMA and Profitability is not
supported.


Creating the application during LCM is highly recommended


Helps preserve the application settings as set in the source env.


The planning options and HFM per file settings are carried over
automatically without having the need for the user to remember the source
application settings.
Rolta Proprietary & Confidential!
October 22, 2012!
43!
LCM Changes: Application Shell Creation
for Classic Applications


The configuration folder
contains the application
properties in Planning, HFM
and Essbase.
Rolta Proprietary & Confidential!
October 22, 2012!
44!
LCM Changes: EPMA Deployment Options


The deployment options in EPMA were
removed in 11.1.2.2 patchset.


The change in behavior


Perform a LCM migration of all EPMA artifacts


Login to EPMA UI (or use the epma batch client
utility) to create the EPMA application (Planning,
HFM or Profitability)


Perform a LCM migration of target application
(Planning, HFM or Profitability) application.


This can be automated in one script by calling the
LCM and the epma batch client utilities.
Rolta Proprietary & Confidential!
October 22, 2012!
45!
Administration Changes: Enterprise
Manager!


The  Enterprise  Manager  console  is  now  
installed  by  default  as  part  of  the  EPM  
installa5on  


This  was  available  in  11.1.2.1  but  had  to  
manually  configured  


Can  view  /  manage  all  WebLogic  processes  
within  a  single  domain  


Cannot  managed  mix  plaporms  
Rolta Proprietary & Confidential!
October 22, 2012!
46!
Launch Using
http://hostname:7001/em

Login using WebLogic Admin
credentials
Administra*on  Changes:  Enterprise  Manager  
Rolta Proprietary & Confidential!
October 22, 2012!
47!
Summary Information about Managed
Servers
Administra*on  Changes:  Enterprise  Manager  
Rolta Proprietary & Confidential!
October 22, 2012!
48!
Summary Information about Web Apps
Administra*on  Changes:  Enterprise  Manager  
Rolta Proprietary & Confidential!
October 22, 2012!
49!
Change Log Levels
Administra*on  Changes:  Enterprise  Manager  
Rolta Proprietary & Confidential!
October 22, 2012!
50!
View Logs
Filter them

Administra*on  Changes:  Enterprise  Manager  
Rolta Proprietary & Confidential!
October 22, 2012!
51!
Performance Summary
Administra*on  Changes:  Enterprise  Manager  
Rolta Proprietary & Confidential!
October 22, 2012!
52!
JVM Performance
Administra*on  Changes:  Enterprise  Manager  
Rolta Proprietary & Confidential!
October 22, 2012!
53!
Manage WebServices
Administra*on  Changes:  Enterprise  Manager  
Rolta Proprietary & Confidential!
October 22, 2012!
54!
Browse and Update MBeans
Administra*on  Changes:  Enterprise  Manager  
Rolta Proprietary & Confidential!
October 22, 2012!
55!
Administra*on  Changes:  Enterprise  Manager  
l

Jrockit Mission
Control



Very useful in
debugging
Performance Issues
Launch using
JROCKIT_HOME
Rolta Proprietary & Confidential!
October 22, 2012!
NOTICE:  Proprietary  and  Confiden5al.  This  material  is  proprietary  to  Rolta  and  contains  trade  secret  and  confiden5al  informa5on  which  is  solely  the  property  of  Rolta.  This  material  is  solely  for  
Client's  internal  use.  This  material  shall  not  be  used,  reproduced,  copied,  disclosed,  and  transmiCed,  in  whole  or  in  part,  without  the  express  consent  of  Rolta.  
Thank You! !
Rob Donahue
Rolta
rob.donahue@roltasolutions.com

@EPMTechTips
614.937.5428