Thursday, 16 November 2017

...Smartview and OneDrive



Recently (July 2017), I discovered a new functionality of OneDrive which allows multiple users to work on the same file concurrently and I think it is called real time collaboration. This seems to be an amazing feature if you are preparing a presentation and you are collaborating with someone who is in the other side of the world. Unfortunately, it can be a huge inconvenience if you are using SmartView.

Thursday, 9 November 2017

...Financial reports and Shared Services



A few months ago, we were ready for our monthly submission. Everything was quiet and I was relaxed enjoying our Cloud environment...until we received an alert from our monitoring tool that the first of the two FR WebLogic servers auto-restarted. Of course, having a WebLogic server auto-restarting was not a problem since that was the process. Until five minutes later

Thursday, 2 November 2017

...CPU utilisation in HFM



There are 3 settings that manage the CPU utilisation.

  •  MaxNumConcurrentConsolidations: The number of concurrent consolidations that can run in a server at one time. This setting will adjust the total number of consolidations that run in one server regardless the number.
  • NumConsolidationThreads: The number of CPU treads that can be used to multi-thread a consolidation. A consolidation with 32 threads will finish quicker than a consolidation with 8 threads but the first one will use all the available CPU.
  • ConsolidationMultiThreadingScheme

Thursday, 26 October 2017

...Memory utilisation in HFM


Since version 11.x, Oracle has released the 64-bit version of HFM. The benefit is that the 64-bit version of HFM can hold more data in memory comparing to the 32-bit version.

Based on Oracle documentation, HFM virtual address space is dictated by the OS. So, if you have an application with large subcubes (large scenarios, dense data, big number of scenario) which struggles in the 32-bit environment,

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

...writing!



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.


Thanos

Sunday, 9 April 2017

..RTFM


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

...Smartview and OneDrive

Recently (July 2017), I discovered a new functionality of OneDrive which allows multiple users to work on the same file concurrently a...