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

Wednesday, 13 April 2016

...Org by Period

Recently, in the OTN forum, we were discussing the functionality of Org by Period.

Org by Period specifies whether the application allows new consolidation structures to co-exist with previous consolidation structures in the same application.  If it will be set to ‘Y’, it will enable the functionality to activate or deactivate legal entities by reporting period.

As an example, let's consider entity AB which should be consolidate to parent A for period P1 to P3 and then consolidated to parent B for periods P4 to P12. In order to achieve this, in the Ownership management module the entity would be flagged as Active under parent A for periods P1 to P3 and then it will be flagged as Inactive. For periods P4 to P12, the entity will be flagged as Inactive for parent entity A and Active for parent entity B.

Based on this, the parent entity A would retain the values on a YTD basis for only the data that came from P1 to P3.  Data from periods P4 to P12 would be only consolidate to Parent B.

Finally, the metadata would show the entity underneath both Parent A and Parent B, though the various metadata selector dialogs have a "show active only" button when you want to show only the current period's active structure.




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 tha...