Wednesday, January 18, 2012

Hyperion Enterprise Performance Management Architect (EPMA) Failover Support


Hyperion Enterprise Performance Management Architect (EPMA) Failover Support [ID 1313265.1]

Modified 10-MAY-2011 Type WHITE PAPER Status PUBLISHED

In this Document
Abstract
Document History
Hyperion Enterprise Performance Management Architect (EPMA) Failover Support


Applies to:

Hyperion Planning - Version: 11.1.2.0.00 to 11.1.2.0.00 - Release: 11.1 to 11.1
Hyperion Essbase - Version: 11.1.2.0.00 to 11.1.2.0.00 [Release: 11.1 to 11.1]
Hyperion Profitability - Version: 11.1.2.0.00 to 11.1.2.0.00 [Release: 11.1 to 11.1]
Hyperion Financial Management - Version: 11.1.2.0.00 to 11.1.2.0.00 [Release: 11.1 to 11.1]
Information in this document applies to any platform.

Abstract

This article contains sample scripts for clustering Performance Management Architect Dimension Server for failover in an active-passive configuration. Please refer to the 11.1.2 Oracle Hyperion Enterprise Performance Management System High Availability and Disaster Recovery Guide for details on how to configure EPMA dimension server for failover. Please note that the scripts are just a sample and need to be modified for the target environment.

Document History

Author:
Create Date 13-Apr-2011
Update Date 13-Apr-2012
Expire Date 13-Apr-2013 (ignore after this date)

Hyperion Enterprise Performance Management Architect (EPMA) Failover Support

The information and scripts are attached to this article.

Show Attachments Attachments

Show Related Information Related


Products
  • Middleware > Enterprise Performance Management > Planning > Hyperion Planning
  • Middleware > Enterprise Performance Management > Essbase > Hyperion Essbase
  • Middleware > Enterprise Performance Management > Profitability > Hyperion Profitability
  • Middleware > Enterprise Performance Management > Financial Management > Hyperion Financial Management
Keywords
ENTERPRISE PERFORMANCE MANAGEMENT; EPMA; FAILOVER

Back to topBack to top

Utilities for Troubleshooting Oracle Hyperion Enterprise Performance Management 11.1.2.0 or 11.1.2.1


Utilities for Troubleshooting Oracle Hyperion Enterprise Performance Management 11.1.2.0 or 11.1.2.1 [ID 1303200.1]

Modified 18-JAN-2012 Type HOWTO Status PUBLISHED

In this Document
Goal
Solution
References


Applies to:

Hyperion Essbase - Version: 11.1.2.1.000 and later [Release: 11.1 and later ]
Hyperion BI+ - Version: 11.1.2.0.00 to 11.1.2.1.000 [Release: 11.1 to 11.1]
Hyperion Planning - Version: 11.1.2.0.00 to 11.1.2.1.000 [Release: 11.1 to 11.1]
Hyperion Financial Management - Version: 11.1.2.0.00 to 11.1.2.1.000 [Release: 11.1 to 11.1]
Hyperion BI+ - Version: 11.1.2.0.00 to 11.1.2.1.000 [Release: 11.1 to 11.1]
Information in this document applies to any platform.
(1) \Oracle\Middleware\user_projects\epmsystem1\bin\ziplogs.bat|.sh
(2) \Oracle\Middleware\ohs\ccr\bin\
(3) \Oracle\Middleware\ohs\rda\rda.cmd
(4) \Oracle\Middleware\user_projects\epmsystem1\bin\epmsys_registry.bat|.sh
(5) \Oracle\Middleware\user_projects\epmsystem1\bin\validate.bat

Goal

This article aims to help users use various troubleshooting tools to validate or troubleshoot an installation of Oracle EPM 11.1.2.0. or 11.1.2.1

Solution

(1) A new troubleshooting tool introduced in Oracle EPM 11.1.2.1 is \Oracle\Middleware\user_projects\epmsystem1\bin\ziplogs.bat|.sh file. The output of this is generated in \Oracle\Middleware\user_projects\epmsystem1\diagnostics\ziplogs\EPM_logs__11.1.2.1.0.zip

(2) Oracle Configuration Manager (OCM) is an advanced tool which collects and evaluates settings from configuration files (but not Hyperion Registry) and stores them in a central database administered by Oracle. It was first introduced into EPM in version 11.1.2.0

