Hyperion

What is Oracle Hyperion Enterprise?

Oracle Hyperion Enterprise is a proven packaged application that improves departmental financial consolidation and reporting efficiency by streamlining the collection, consolidation, and reporting of financial results in a global environment. With Hyperion Enterprise, you will be able to reduce your financial close cycle, improve the quality of financial information, and enhance decision-making.
Hyperion Enterprise can be distributed and installed at remote offices quickly and easily, and can be fully deployed by the finance organization with minimal information technology support.
Primary components of Hyperion products:-
 1. Oracle's Hyperion® Foundation Services
2. Oracle's Hyperion® Essbase - System 9
3. Oracle's Hyperion® Reporting and Analysis – System 9
4. Oracle's Hyperion® Financial Performance Management Applications
5. Data Management
Hyperion Product Components



Note: Oracle's Hyperion® Workspace is the Web client for Reporting and Analysis, Planning, and Financial Management and is part of the Reporting and Analysis installation. Oracle's Enterprise Performance Management Architect is part of the Financial Management and Planning installations.
What's new feature in Release 6.5.1

 Hyperion Enterprise Extraction Utility - This utility allows you to extract metadata, account lists, entity lists, journals, data and logic from Hyperion Enterprise for import into other consolidation products. In this release, you'll be able to extract the Hyperion Enterprise application into a format that can be utilized by Oracle’s Hyperion Financial Management.
 Hyperion Enterprise Data Drill-back to FDM - This feature enables you to view details of the imported FDM data. You can drill down from a Hyperion Enterprise database cell or the Hyperion Enterprise web data grid to Oracle Hyperion Financial Data Quality Management, Fusion Edition to view details of the data source.
 Server Administration Utility - Enhancements include the ability to change the <application>.ini settings, the ability to change the FDM settings that allow users to view details of the imported FDM data and the ability to move server information previously stored in the Hscrctrl.dat file to the HEServers.xml files used in the 6.5.1 release.
 Application Backup and Restore Utility - A variety of enhancements have been included with the Application Backup and Restore Utility. Enhancements include launching the Application Backup utility from the Windows Start Menu, specifying a preferred location to restore backup applications and the ability to delete backup profiles. Additionally, the backup feature is now included in AutoPilot.
 Hyperion Enterprise Messaging Server now supports web messaging.
 Support for the User Account Control Feature (UAC) on the Windows Vista and Windows 2008 operation systems.
 Integration of the Hyperion Enterprise Smart View Office Provider component with the Hyperion Enterprise Installer.

Hyperion Enterprise Performance Management System Downloads 

Hyperion Foundation Services Downloads


Includes: 
Oracle Hyperion Enterprise Performance Management System Installer, Fusion Edition 
Oracle Hyperion Enterprise Performance Management Architect, Fusion Edition 
Hyperion Shared Services 
Oracle Hyperion Workspace 
Oracle Hyperion Smart View for Office , Fusion Edition 
Oracle Hyperion Calculation Manager 

http://www.oracle.com/technetwork/middleware/performance-management/downloads/hyperion-foundation-1112-086772.html

Installing Oracle Hyperion 11.1.2.2 on Oracle Enterprise Linux


Prerequisites:-

Follow these steps if you would like to install Oracle Hyperion 11.1.2.2 on Oracle Enterprise Linux 6.5:

Update the server yum update && yum upgrade

1. Install Oracle Java

   
 Choose Java SE Development kit 6u45
    Accept License Agreement
    Download jdk-6u45-linux-x64-rpm.bin
    Go to the download directory and run the following commands:
        chmod +x jdk-6u45-linux-x64-rpm.bin
       ./ jdk-6u45-linux-x64-rpm.bin
       alternatives --install /usr/bin/java java /usr/java/latest/jre/bin/java 200000
       alternatives --install /usr/bin/javaws javaws /usr/java/latest/jre/bin/javaws 200000
       alternatives --install /usr/lib64/mozilla/plugins/libjavaplugin.so libjavaplugin.so.x86_64 /usr/java/latest/jre/lib/amd64/libnpjp2.so 200000
       alternatives --install /usr/bin/javac javac /usr/java/latest/bin/javac 200000
       alternatives --install /usr/bin/jar jar /usr/java/latest/bin/jar 200000
    now let’s check the java version by running this command:
        java -version
    result should look like:
        java version “1.6.0_45”
        Java (TM) SE Runtime Environment (build 1.6.0_45-b06)
        Java HotSpot (TM) 64-Bit server VM (build 20.45-b01, mixed mode)

2. Change the limits
  #  vi /etc/security/limits.conf

    add these 2 lines (replace the username with the username you are using to install Hyperion):
        username soft nofile 4096
        username hard nofile 63536

    restart the server 

3. Update the hosts file (this will remove the warning at the first screen of the installation)
    # vi /etc/hosts

    Update the line from
        127.0.0.1      localhost     localhost.localdomain
    to
        127.0.0.1      sujeet.oracle.com sujeet

4. Install the prerequisite packages

    yum install compat-libcap1
    yum install compat-libstdc++-33.i686
    yum install compat-libstdc++-33.x86_64
    yum install libstdc++.i686
    yum install libstdc++-devel libstdc++-devel.i686
    yum install gcc-c++
    yum install libaio-devel
    yum install glibc-devel.i686 glibc.i686
 
5. Disable SeLinux

    nano /etc/selinux/config
    change mode from enforced to disabled

6. Run the install tool from the installation folder



No comments:

ORA-00059: Maximum Number Of DB_FILES Exceeded in 19C database

When I am adding datafile to my 19C database facing the below error. SQL> alter tablespace DATA  add datafile '/u01/data/data15.dbf...