Tuesday, September 27, 2016

HFM Java API Part 1: Getting Started

Ok, Kscope16 went by and the conference was awesome. My summer holiday is also far gone and it was nice even though the weather could have been better (but hey, I live in Finland, not in Spain or Florida so some fluctuations are expected). After getting back to work in August I have been very busy helping a couple of customers who have gone live with their new HFM 11.1.2.4 environments or are in the process of doing so. But now it's time to update the blog again!

I did a presentation about the new HFM Java API in Kscope16 and was glad to hear that many developers are already using it to achieve some cool things - like Ricardo and Rodrigo of DEVEPM.com with their ODI KM (how's the paper doing guys? ;). I decided to release my short "Getting Started" document to public to make it slightly easier for to people to pick up JDeveloper and get their first project built using the Java API.

Link: Set Up New HFM API Project In JDeveloper (PDF document)

After getting the IDE ready you can start developing code for your Java program. In the next post I will concentrate on the coding part and show you examples of common tasks in HFM such as extracting data and running consolidations.

Thursday, May 5, 2016

Financial Reporting Web Studio Arrives To On-Premise EPM

If you have attended an Oracle EPM roadmap session lately you have most probably heard that unlike previous years a new EPM release is not scheduled for 2016. While waiting for the big 12c release to drop, new updates and features will be added to the current version in the form of Patch Set Updates. HFM PSU 11.1.2.4.200 was a prime example of this strategy and now Financial Reporting is the next product to get a feature-laden update.

Financial Reporting PSU 11.1.2.4.701 was released today and it contains two big changes: FR Web Studio (a web-based report authoring tool) and an updated charting engine. I applied the PSU on my virtual machine running EPM 11.1.2.4 and took a peek at these new features.

Thursday, March 31, 2016

Copy HFM Applications Using The Import Application Feature

In this post I document the steps required to configure the Import Application feature introduced in HFM 11.1.2.4.200. I recommend reading my earlier post about the Patch Set Update if you haven't done that already. Note that the configuration is database vendor specific and I used MS SQL Server – if you need guidance for setting things up with an Oracle database you can see Larry Lapp's recent blog post about the same topic.

Prerequisites

  • HFM with Patch Set Update 11.1.2.4.200 (patch number 21225611) installed 
  • Access to SQL Server Management Studio with sysadmin privileges
  • SYSADMIN role granted to the SQL login used by HFM (Yes – the almighty sysadmin role. This requirement is documented as known issue #21032270 in the PSU .200 readme)

Thursday, March 3, 2016

Quick Review Of HFM Patch Set Update 11.1.2.4.200

Oracle has released another big PSU to HFM 11.1.2.4. This one has been in the works for a long time so I was eager to test the update ASAP even though I'm still jet-lagged after returning from a two-week vacation in the Far East.

Version number reads "Oracle Hyperion Financial Management, Fusion Edition - 11.1.2.4.200.5149"

New Features

Let's start with the most interesting bits. The list of new features included in the readme file is long but slightly misleading... Most of the "new" functions have already been included in PSU .100 and just listed again as this is a cumulative patch. Read on to find out what actually is new in this Patch Set Update.

Monday, December 21, 2015

FDMEE Patch Set Update 11.1.2.4.100

Here's a quick update for those who are running FDMEE version 11.1.2.4. The big Patch Set Update .100 has been released - just in time for Christmas! Because my friend Francisco is the real expert when it comes to the product in question, I'll let him explain you what's new in this update.

Oracle resources (Oracle account required):


Tuesday, December 15, 2015

Kscope16 Conference

The Kscope16 conference will take place in Chicago on June 26th - 30th, 2016. I am pleased to inform you that I will be there to present two sessions about my favorite Hyperion product:
  • Unravel The Secrets of The New HFM API
  • Upgrading To The Latest HFM Version? Set Your Expectations Right!
The ODTUG content review teams have been working hard to get tons of of great sessions selected so book your place early!


Friday, October 30, 2015

Copy Application Utility For HFM 11.1.2.4 - Well, sort of...

Oracle has just released a new patch for Financial Management 11.1.2.3. The patch delivers what many (if not all) customers who have adopted the latest HFM release have been asking for: a version of the Copy Application utility that works with HFM 11.1.2.4. The following actions are possible using the updated utility:
  • Copy HFM applications between different 11.1.2.4 environments (both need to have minimum patch level of 11.1.2.4.100)
  • Copy HFM applications from older release (11.1.2.x) to 11.1.2.4. The Upgrade Applications taks must be performed in EPM System Configurator afterwards.