(3) Remote Desktop Assistant (RDA) collects and zips up a large amount of information concerning the software and hardware environments of Oracle products. If Perl 5.005 or later is installed on the computer and accessible from the command line (test: perl -version), then run: \Oracle\Middleware\ohs\rda\perl rda.pl from the command line to access the RDA tool. Alternately, precompiled RDA executables are available for several platforms (rda.cmd, rda.sh, rda.bat). View an RDA webcast from the https://oracleaw.webex.com reference site listed below.

(4) Configuration settings have been moved from configuration files to a database repository associated with Shared Services. These may be extracted to an HTML formatted file by running \Oracle\Middleware\user_projects\epmsystem1\bin\epmsys_registry.bat|.sh without parameters from the command line. The output is generated to file \Oracle\Middleware\user_projects\epmsystem1\diagnostics\reports\registry.html The username/login/jdbc URL for the Hyperion/HSS registry are kept in \Oracle\Middleware\user_projects\epmsystem1\config\foundation\11.1.2.0\reg.properties file.

(5) A much enhanced validation tool is available in \Oracle\Middleware\user_projects\epmsystem1\bin\validate.bat. In EPM 11.1.2.1 the output files are of the form \Oracle\Middleware\user_projects\epmsystem1\diagnostics\reports\instance_report_20YYMMDD_######.html (where YY is the year, MM is the month, DD is the day, and ###### is a unique integer). It also runs the tool under (1) and gives the output of that tool.

(6) Individual log files may be found in subdirectories under (those 'starred' are not collected by ziplogs):
\Oracle\Middleware\user_projects\domains\EPMSystem\servers\\logs *
\Oracle\Middleware\logs *
\Oracle\Middleware\wlserver_10.3 *
\Oracle\Middleware\user_projects\epmsystem1\tmp *
\Oracle\Middleware\ohs\cfgtoollogs\opatch *
\Oracle\Middleware\EPMSystem11R1\diagnostics\logs
\Oracle\Middleware\user_projects\epmsystem1\diagnostics\logs\
\Program Files\Oracle\Inventory\logs
C:\Users\\Oracle\oradiag_\diag\
C:\Users\\.oracle\logs\

(7) Some debug tools (*) can be activated if under http://:19000/workspace/index.jsp > Navigate > Administration > Workspace Server Settings > Client Debug Enabled: is set to Yes (then click 'OK' button, close all browser windows, and restart browser).
* http://hostname:19000/workspace/debug/configInfo.jsp
* http://hostname:19000/workspace/debug/userInfo.jsp
* http://hostname:19000/workspace/debug/userGroupQuery.jsp


Other tools are available at these URLs (largely derived from validate.bat output). A non-Error response indicates that the web service of each particular application is active.:
http://hostname:19000/workspace/status
http://hostname:19000/workspace/BPMContext
http://hostname:8600/mappingtool/faces/info.jspx
http://hostname:10080/easconsole/console.html
http://hostname:16000/WebAnalysis
http://hostname:6373/oracle-epm-fm-webservices/ApplicationService
http://hostname:8300/HyperionPlanning/
http://hostname:13080/aps/APS
http://hostname:8200/hr/status.jsp
http://hostname:19091/awb/conf/AwbConfig.xml
http://hostname:8500/calcmgr/index.htm

(8) Enterprise Manager is the standard Oracle graphic user interface debugging and configuration tool. Although advanced versions require extra cost licensing, there is a bundled version of Enterprise Manager available with EPM. Research the product starting with KM article 1302746.1. It is hoped that ECID (Execution Context ID) functionality will be widely incorporated with the 'Hyperion' product stack in EPM version 11.1.2.2.

Platform Desupport Notice Affecting EPM System Releases Beginning with Release 11.1.2


Platform Desupport Notice Affecting EPM System Releases Beginning with Release 11.1.2 1

Modified 05-NOV-2010 Type ANNOUNCEMENT Status PUBLISHED

In this Document
What is being announced?


Applies to:

Oracle Crystal Ball - Version: 11.1.1.0.00 to 11.1.1.3.00 - Release: 11.1 to 11.1
Hyperion Data Integration Management - Version: 11.1.1.0.00 to 11.1.1.1.00 [Release: 11.1 to 11.1]
Hyperion Strategic Finance - Version: 11.1.1.1.00 to 11.1.1.3.00 [Release: 11.1 to 11.1]
Hyperion Data Relationship Management - Version: 11.1.1.0.00 to 11.1.1.3.00 [Release: 11.1 to 11.1]
Hyperion Financial Data Quality Management - Version: 11.1.1.0.00 to 11.1.1.3.00 [Release: 11.1 to 11.1]
Information in this document applies to any platform.

