Friday Feb 06, 2015
Tuesday Dec 11, 2012
By Marc Schumacher on Dec 11, 2012
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.
Friday Jul 13, 2012
By User809526-Oracle on Jul 13, 2012
What is Configurable Dimensions?
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]
Tuesday May 22, 2012
By sujata on May 22, 2012
With the release of HFM 126.96.36.199.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]
Tuesday Mar 06, 2012
By Marc Schumacher on Mar 06, 2012
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]
Sunday Aug 14, 2011
By Ahmed Awan-Oracle on Aug 14, 2011
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.
Tuesday Jul 19, 2011
By Ahmed Awan-Oracle on Jul 19, 2011
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]
Popular Whitepaper Downloads
- Financial Management 188.8.131.52
- EPM 11.1.2.x - Binding Host Name to have Essbase bind only to the IP address
- Essbase BSO Parallel Calculation and Calculator Cache
- OBIEE 11.1.1 - Tuning Guide Script v1
- Adding trim functions to the column expressions in ODI
- EPM 184.108.40.206.500 - Enable HFM Thin Driver on Exlaytics server
- Getting started with Weblogic Scripting Tool for OBI
- Exalytics OVM 3.2.x - Increase Send Queue Length (txqueuelen) for VM guest (DomU) VIF
- Using the @CURRMBR Function
- Configuring OBIEE 220.127.116.11.x with Full End to End SSL