Pages

Wednesday, August 20, 2014

Essbase internals part-2

What are  these  files and  when  will these  extension create

In  Essbase for  BSO application everything  in dense  and  sparse.
If there are  any new updation automatically while  refresh outline  based  on  different outline refresh methods.



ess00001.inn
ess00001.pan
db.otn
db.tcu
db.esn
----------------------

Thursday, July 03, 2014

Patch part 2

Patch apply process for any version .

Following are the  prerequisites  for patch  apply  process.

  1. Updated VC 2005 redistributable available in patch server.
  2. User applying the patch should be the user who was set up to install and configure EPM System products. 
  3. Patch pre-requisites patches  ( there are few patches which require a required path applyied on system then only current patch applied properly).
  4. Interim initial patch must be applied to server.
  5. Patches to be applied by requested oracle on recommendations.
  6. EPM_MIDDLEWARE_HOME to be set, this path is as follows < $HOME/Oracle/Middleware/EPMSystem11R1>
  7. MIDDLEWARE_HOME is to be set for  java  location default location is  <C:\Oracle\Middleware>

Patch applied based on read me provided along with patch, after patch downloaded  to server patch must be unzipped  to  opatch location.The  default location for opatch is  .
After patch download unzip and place in opatch folder.In  my case patch number ""17529887" and  applying to 11.1.2.3.0   and  patch  version is 11.1.2.3.500.XX

after  unzip patch  rename it  to 17529887 remove "_WINX64" because  oracle  patch  command  will not  recognize these wordings.

Before applying interim patch check for inventory to find any patches exist in current system.
command for  inventory is  

opatch.bat lsinventory -oh -jdk \jdk160_35





Monday, May 19, 2014

Patch part1


Patches are the bug fix for for a particular products provided by oracle with different numbering.

Patch's are applied to below products based on bug/ issue  nature, some times this  patches are  not  a  single it may include with another patch (Sequence or Interim) set

Normally  patches are applied to the below specified modules and extended to this new version(11.1.2.2.xxx onward) Hyperion having ADF patches.

  • Calculation Manager
  • Enterprise Performance Management Architect (EPMA)
  • Financial Data Quality Management (FDM)
  • Hyperion Financial Management (HFM)
  • Financial Reporting (HFR)
  • Hyperion Data Relationship Management (DRM)
  • Hyperion Financial Close Management (FCM)
  • Hyperion Profitability and Cost Management (HPCM)  
  • Hyperion Strategic Finance (HSF)
  • Hyperion Crystal Ball
  • Hyperion Interactive Reporting
  • Hyperion Planning
  • Reporting and Analysis framework
  • Hyperion Foundation services
  • Hyperion Provider  services