What is being announced?

The following platform components will no longer be supported by Oracle Hyperion Enterprise Performance Management System subsequent to release 11.1.1.x. (Note: Not all individual Oracle Hyperion Enterprise Performance Management System release 11.1.1.x products are supported all platforms. For specific details, please refer to the applicableCertification Matrix.). Please refer to the Products section below for a full list of the affected Products.

SERVER OPERATING SYSTEMS
POWER AIX 5.2
PA-RISC HP-UX 11i (11.23)
Itanium-2 Windows 2003 SP1, Server Enterprise Edition for Itanium-based Systems

DATABASES (Repositories and Data Sources)
Oracle Database 10.1
IBM DB2 8.2 through 9.2
Microsoft SQL Server 2000

DATABASES (Data Sources only)
IBM DB2 7x for z/OS
Teradata (ODBC) V2R6.0.x
Teradata (ODBC) V2R5.1.x

WEB APPLICATION SERVERS
Oracle WebLogic Server 9.2
Oracle Application Server (all releases)
IBM WebSphere Application Server and IBM HTTP Server will not supported with the next release.

IDENTITY MANAGEMENT
Oracle Directory Services
- Oracle Virtual Directory 10.1.4.0.1
Access Management
- Oracle Access Manager 10.1.4.0.1
Oracle Identity Manager 10.1.4.0.1 and higher
Microsoft Active Directory 2000
IBM Tivoli Directory Server 6.1
Sun ONE LDAP 5.2

OTHER CLIENT SOFTWARE
Internet Explorer 6
Firefox 2

Where are Application Install Inventories Stored in Oracle EPM 11.1.2.1


Where are Application Install Inventories Stored in Oracle EPM 11.1.2.1 [ID 1304532.1]



Applies to:

Hyperion BI+ - Version: 11.1.2.1.000 and later [Release: 11.1 and later ]
Hyperion Essbase - Version: 11.1.2.0.00 to 11.1.2.1.000 [Release: 11.1 to 11.1]
Hyperion Planning - Version: 11.1.2.0.00 to 11.1.2.1.000 [Release: 11.1 to 11.1]
Information in this document applies to any platform.

Goal

Identify the location of software inventories associated with Oracle EPM 11.1.2.1.

Solution

It is important to know where installation inventory lists are stored: to detect the completeness of an install, to determine whether a patch has been applied, or to delete as part of a reinstall.
  • \Oracle\Middleware\EPMSystem11R1\oraInst.loc points to the location of the central inventory. oraInst.loc may have been installed in a previous Oracle install on Unix in: /var/opt/oracle or /etc or $HOME (of the user installing Oracle software), preventing the 'reinstall' of OHS or other software.

  • \Program Files\Oracle\Inventory is typically the location of the central inventory (despite the name 'central inventory', there may exist mutually exclusive inventories generated with the install of other Oracle products). On Unix/Linux the central inventory is in the installer's 'home' directory.

  • A local inventory is typically found in \Oracle\Middleware\EPMSystem11R1\.oracle.products

  • A local pointer (.oracle.instances) to the instance(s) set by EPM 11.1.2.0 and EPM 11.1.2.1 (and referenced by EPM 11.1.2.1 Installer for 'Apply Maintenance Release' option) is put in C:\Users\\ Ensure the same user installs both versions.

  • \Oracle\Middleware\EPMSystem11R1\.oracle.products is used to recreate an inventory if need be (but a regeneration of an inventory will exclude service fixes/patches installed via OPatch. To recreate an inventory after one is corrupted...run \Oracle\Middleware\EPMSystem11R1\OPatch\createInventory.bat.)

  • \Oracle\Middleware\ohs\.patch_storage (holds records of previous OPatches)

A Unique Instance Name Is Required When Configuring A New Install Of EPM 11.1.2.1 In Distributed Environment


A Unique Instance Name Is Required When Configuring A New Install Of EPM 11.1.2.1 In Distributed Environment [ID 1317679.1]

Applies to:

Hyperion Financial Management - Version: 11.1.2.1.000 and later [Release: 11.1 and later ]
Hyperion Planning - Version: 11.1.2.1.000 and later [Release: 11.1 and later]
Hyperion Profitability - Version: 11.1.2.1.000 and later [Release: 11.1 and later]
Hyperion Strategic Finance - Version: 11.1.2.1.000 and later [Release: 11.1 and later]
Hyperion Financial Data Quality Management - Version: 11.1.2.1.000 and later [Release: 11.1 and later]
Information in this document applies to any platform.

