Simpler, Quicker, Better
Today I spent time working out why I could not convert some text values I had pasted from a FR report to Excel into numbers. It turns out the text values were padded with non breaking spaces which TRIM() did
In How to compare Oracle Financial Management (HFM) metadata – Part 1 I discussed how metadata could be compared using a script to sort the members sections of HFM metadata APP fles and then compare the files using file comparison software.
Occasionally I am asked to create a protected Excel workbook where users are only able to enter data into specific cells. For example, in the above sheet users can only input into cream cells. This is done by unlocking
After a long walk through Excel I arrived at the entrance to Oracle Open World. I had forgotten how big Excel is. My first session was Tracey Edwards talking about her life and Maiden, the first all-female crewed yacht to
When updating an HFM application it is very useful to be able to identify the changes that are being loaded. If you have ever tried to do this by comparing APP files using file comparison software you will know it
I have just finished an FCCS project where consolidations were running very slowly. Someone suggested using @CALCMODE(BOTTOMUP) as shown in the following example. This improved the consolidation time by a couple of orders of magnitude! /* Checks Balance Sheet balances
This post will tell you how to get HFM to spot misspelled variables in rules files automatically. For example. if you write run a rule like this: Sub Calculate AccountList = HS.Account.List(“”,”AList”) For Each AccountMember In AccountList HS.Clear “A#” &
One of our tech heroes is Stanley Hooker who designed the engines for Concorde, hence the picture. I have just been watching a YouTube video about his career. One of my favourite sections is at the end when he says
This post describes a security model for larger HFM applications (roughly more than 50 users or 50 entities). The model is probably too complex for smaller applications (roughly less than 10 users or 10 entities). However, elements of the model,
For those not already familiar with Calc Manager, it is Oracle’s visual tool for creating rules for HFM and Planning. In my experience Calc Manager is not widely used to create HFM rules. However it is well worth looking at