As rumored long time ago, HFM 184.108.40.206 has been ported to Java and is now "platform independent" software. At the moment this means that you can install HFM on Windows Server and on Oracle Exalytics. Currently there is no support for commodity Linux servers which is a pity... Hopefully Oracle will consider adding this possilibity in the future as it would open interesting new possibilities for on-premise installations.
Most notable new features are:
- Reworked HFM engine:
- HFM application server components
implemented in Javapartly written in Java (the cluster controller part) and partly in native C++ code (the HFM application process). HFM no longer relies on Windows technologies like IIS and DCOM.
- Oracle reports that HFM performance is improved for consolidations and data retrieval tasks due to optimizations in the datasource engine. The user interface has also been optimized for better responsiveness.
- Most of the HFM utility programs are not available in this version anymore. See more details about the utilities later in this post.
- Configuration Settings: Memory parameters and other HFM application server settings have been moved to the web interface. The settings are now stored in the HFM database.
- New web based profile editor for creating .PER files (in case you want to use "classic" HFM administration for creating applications)
- Reordering Tabs: Nice small tweak to the web user interface - you can move around tabs (forms, grids, system reports etc.) that are open in an HFM application in Workspace
- Browser support: Internet Explorer 9, 10, 11 and Firefox 31 ESR (note that support for IE8 has been dropped)
- Supported server platforms: Windows Server 2008 and 2012 (including all SP levels and R2), Oracle Exalytics
- Database server support updated with Oracle 220.127.116.11+ and MS SQL Server 2012
Let's have a look at Workspace and HFM web interfaces in 18.104.22.168. Apart from the black title bar there are no obvious changes in Workspace design and layout.
The Consolidation Administration view also looks pretty much the same as before. Two new features are visible here: menu item for the web based Profile Editor and another for the Settings view.
In the Profile Editor you can create and save new .PER files and also create new HFM applications based on the selected settings.
The Manage Settings view lists the HFM system settings. Each setting includes a description and also information about supported values. The settings can be set globally or per applications and they are stored in HFM database in a new table called XFM_PARAMETERS.
Besides the old memory settings there are some interesting new ones (just to mention a few):
- DefaultColFetchSize/DefaultRowFetchSize: Set the number of columns and rows to be pre-fetched when loading forms and grids (may be used to eliminate the "fetching data" message that some users find annoying)
- EnableRulesLogging: Enable debug logging for HFM rules
Note that the default memory settings are much higher compared to previous versions:
- default MaxNumDataRecordsInRAM = 30000000
- default MinDataCacheSizeInMB = 2250 MB
- default MaxDataCacheSizeInMB = 4450 MB
This is a nice feature for production setups but for private sandbox VMs you may want to decrease MinDataCacheSizeInMB to prevent all HFM application processes from consuming 2.5 GB of memory right from the start.
The HFM sample application files are included in the HFM client installer just like in previous 11.2.3 releases. The Windows client still exists in this version but according to Oracle it will be replaced by a web based metadata editor at some point in the future.
I used LCM to load the sample application artifacts from Comma4Dim_LCM.zip. Here you can see a new LCM feature that is easy to miss: Application Snapshots. This functionality replaces the classic CopyApplication utility as it can be used to save the complete state of an HFM application.
An application snapshot consists of XML metadata and a backup file that includes dumps of all database tables belonging to the application.
Note the following statement from the EPM Lifecycle Management Guide:
"Application Snapshot migration requires all users to be logged out of the application. The system logs out all users and shuts down the application if there are no active tasks present for the application. The Application Snapshot is exported at the end of the migration after processing other artifacts. When importing, the Application Snapshot can not be selected with other artifacts."
After loading all application components we can start the application. To me the HFM web interface looks identical to that in version 22.214.171.124. I ran my initial tests on a VM running on my (rather sluggish) laptop so unfortunately I can't really say if the UI is more responsive compared to previous releases or not.
This is what's happening under the hood... A new service named "Oracle Hyperion Financial Management - Java Server" now takes care of HFM cluster management tasks and therefore replaces the old HsxServer.exe process.
When an HFM application is started the Java Server starts an application process. Instead of HsvDataSource.exe the process is now called XFMDataSource and is
The way HFM logs are generated has been changed. I have yet to figure out the changes though because the EPM Troubleshooting Guide is not updated to match this version (still refers to the HFM Errorlog Viewer utility that no longer exists).
ODL format is the only available logging option - the HsvEventLog style is now a thing of the past. The actual content written in the logs still looks familiar though.
[2015-01-29T14:39:37.763123+02:00] [XFM] [TRACE:1] [EPMHFM-00000] [XFM] [ecid: XDS.0000.0000.0000.0001] [File: Pager.cpp] [Line: 187] [userId: ] [appName: COMMA4DIM] [pid: 2220] [tid: 6832] [host: epmtest1] [nwaddr: [fe80::ac76:f6a6:743a:a01%12]:0;192.168.245.134:0;] [errorCode: 0] [srcException: NotSpec] [errType: 1] [dbUpdate: 1] [126.96.36.199.000.4847] [[Pager(wof) Settings : MinDataCacheSizeInMB = 2250 MaxDataCacheSizeInMB = 4500 GrowByDataCacheSizeInMB = 25 MaxCacheSizeInDataRecs = 42130285 lMaxNumDataRecordsInRAM = 30000000 lPageInBatchSize = 500 COTFSize = 20480]]
[2015-01-29T14:42:29.741167+02:00] [XFM] [TRACE:1] [EPMHFM-00000] [XFM] [ecid: XDS.0000.0000.0000.0001] [File: CHsvDSData2.cpp] [Line: 708] [userId: ] [appName: COMMA4DIM] [pid: 2220] [tid: 6832] [host: epmtest1] [nwaddr: [fe80::ac76:f6a6:743a:a01%12]:0;192.168.245.134:0;] [errorCode: 0] [srcException: NotSpec] [errType: 1] [dbUpdate: 2] [188.8.131.52.000.4847] [[CHsvDSData2 : 64-bit : PID=2220 : COMMA4DIM : Registry Settings: LogDebugInfo = 0; SQLCommandTimeout = 60; EnableEntireCubeReloading = 0; NumMinutesBeforeCheckingLRU = 15;
As I mentioned before the utilities that have previously been bundled with HFM have mostly disappeared in this version. This message can be found in the installation directory ...\EPMSystem11R1\products\FinancialManagement\Utilities:
"Financial Management Utilities are deprecated from 184.108.40.206 release."
Notes for the individual utilities:
- The HFM Metadata Merge Utility: User can view and accept or decline the changes in a metadata file. Generates an HTML report and a file with the merged data. See the Financial Management Administrator’s Guide for additional information.
- Application upgrade utility is deprecated. EPM System Configurator is used to upgrade database schema to the latest version.
- Copy Application Utility is deprecated. The Application Snapshot functionality in LCM can be used to backup and restore applications.
- Notepad++ is recommended for editing HFM Rules and Member Lists files (*.rle or *.lst).
- Rules Migrator is deprecated. Use application extracts to extract rules in XML format. Alternatively RLE files can be imported into Calc Manager.
Most of the changes in HFM 220.127.116.11 seem to have happened "under the hood" as was expected. I am planning to run tests with real HFM applications on proper server hardware to see what kind of effect the new engine has on consolidation times. I would be delighted to hear your experiences about running your applications on the new version too! I will be posting mine on this blog and also on my Twitter account @HVilminko.
- EPM 18.104.22.168 installation media (available only on Oracle Technology Network at the moment - note that OTN downloads are not officially supported by Oracle so you might want to wait for the release to appear on eDelivery): Hyperion Performance Management and BI Downloads
- Full product documentation on the Oracle Help Center website: Oracle Enterprise Performance Management System Documentation Release 22.214.171.124
- Platform and Client Certification matrix document for EPM 11.1.2.x (updated to include information for 126.96.36.199)
- Blog post by John Goodwin: EPM 188.8.131.52 Installation and configuration