Goal

To install and configure Oracle EPM 11.1.2.1 in a distributed environment with a proper Instance name on each server

Solution

When configuring EPM 11.1.2.1 in a distributed environment, it is necessary to supply a new, unique Instance name on each server.

For example.

If using the default Instance name 'epmsystem1' on the first server, if you keep the same naming convention on subsequent servers, you will need to supply new, unique Instance names such as epmsystem2, epmsystem3, etc.

During Configuration each instance gets written to the EPM System Registry and the EPM System Configurator verifies that each instance name is unique. If you fail to provide a new unique instance name during the configuration process you will receive a message stating that the instance name is not valid. You will be forced to go back and enter a unique instance name.

Note: If you are applying the maintenance release (11.1.2 to 11.1.2.1), during the configuration process you select the first option "Modify existing instance" since the epmsystem1 instance name already exists and is shared by all servers in the distributed environment. Be sure not to delete or change the instance names during a maintenance release configuration as it will cause the configuration to change from a maintenance install to a new installation and will cause issues with the rest of the server deployments in the distributed environment.


Sunday, January 15, 2012

Shared Application File System in R12 and 11i

Shared Application File System in R12 and 11i


E-Business suites (EBS) 11i and R12 both support the sharing of the Applications Tier File System. Sharing a file system in EBS involves sharing a volume between 2 or more physical servers. In a shared Application Tier File System (ATFS) implementation, the application services can be configured to run (utilize CPU and memory) on any server sharing the ATFS simply by changing some context file variables via OAM, running Autoconfig and restarting the services. This process is detailed in the following notes:

R12: Note.384248.1: Sharing the Application Tier File System in Oracle E-Business Suite Release 12
11i: Note.233428.1: Sharing the Application Tier File System in Oracle Applications 11i

Some key concepts of sharing ATFS:

  • Each server sharing the ATFS will have its own context file
  • Certain context file variables dictate which application services start and run on which server(s)
  • Certain context file variables dictate how AD Utilities will behave on each server
The Unified Applications Tier File System (UATFS)
The term "Unified Applications Tier File System" (UATFS) came along with R12 as a new feature. Oracle Development decided it would be beneficial to always install all the files needed on every server in a given R12 installation, even if the server was only to host some of the Application services. Even though this term was coined for an R12 feature, it still applies to some 11i file systems. A Unified Applications File System essentially means that the file system contains all the files required to support all 4 base service groups in E-Business Suite:
  • Web
  • Forms
  • Admin (Not a true process or service as the other 3 are. The "admin" component dictates which server administers the application database objects and therefore has the needed files for that task.)
  • Concurrent Processing (Reports)
Again, all versions of R12 are always installed with UATFS as delivered by Rapid Install. However in 11i only single node-installations are unified at install time. In 11i in order to achieve a unified file system from a multi-node installation, a merge of the file systems must be performed. This is the only supported manner in which to achieve a unified file system from an installation which was originally multi-node. APPL_TOP Merging in 11i is accomplished by Note 233428.1, Section 4, "Merging existing APPL_TOPs into a single APPL_TOP". Because R12 is always unified there is not an APPL_TOP merge process in R12.
Some Non-Typical Scenarios for Shared File Systems in 11i
In 11i it is also possible to share an ATFS even if the file system is not unified or complete; i.e., it only supports 1, 2 or 3 of the 4 core services. For example 11i can have an ATFS which only has the files for Forms and Web. That ATFS can then be shared with another server for Forms / Web services only. The other core services, Admin and Concurrent would then have its own ATFS on another server or servers. This would be done for some advanced topology configurations like load-balancing or perhaps a standby Web / Forms server and would minimize the footprint of the ATFS. Because the ATFS in this example is not unified, the ATFS of the Forms/Web servers could never host the Concurrent Processing or Admin services without first being merged with an ATFS which has the necessary Concurrent Processing and Admin files. So while in 11i it is possible to share a non-unified ATFS, it would not be a typical configuration. A typical configuration is sharing 1 unified ATFS for amongst multiple servers. The advantages of this non-typical example would be:
  • Smaller Footprint for the ATFS on each volume/disk (however the overall combined footprint would be larger)
  • Better performance from the shared volume/disk, as there are 2 instead of 1

The disadvantages would be:
  • Must maintain multiple ATFS's
  • Patches have to be applied multiple times
  • Cloning is more difficult as 2 ATFS's must be cloned
