By Olivier Bennardo-Oracle on Apr 06, 2016
The document describes the steps to configure Hyperion Financial Management with OBIEE 12c. Hyperion Financial Management can be used as a data source in OBIEE 12c.
This is the third post on Oracle EPM System Architecture. It will cover all Financial Performance Management Applications, namely Financial Management, Essbase Analytics Link, Planning, Profitability and Cost Management, Strategic Finance and Disclosure Management. Please be aware of the fact that I also updated the previous posts on Foundation and Reporting and Analysis based on the feedback I got so far.
Configurable Dimension allows the HFM administrator to set the number of custom dimensions in the application. For each dimension it is possible to set the size of the dimension and give a short name and a long name (alias).[Read More]
With the release of HFM 18.104.22.168.000, the Rules Editor is no longer available. Per the readme file (http://docs.oracle.com/cd/E17236_01/epm.1112/hfm_1112200_readme.pdf), you will need to download and install Notepad++, which is a free product.[Read More]
Financial Management is installed in an environment using two or more web servers and a load balancer is used to distribute user request across the web servers. The following errors occur in the web client:
Microsoft VBScript runtime error '800a01a8'
/hfm/data/webformgenerated.asp, line 48
Error description: Object required
Error source: Microsoft VBScript runtime error
Page On which Error Occured: /hfm/DocMgr/OpenItem.asp
Make sure IIS logging is configured to log include "Cookies". You can check this as follows:[Read More]
The following housekeeping practices are recommended when using Oracle / SQL Server databases with Financial Management:
· For HFM tables <appname>_DATA_AUDIT, <appname>_TASK_AUDIT and HFM_ERRORLOG, it is recommended to implement the following housekeeping best practices:
o Quarterly - Business to review the Audit logs, archive and delete.
o Half-Yearly - Archive System Messages and truncate table.
Tip: Put alerts in place so that action can be taken if these tables grow beyond the recommended number of records (> 500,000). Note large audit tables will have severe impact on HFM performance.
Over time, updates and deletes on objects within a tablespace can create pockets of empty space that individually are not large enough to be reused for new data. This type of empty space is referred to as fragmented free space. Objects with fragmented free space can result in much wasted space, and can impact database performance. HFM consolidation performs extensive updates, inserts, and deletes, so it is very important to monitor the fragmentation of tablespaces and defragment them regularly. The preferred way to defragment and reclaim this space is to perform an online segment shrink. For more information about how to use online segment, refer to Oracle Database Administrator’s Guide.
A blog focused on Tips & Tricks about Oracle Business Intelligence (OBI), Oracle Exalytics and Oracle Enterprise Performance Management (EPM) products.
[Blog Admin: Ahmed Awan] Please note the CEAL blog posts are for information and demonstration purposes only and are not official documentation or supported by Oracle Support.