Thursday, 19 October 2017

...Records & Subcubes in HFM

A few years ago, I decided to spend time to understand how HFM calculation engine works with aim to improve the performance of the rules. The first stop was the HFM manual, the basic design considerations and the section that is referring to subcubes to understand the calculation mechanism.

Wednesday, 19 July 2017


Hi all,

Just to say that I am still around since a friend told me yesterday that I do not write any more.

Actually, I was thinking that I have not posted anything for a few months and I need to post one of the topics that challenges me but I have just been tied up with the reviewing our processes and preparing application updates.

The good news is that as soon as I will finish with this I will participate in another amazing project the coming year which hopefully will introduce a new way of reporting data.

Blog soon.


Sunday, 9 April 2017


Hi all,

This is a post that I have in mind to write for at least 6 months but I kept on postponing due to the project...

Back in March 2016…

Just before the half year submission development work has stopped, most of the HFM users are on holidays and the number of support tickets is small. So, I decided that it was training time since version was now stable enough and an HFM Cloud migration project was about to start. 

I logged in the Oracle documentation portal and I started going through the documents to identify any changes. 

Wednesday, 29 March 2017

...the Cloud vs On premise decision

Hi all,

The last few years, one of the trendiest topics of discussion is Cloud vs On Premise. Different groups of people in multiple forums keep on discussing whether it worth having an On Premise environment or migrating to IaaS or SaaS or PaaS will create more value? 

My opinion is that it depends...

Saturday, 12 November 2016

...loading APP files in HFM

I have not posted any thoughts recently because I am working on an amazing migration to the Cloud project and I spend most of my time there. However, recently I got in a situation which reminded me of a discussion that I had a few months ago in OTN. The discussion was related with issues that users had with loading APP files in their upgraded applications.

In my case, we were working on upgrading the applications from to We followed the process suggested by Oracle and we upgraded to and then moved the applications to When I started testing the upgraded applications I found that in one out of the three applications it was not possible to extract and reload the extracted metadata without corrupting the application.

Thursday, 30 June 2016

... where Hyperion comes from?

I hope you do not expect that this is a serious post because it is not... however, it is a post that I am really proud of...

So, where Hyperion comes from?

Wednesday, 15 June 2016

...Calculation status: OK SC

     A few weeks ago, I was working on an application update. I started the update on Friday afternoon and thankfully everything went well. I loaded the new metadata and new rules without any problem, completed the "Clear Invalid data" task in 20minutes and then I started the overnight consolidation in order to reconsolidate the whole application and get the status OK in all scenarios/years/periods. I was home before 7pm

...Records & Subcubes in HFM

A few years ago, I decided to spend time to understand how HFM calculation engine works with aim to improve the performance of the r...