For disk performance reasons, you could implement a similar strategy in R12, for example sharing 2 volumes (VOL1, VOL2) amongst 4 servers: 2 web/forms servers accessing only VOL1 and the 2 CCM/Admin servers accessing only VOL2. Those 2 disks would each have a unified ATFS in R12, where the same configuration in 11i the file systems could be partial or unified.

For more information please refer :

Explanation of Context Variables for Shared Application File System in R12 and 11i [ID 1070152.1]



References
NOTE:233428.1 - Sharing the Application Tier File System in Oracle Applications Release 11i
NOTE:384248.1 - Sharing The Application Tier File System in Oracle E-Business Suite Release 12
NOTE:406558.1 - Configuring Applications Node Services in Oracle E-Business Suite Release 12
NOTE:415385.1 - On a R12 Multi-Node Install -- Why do all Middle Tiers run all Services?

Shared Application File System in R12 and 11i

Shared Application File System in R12 and 11i


E-Business suites (EBS) 11i and R12 both support the sharing of the Applications Tier File System. Sharing a file system in EBS involves sharing a volume between 2 or more physical servers. In a shared Application Tier File System (ATFS) implementation, the application services can be configured to run (utilize CPU and memory) on any server sharing the ATFS simply by changing some context file variables via OAM, running Autoconfig and restarting the services. This process is detailed in the following notes:

R12: Note.384248.1: Sharing the Application Tier File System in Oracle E-Business Suite Release 12
11i: Note.233428.1: Sharing the Application Tier File System in Oracle Applications 11i

Some key concepts of sharing ATFS:

  • Each server sharing the ATFS will have its own context file
  • Certain context file variables dictate which application services start and run on which server(s)
  • Certain context file variables dictate how AD Utilities will behave on each server
The Unified Applications Tier File System (UATFS)
The term "Unified Applications Tier File System" (UATFS) came along with R12 as a new feature. Oracle Development decided it would be beneficial to always install all the files needed on every server in a given R12 installation, even if the server was only to host some of the Application services. Even though this term was coined for an R12 feature, it still applies to some 11i file systems. A Unified Applications File System essentially means that the file system contains all the files required to support all 4 base service groups in E-Business Suite:
  • Web
  • Forms
  • Admin (Not a true process or service as the other 3 are. The "admin" component dictates which server administers the application database objects and therefore has the needed files for that task.)
  • Concurrent Processing (Reports)
Again, all versions of R12 are always installed with UATFS as delivered by Rapid Install. However in 11i only single node-installations are unified at install time. In 11i in order to achieve a unified file system from a multi-node installation, a merge of the file systems must be performed. This is the only supported manner in which to achieve a unified file system from an installation which was originally multi-node. APPL_TOP Merging in 11i is accomplished by Note 233428.1, Section 4, "Merging existing APPL_TOPs into a single APPL_TOP". Because R12 is always unified there is not an APPL_TOP merge process in R12.
Some Non-Typical Scenarios for Shared File Systems in 11i
In 11i it is also possible to share an ATFS even if the file system is not unified or complete; i.e., it only supports 1, 2 or 3 of the 4 core services. For example 11i can have an ATFS which only has the files for Forms and Web. That ATFS can then be shared with another server for Forms / Web services only. The other core services, Admin and Concurrent would then have its own ATFS on another server or servers. This would be done for some advanced topology configurations like load-balancing or perhaps a standby Web / Forms server and would minimize the footprint of the ATFS. Because the ATFS in this example is not unified, the ATFS of the Forms/Web servers could never host the Concurrent Processing or Admin services without first being merged with an ATFS which has the necessary Concurrent Processing and Admin files. So while in 11i it is possible to share a non-unified ATFS, it would not be a typical configuration. A typical configuration is sharing 1 unified ATFS for amongst multiple servers. The advantages of this non-typical example would be:
  • Smaller Footprint for the ATFS on each volume/disk (however the overall combined footprint would be larger)
  • Better performance from the shared volume/disk, as there are 2 instead of 1

The disadvantages would be:
  • Must maintain multiple ATFS's
  • Patches have to be applied multiple times
  • Cloning is more difficult as 2 ATFS's must be cloned
For disk performance reasons, you could implement a similar strategy in R12, for example sharing 2 volumes (VOL1, VOL2) amongst 4 servers: 2 web/forms servers accessing only VOL1 and the 2 CCM/Admin servers accessing only VOL2. Those 2 disks would each have a unified ATFS in R12, where the same configuration in 11i the file systems could be partial or unified.

For more information please refer :

Explanation of Context Variables for Shared Application File System in R12 and 11i [ID 1070152.1]



References
NOTE:233428.1 - Sharing the Application Tier File System in Oracle Applications Release 11i
NOTE:384248.1 - Sharing The Application Tier File System in Oracle E-Business Suite Release 12
NOTE:406558.1 - Configuring Applications Node Services in Oracle E-Business Suite Release 12
NOTE:415385.1 - On a R12 Multi-Node Install -- Why do all Middle Tiers run all Services?

Friday, January 13, 2012

Financial Management Error "Unable to open file" When Previewing Or Printing A System Report [ID 1082720.1]


Financial Management Error "Unable to open file" When Previewing Or Printing A System Report [ID 1082720.1]

Modified 01-SEP-2011 Type PROBLEM Status PUBLISHED

In this Document
Symptoms
Cause
Solution


Symptoms

Previewing or printing Hyperion Financial Management (HFM) system reports returns error like this:

Unable to open file D:\Hyperion\products\FinancialManagement\Web\HFM\FileTransfer\{436ECBC0-5060-4B69-B599-1D481A5D5A86}.FTR\ICPReport2_867826759.
Show Details:
Error Reference Number: {E37C98DA-6D0D-4459-A7FF-1D41440AAEA9};User Name: admin@Native Directory
Num: 0x80040237;Type: 1;DTime: 12/2/2009 7:50:14 PM;Svr: ;File: HFMActionsExecution.cpp;Line: 2236;Ver: 11.1.1.2.0.2207;ExErr: It is an error to mix objects from different versions of MSXML.;
Num: 0x80040237;Type: 0;DTime: 12/2/2009 7:50:14 PM;Svr: ;File: HFMActions.cpp;Line: 72;Ver: 11.1.1.2.0.2207;

Cause

Incorrect NTFS permissions on the File Transfer folder will cause this issue. To check NTFS permissions on the File Transfer folder:
  1. On the HFM web server, check the data value of FileTransferFolderPath value in the Windows Registry located:
    HKEY_LOCAL_MACHINE\SOFTWARE\Hyperion Solutions\Hyperion Financial Management\Web
  2. Right-click on the folder found in the above registry in Windows Explorer and select the Security tab.
  3. The following NTFS permissions should be applied for the File Transfer folder:
    • Administrators - Full Control
    • IIS user (usually Internet Guest Account, IUSR_*): Full Control
    • ASP user (usually Launch IIS Process Account, IWAM_*): Full Control.
    • NETWORK SERVICE: Full Control
    • SYSTEM: Full Control.
    • Authenticated Users: Read&Execute, List Folder Contents, Read, Special Permissions
    • For HFM web servers deployed on Windows 2008, group IIS_IUSRS should have assigned Modify permission to the folder

Solution

The recommended way to set permissions is to run the EPM System Configurator on the HFM Web server as follows:
  1. Run the "EPM System Configurator" (accessible at "Start" -> "All Programs" -> "Oracle EPM System" -> "Foundation Services")
  2. Expand "Financial Management"
  3. Check "Configure Web Server"
  4. Complete the deployment process.
If this does not resolve the issue, apply manually required NTFS permissions for the File Transfer Folder (see point 3 in the Cause section above).

Show Related Information Related

How to Reregister an Existing Hyperion Product With Shared Services in Version 11.1.2


How to Reregister an Existing Hyperion Product With Shared Services in Version 11.1.2 [ID 1175663.1]

Modified 25-JUL-2011 Type HOWTO Status PUBLISHED

In this Document
Goal
Solution
References


Applies to:

Hyperion Essbase - Version: 11.1.2.0.00 to 11.1.2.0.00 - Release: 11.1 to 11.1
Information in this document applies to any platform.

Goal

How to re-register an existing Hyperion product such as Essbase, Essbase Administration Services (EAS), with Shared Services in EPM version 11.1.2?

Solution

1. Locate the product_config_#.xml in the directory EPM_ORACLE_INSTANCE/config/foundation/11.1.2.0/product/product_name

For example; the Essbase product file is located in EPM_ORACLE_INSTANCE/config/foundation/11.1.2.0/product/Essbaseserver/11.1.2.0

2. Open the file product_config_#.xml and locate the line:

="hubRegistration">Configured

3. Change the status from Configured to Pending.

4. Rerun 'startconfigtool.bat' or 'startconfigtool.sh' or the EPM System Configurator again and select the product. This enables you to reregister the product with Shared Services

How To Implement Row Level Security in EPM 11.1.1.2.0 [ID 970369.1]


How To Implement Row Level Security in EPM 11.1.1.2.0 [ID 970369.1]

Modified 01-APR-2011 Type HOWTO Status PUBLISHED

In this Document
Goal
Solution


Applies to:

Hyperion BI+ - Version: 11.1.1.2.00 and later [Release: 11.1 and later ]
Information in this document applies to any platform.

Goal

Implement Row Level Security in EPM Interactive Reporting 11.1.1.2.

Solution

A) Set background resources for Row Level Security (RLS)
1. Create a database to hold the RLS tables,
2. Create an ODBC connection to the RLS DataBase using appropriate Merant Wire Protocol for your RDBMS.
3. Create an OCE file with ODBC/ODBC connection types and publish it to the workspace, call it RLS.
4. Open Row_Level_Security.BQY (i.e, for system 9 it’s located in %Hyperion_Home%\BIPlus\docs\en; not bundled with EPM 11.1.1.x) and select the RLS.OCE file created in the previous step and connect to RLS database.
5. If this is the first time to establish a connection to the RLS database you will be asked to create these tables first, click yes.
6. Enter the username and password then on Create, now you should have three tables created in your database:
7. Define the OCE connection in DAS using Local Services Configurator, and then restart all the services.
8. Configure RLS in workspace, Navigate > Administer > Row Level Security, check Enable Row Level Security and enter your details of RLS OCE.
9. Restart all the services to ensure changes take effect

B) Define Users and Groups for RLS
1. Click on Work with Users\Groups button and Create a group called it AMERICAS
2. Create a user called "process" and add it as a member in AMERICAS.
3. Create a user called "process" and in shared services (it’s very important to spell it identically to the user in the RLS tables with the same letter case otherwise RLS will not work).

C) Build your report and publish it to the workspace, edit the permission for this report and grant “Full Access” and “View and Process” permissions for user called “process”.

D) Define Restrictions
1. We need to hide the column called “STORE_KEY” in “SALES_FACT” table to prevent the employess from tying back the sales figures with the stores. We can hide the column by adding a row in BRIOSECR to restrict access for “PUBLIC” group as below:
2. Then override this restriction for “AMERICAS” group by adding a second restriction to the BRIOSECR as below:
3. Now, I f we run the report using “admin” which is not a member of “AMERICAS” group we will not be able to see “STORE_KEY”.
4. If we open the same report using “process” user we will be able to see the values in STORE_KEY
5. Now, we will add another constraint to restrict access of AMERICAS group to Sales amount to the store named ‘BMV Lyon’ and to hide other rows of data. This condition will be applied as an inner join constraint.
6. Run the report again, you get only sales amount of ‘BMV Lyon’ store.

For more information, please refer to IR_user.pdf. This contains the official documentation for Row Level Security. Check Chapter 22 "Row Level Security in Interactive Reporting" page 505.


Show Related Information Related


Products
  • Middleware > Business Intelligence > Hyperion Query & Reporting > Hyperion BI+
Keywords
ROW LEVEL SECURITY; SECURITY

Back to topBack to top

Thursday, January 12, 2012

How to Change IP Address in an Oracle Applications Environment

How to Change IP Address in an Oracle Applications Environment

Print this post

1. Change the IP Address in the Server;

2. Verify the current ip address setup in the Oracle Applications environment. Connect as apps user into SQL*Plus and run:

select NODE_NAME, STATUS, NODE_MODE, NODE_ID,SERVER_ADDRESS, HOST, DOMAIN, WEBHOST, VIRTUAL_IP from fnd_nodes where node_name = upper('hostname');

3. Run the following command to remove the old ip address from the Oracle Applications tables:

perl $AD_TOP/bin/adgentns.pl appspass=apps contextfile=$APPL_TOP/admin/_hostname.xml -removeserver

replace _hostname.xml for the context file name under the $APPL_TOP/admin directory;

then connect to SQL*Plus as apps user and run:

begin
FND_NET_SERVICES.remove_server('', '');
end;
/
commit;
/

replace by the SID of the environment and by the hostname in the environment. Both must be entered in upper case.

4. Run autoconfig to populate the values using the new IP Address.

5. Confirm the ip address has been changed to the new value changed in the step 1:

select NODE_NAME, STATUS, NODE_MODE, NODE_ID,SERVER_ADDRESS, HOST, DOMAIN, WEBHOST, VIRTUAL_IP from fnd_nodes where node_name = upper('hostname');

How to Change IP Address in an Oracle Applications Environment [ID 553318.1]


How to Change IP Address in an Oracle Applications Environment [ID 553318.1]

Modified 25-FEB-2008 Type HOWTO Status MODERATED

In this Document
Goal
Solution


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review.

Applies to:

Application Install - Version: 11.5.9 to 11.5.10
Information in this document applies to any platform.

Goal

How to change the server IP Address in an Oracle Applications environment ?

Solution

1. Change the IP Address in the Server;

2. Verify the current ip address setup in the Oracle Applications environment. Connect as apps user into SQL*Plus and run:

select NODE_NAME, STATUS, NODE_MODE, NODE_ID,SERVER_ADDRESS, HOST, DOMAIN, WEBHOST, VIRTUAL_IP from fnd_nodes where node_name = upper('hostname');

3. Run the following command to remove the old ip address from the Oracle Applications tables:

perl $AD_TOP/bin/adgentns.pl appspass=apps contextfile=$APPL_TOP/admin/_hostname.xml -removeserver

replace _hostname.xml for the context file name under the $APPL_TOP/admin directory;

then connect to SQL*Plus as apps user and run:

begin
FND_NET_SERVICES.remove_server('', '');
end;
/
commit;
/

replace by the SID of the environment and by the hostname in the environment. Both must be entered in upper case.

4. Run autoconfig to populate the values using the new IP Address.

5. Confirm the ip address has been changed to the new value changed in the step 1:

select NODE_NAME, STATUS, NODE_MODE, NODE_ID,SERVER_ADDRESS, HOST, DOMAIN, WEBHOST, VIRTUAL_IP from fnd_nodes where node_name = upper('hostname');




Sunday, January 8, 2012

Oracle Financial Services Analytical Applications (OFSAA) Product Documentation


Oracle Financial Services Analytical Applications (OFSAA)
Product Documentation [ID 1073394.1]

Modified 20-DEC-2011 Type REFERENCE Status PUBLISHED

In this Document
Purpose
Scope
Oracle Financial Services Analytical Applications (OFSAA) Product Documentation


Applies to:

Oracle Financial Services Asset Liability Management - Version: 5.1 and later [Release: 5 and later ]
Oracle Financial Services Profitability Management - Version: 5.1 and later [Release: 5 and later]
Oracle Financial Services Funds Transfer Pricing - Version: 5.1 and later [Release: 5 and later]
Oracle Financial Services Analytical Applications Infrastructure - Version: 7.1 and later [Release: 7 and later]
Oracle Financial Services Profitability Analytics - Version: 5.1 and later [Release: 5 and later]
Information in this document applies to any platform.
OFSAA
OFSAAI

Purpose

Last Update: December 20, 2011

This note provides link to Oracle download site where you can find the latest installation and user guide documents for Oracle Financial Services Analytical Applications product suite.

Click link below to access the documents:
Documentation Library for Oracle's Enterprise Performance Management Suite for Oracle Financial Services Analytical Applications 5.2, Oracle Part Number E26650-01

If you are not directed to the documentation site from link above, please type in the following address to your browser:
http://download.oracle.com/docs/cd/E26650_01/homepage.htm

Scope

The link above include documentation for the following products:

Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Profitability Management (OFSPM)
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Asset Liability Management (ALM)
Oracle Financial Services Balance Sheet Planning (BSP)
Oracle Financial Services Pricing Management, Transfer Pricing Component
Oracle Financial Services Profitability Analytics (PFTBI)
Oracle Financial Services Asset Liability Management Analytics (ALMBI)
Oracle Financial Services Data Warehouse (FSDW)


Oracle Financial Services Analytical Applications (OFSAA) Product Documentation

Oracle Financial Services Analytical Applications documents:

http://download.oracle.com/docs/cd/E26650_01/homepage.htm

Show Attachments Attachments

Show Related Information Related


Products
  • More Applications > Industry Solutions > Financial Services > Oracle Financial Services Asset Liability Management
  • More Applications > Industry Solutions > Financial Services > Oracle Financial Services Profitability Management
  • More Applications > Industry Solutions > Financial Services > Oracle Financial Services Funds Transfer Pricing
  • More Applications > Industry Solutions > Financial Services > Oracle Financial Services Analytical Applications Infrastructure
  • More Applications > Industry Solutions > Financial Services > Oracle Financial Services Profitability Analytics
Keywords
DATA DICTIONARY; DOCUMENTATION; INFRASTRUCTURE; INSTALLATION; OFSAA; OFSAAI; PROFITABILITY; USERS GUIDE

Back to topBack to top